Blogspot - mysqlha.blogspot.com - High Availability MySQL
General Information:
Latest News:
MySQL Connect 13 Aug 2013 | 06:44 am
The Facebook MySQL teams are presenting at MySQL Connect: Lots and lots of small data by Harrison Fisk MySQL 5.6 at Facebook by Yoshinori Matsunobu Panel session on MySQL 5.6 with Mark Callaghan ....
MySQL 5.6, InnoDB and fast storage 19 May 2013 | 03:03 am
I used a simple workload with sysbench to determine the rate at which InnoDB can read blocks from disk. The workload is read-only and each query fetches 1 row by PK. The workload was IO-bound with a 2...
MySQL 5.6: single-threaded performance regressions 15 May 2013 | 08:06 pm
I ran single-threaded performance tests to compare MySQL using releases 4.0.30, 5.0.85, 5.1.63 and 5.6.11. On my simple tests 4.0.30 is almost 1.5X faster than 5.6.11. I think it is important to reduc...
MySQL 5.6: flushing potential 9 May 2013 | 08:10 pm
For some workloads the InnoDB performance model is very simple. It must flush dirty pages as fast as storage will allow. With a few more bug fixes InnoDB in MySQL 5.6 should be able to do that. The pe...
Configuring InnoDB for MySQL 5.6: innodb_io_capacity, innodb_lru_scan_depth 8 May 2013 | 10:06 pm
Percona published Linkbench results. It looks like they set innodb_io_capacity to a large value but did not increase innodb_lru_scan_depth. I think that is a mistake. This is a mistake that I have mad...
MySQL 5.6 versus 4.0 for a read-only workload 8 May 2013 | 01:13 am
I compared the performance of MySQL 5.6.11 versus 4.0.30 using a read-only workload with sysbench. Performance was much better for 5.6.11 in most cases. At low-concurrency MySQL 4.0 was a bit faster. ...
Good news, MySQL 5.6.11 is here 19 Apr 2013 | 08:00 pm
MySQL 5.6.11 is here with many useful bug fixes. Not so good news - you won't be able to read about those bugs beyond the brief text in the release notes as many of the bug reports are behind the supp...
MySQL 5.6: an incomplete guide to avoiding performance regressions 3 Apr 2013 | 09:58 pm
I spent more time looking at the performance regressions in MySQL 5.6 for single-threaded read-only workloads and I can get 5.6 closer to 5.1 by disabling a few options when building MySQL 5.6 -- opti...
MySQL 5.6: single-thread, update-only 2 Apr 2013 | 06:36 am
This post describes MySQL 5.6 performance for a workload that is update-only and single-threaded. My previous post was for a read-only workload. I think there is a performance regression in MySQL 5.6 ...
LinkBench is here 2 Apr 2013 | 12:44 am
LinkBench is a benchmark that models the social graph OLTP workload at a busy social networking site. It is implemented for MySQL but there is abstraction layer so it should be possible to implement d...
