…200G EBS volumes in software RAID 10. Now let’s come to the… = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_…per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You …as large, because it varies between ~6.5k to ~12.5k INSERTs per…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format … when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (…Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
…H Query #10 and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB …1 1 1 1 1 Created_tmp_tables 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1 Handler_mrr_rowid_refills N/A N/A N/A 1 0…_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 …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…o_shippriority order by revenue desc, o_orderdate LIMIT 10; In-memory workload Now let’s see how … the labels mean as follows: MySQL 5.6 (2) is for MySQL 5.6 w/ buffer size 6M MariaDB …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_…
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… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…0.00 mysql-logs sb -wi-ao 10…0 | +———-+ 1 row in set (0.00 sec) mysql> show tables; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… that, but that option is not available on my CentOS 6.2, so I could not test it. At this point we…=rndwr –max-time=3600 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384 –report-interval=10 run…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i… indexes have 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
… status’, is shows there are 10 io threads(4 are read,…0 (thread id: 18578) state: waiting for completed aio requests (insert buffer thread) I/O thread 1 (thread id: 18579) state: waiting for completed aio requests (log thread) I/O thread 2…(read thread) I/O thread 6 (thread id: 18584) state: waiting…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a….39 102.14 dm-0 0.00 0.00 301.23 0.62 2441.07 4.93 1220.53 2.46 8.10 1.02 3.39… 8.10 1.02 3.20 3.20 102.01 dm-0 0.00 0.00 317.83 0.61 2570.49 4.92 1285.25 2… 0.30 0.55 0.55 29.67 dm-0 0.00 0.00 550.10 0.62 132545.38 4.93 66272.69 2.46 240.69 0.30 0…
