… the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post… optimizer is choosing the query execution plan, is not sufficiently tuned and it is recommended to turn this off. The query…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance significantly… population. This blog‘s articles often illustrate extreme cases, so keep in mind that the vast majority of MySQL installations don’t… configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, with…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…. I claim that somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when you… a long time before the MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically…’s look at that now. This topic deserves an entire blog post, because there are many subtleties including the possibility of…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they can be relevant to… better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included… is why not ZFS ? The ZFS MySQL success story is all over across Sun’s blogs, so why benchmarks are still run…
Page: About This Blog
May 3, 2006 By 48 Comments
…. I also worked on number features for MySQL Performance monitoring and tuning – SHOW MUTEX STATUS, Tuning Innodb mutexes and concurrency control, MMAP IO… our company team page. We have published biographies of other MySQL Performance Blog contributers at Percona Team Page
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…microseconds, maybe a bit longer. This is common in MySQL servers I work with when they’re running a…where we get some “static”, sort of like de-tuning the radio just a little bit (if you … the four fundamental metrics I mentioned in the previous blog post), and much more. If you come to Percona…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…popular service). I thought I should write a blog post that will both answer their question, … systems that are at any level of tuning, from completely untuned to a system that’…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and… did not have to use most of them yet, this Blog, some conference publicity and referrals seems to be doing enough…. It may be as simple as adding few indexes and tuning MySQL Server settings. It is more the question of knowing there…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… published a blog post, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5… get a more or less stable line in MySQL 5.5.8 by tuning innodb_max_dirty_pages_pct and innodb_io… NOTPM. The throughput is about 1.33x better than in “MySQL compatible mode”, though it requires 10500MB for checkpoint age; that…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
… internals insight and a lot of practical experience in MySQL Scaling and Performance Tuning but our Russian-Ukranian English needs a lot… angle plus being author of large amount of popular MySQL tools such as MySQL Toolkit he is surely the man for the… his excellent writer skills – many articles you find at his blog are very smart in depth and elaborate. OK at this…
