…-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first is… 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: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 5 Comments
… default should be changed to ‘0‘ which means “choose automatically”, which in turn means “choose depth 7“. Is this what your blog… if we want a simple magic threshold, the number is “7“. This is also confirmed by looking at the graph of… pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and should determine…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… improvements in this release over the previous stable release, Drizzle 7.0. I plan to write a variety of blog posts on… of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was released last year), there have been over 3… install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how…
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…_o_custkey i_o_custkey 5 dbt3.customer.c_custkey 7 100.00 Using where 1 SIMPLE lineitem ref PRIMARY,i…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages with this feature, previous releases might…mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0.05 sec) Success! Your salaries data is …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 5 Comments
… users do not join lots of tables (less than 7) when using 0 as default value would not impact them. For people who have more than 7 tables in join I think faster execution plan computation would be more important than backward compatibility. In MySQL 5.6…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17… 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! Current…
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
… thread .just like follows: ——– FILE I/O ——– I/O thread 0 (thread id: 18578) state: waiting for completed aio requests (insert…) I/O thread 6 (thread id: 18584) state: waiting for completed aio requests (write thread) I/O thread 7 (thread id: 18585…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…_0 | | 5 | 0 | 11 | 23 | 1560 | 0 | 0 | 7 | 17855 | index | CLUST_IND | | SYS_INDEXES | | 6 | 0 | 5 | 242 | 0 | 3 | 0 | 8 | 7 | unknown | | | | | 7 | 0 | 6 | 3006 | 0 | 0 | 0 | 9 | 6 | unknown | | | | | 8 | 0 | 45 | 0 | 0 | 0 | 0 | 10 | 2 | undo_log | | | | | 9 | 0 | 50 | 0 | 0 | 0 | 0 | 11 | 2…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
….7 0.1 69.6 2853.9 82.4 | 360.2 0.1 0.1 4.2 0.1 1675.6 | 1340.0 0.1 74.6 1596.9 88.0… | 1364.8 0.1 73.3 1559.8 85.1 | 341.1 0.1 0.1 0.7 0.0 1693.7 | 1357.2 0.1 73.6 1480.5 87.1 | 336.5 0.1 0.1 2.1 0.0 1696.2 | 1355.7 0… 626.7 | 502.0 0.1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248.7 6.2 321…
