September 2, 2014

Practical MySQL performance optimization: May 14 Webinar

Practical MySQL performance optimization: May 14 WebinarAchieving the best possible MySQL Performance doesn’t have to be complicated. It’s all about knowing which tools are designed for the task at hand – along with some basic (yet often overlooked) best practices.

Join me Wednesday, May 14 at 10 a.m. Pacific for a free webinar titled, “Practical MySQL performance optimization.” I’ll be sharing the main areas for improving MySQL performance – along with what to specifically focus on in each. These will include:

  • Hardware
  • MySQL Configuration
  • Schema and Queries
  • Application Architecture

And as I mentioned earlier, I’ll also show you the best tools for the job and how to use them efficiently. This will help you optimize your time by focusing on the queries that are most important for your application.

At the end of this webinar, you will know how to optimize MySQL performance in the most practical way possible. The webinar is free but I recommend registering now to reserve your spot. I hope to see you on May 14!

About Peter Zaitsev

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.

Comments

  1. Sam says:

    Dear Peter,

    I really like your article. Right now, I have this jsp web portal in tomcat6.5 running on CentOS machine. The database is MySQL. There is one table that is populating about 25,000 records everytime someone runs the application. I don’t do the insert because that is done by a java program, but I have to do a single select statement on the table(select number as thenumber, convert((hex(value)) using ascii)as filevalue, description as desc from table). Right now, the table is running a little bit slow because of the large amount of data. I was wondering if there’s a way to improve the performance on the query or is there’s a way to improve it on MySQL server. I read some of your posing and saw a select statement using between – would that help with? I know in Oracle you can do it by processing data by records – does mysql do something similar to oracle? Comments are welcome! Thank you!

    Cheers,
    Sam

Speak Your Mind

*