…_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized… rate can be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with noticeable spikes…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first… for Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns in the… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… I ran the benchmark above, we were using Linux 2.6.32, as my blog says. We’re now on 2.6.38, and whenever is the next time our servers reboot, … what ‘x’ we use then, we’re currently on 3.0). But I agree with you that there’s a difference…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 5 Comments
… in 2012. So yes, the default should be changed to ‘0‘ which means “choose automatically”, which in turn means “choose depth… pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and should determine…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… that the lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While…_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler… Handler_mrr_key_refills N/A N/A N/A 0 0 0 Handler_mrr_rowid_refills N/A N/A N/A 22 0 0 Handler_read_key 1829910 4440511 4372096 1801917 1790641 1805995 Handler…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… a slight increase in 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… 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1 Handler_mrr_rowid_refills N/A N/A… 136077 136094 136366 136163 136435 Innodb_buffer_pool_read_ahead 0 20920 23669 20920 23734 Innodb_buffer_pool_read_requests 1361851…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look…
Post: Announcing Percona XtraBackup 1.6.6
April 4, 2012 By 3 Comments
… announce the latest minor release in the Percona XtraBackup 1.6 series. We recognise that not everybody will want or be… new major release, Percona XtraBackup 2.0 and so we’re also releasing Percona XtraBackup 1.6.6. This is a minor release… repositories are now carrying Percona XtraBackup 2.0.0, so you won’t see 1.6.6 there. We’re also keeping the documentation…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… (Generally Available; i.e. stable) release of Percona XtraBackup 2.0. We have worked hard since our last major release on….0.0 release contains no changes from the last beta (1.9.2), only the version number has changed. New since 1.6… – 16:20 @ Ballroom F You can download Percona XtraBackup 2.0.0 from our downloads site or install it using our YUM…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… restored. mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0.05 sec) Success! Your salaries data is back. But… sec) mysql> show tables; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0.00 sec) So, as you can see, I now…
