…s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the… Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the …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
…I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 …performance variance we see it is a good question how does it affect MySQL performance, and I am going to run some MySQL…s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5…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…performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5…
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… 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…
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…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… could notice EXPLAIN itself was taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries… was wondering if 0 is automatic selection why do we have value of 62 being default in MySQL 5.5 which can produce very expensive plan selections ? Investigating this further I found the following explanation from Timour Katchaounov in MySQL…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 …consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “…=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… the second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as …out our latest stable release (which was 1.6.5 at the time of writing). This beta adds …compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of …
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… t VALUES(31); Query OK, 1 row affected (0.00 sec) After running the delete statement …in your transactions affecting the concurrency and the performance you can disable them in two different ways:…: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE …
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments,…see interval is far from being strict 0.5 sec, but 0.5 is the mean of this random …For example, the famous problem with DROP TABLE performance. Does DROP TABLE, running in separate session, …
