…come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for…_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate …performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1… much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does it affect MySQL performance, and I am going to run some MySQL…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places…. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit a lot of the great improvements Oracle has made to the MySQL 5.5…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… performing the benchmark on IO bound workload, mentioned above. Counter 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…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…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… Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first …performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5…
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: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…): ext4 1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case… more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… production use, check out our latest stable release (which was 1.6.5 at the time of writing). This beta adds some… will enable a server restored from backup to give excellent performance without a lengthy “warm up” time. If provisioning a slave…. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163… transactions affecting the concurrency and the performance you can disable them in two different ways: 1- Change the ISOLATION level to READ… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… have a few questions: 1. Will the Percona Toolkit version just released work for regular community MySQL 5.5.23 or does it only work (or work better) with a Percona type version of MySQL – ie one… the lead author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny & Derek Balling…
