… PID file exists.
Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW FULL PROCESSLIST for patterns that indicate similar … the checks in that list, there are several others that can be performed with existing plugins, so there was no need to write new ones…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By Leave a Comment
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 7 Comments
SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. By that, …’t captured in the profile.
The above query is something I developed for High Performance MySQL Third Edition, by the way. The book should be available in a matter…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By Leave a Comment
… now replaced by the new project), making the Cacti templates use caching was important for two reasons:
Performance. Cacti runs some of its polling processes serially, so if each graph has to reach out to the MySQL server and retrieve a bunch of data…
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
… deciding what to compare to what. A lot of performance claims have been made about MariaDB versus MySQL, but this blog post is one of the … the MariaDB team to publish their benchmarks. Here is one place where some performance claims are made, and there are hints at extensive benchmarks: http://www…
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
…4 as these are real choices people care about performance have now. The comparison against MySQL would be mainly of academic interest. These results… would be natural choice, however if you have need for high performance with complicated queries, MariaDB has additional optimizations for, it can be…
Post: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
…). No surprise I wanted to check how all improvements affect general performance.
So I why don’t we run old good sysbench benchmark.
…
The graphical results:
Throughput (more is better)
Threads MariaDB 5.3.4 MySQL 5.5.20 Ratio
1 252 271 0.9298893
2 412…
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
> [..] MariaDB with the current MySQL 5.5, and probably more fair would be to compare MariaDB 5.3 vs MySQL 5.6.
If your goal was to compare prerelease products, sure, but that wasn’t the goal that you established in the first paragraph — “check how all improvements affect general performance“.
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
2 alex.
Indeed, I never published benchmarks Percona Server vs MySQL 5.5, like this
http://www.mysqlperformanceblog.com/2012/01/17/benchmarks-of-new-innodb_flush_neighbor_pages/
from which you can’t get conclusion that Percona Server performs better than MySQL 5.5.
Comment: Can we improve MySQL variable handling ?
February 19, 2012 By 8 Comments
Shlomi,
Yes… I think one of the problems here is MySQL concept of treating all options as command line parameters which may not come from config …I agree tracking history of variables is a good thing to do.. you might be able to learn a lot about performance impact from long change correlation.
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… version and observing the difference. Sometimes though it might not show performance difference ran alone on idle system – in this case you might… especially be helpful.
Once you have spotted the query which performs differently between MySQL Server versions you should:
Check Query Plan Run …
