… MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… query time for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5.6 IO… Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1… Select_scan 1 1 1 1 1 Sort_scan 1 1 1 1 1 As you can see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer…=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler_mrr_init N/A 112 3 1133 1 1 Handler_mrr_key_refills…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, … +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.98 sec) This however will not …
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.1 is now the current stable release in the 5.5… be found in the 5.5.21-25.1 milestone at Launchpad. We are doing another release based on MySQL 5.5.21 as we have… in 5.5.18-23.0. Bug fixed #915814 (Alexey Kopytov). Fixed InnoDB compilation warnings on CentOS 5. Bug fixed #962940 (Laurynas Biveinis). Fixed MySQL…
Post: Percona XtraBackup 1.9.2 released (Beta)
March 29, 2012 By 2 Comments
… release in the process of going towards Percona XtraBackup 2.0.0. This is a BETA quality release and is not inteded… release, you should use the current Stable version – currently 1.6.5 in the 1.6 series at the time of writing. The 1.9.x version numbers will be used to distinguish between…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…. Lets look at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK does not work as …1) | 0 | 0 | 1 | | 10304 | root | localhost | dumptest | Field List | 15 | Waiting for table flush | | 0 | 0 | 4 | | 10305 | root | localhost | dumptest | Query | 0 | NULL | show processlist | 0 | 0 | 1…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version numbers for betas of 2.0 to clearly differentiate… production use, check out our latest stable release (which was 1.6.5 at the time of writing). This beta adds some…
