…chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. …4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that …can be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with …
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… 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
…of this benchmark, I have used TPC-H Query #10 and ran it on TPC-H dataset (InnoDB tables…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: 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: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…the following changes were made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ …_shippriority order by revenue desc, o_orderdate LIMIT 10; In-memory workload Now let’s see …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: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… mysql-data 0.00 mysql-logs sb -wi-ao 10.00g Suppose… | 0 | +———-+ 1 row in set (0.00 sec) mysql> show tables; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… every 10 sec to see stability of results. Graphical result: Tabular: Tables HDD SDD Ratio 32 1226 1644 1.340946 … 89 486 5.460674 192 79 484 6.126582 256 75 495 6.600000 As you can see, on the…function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js….
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…=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… 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
… ‘show engine innodb status’, is shows there are 10 io threads(4 are read, 4 are write)…/O thread 0 (thread id: 18578) state: waiting for completed aio requests (insert buffer thread) I/O thread 1 … completed aio requests (read thread) I/O thread 6 (thread id: 18584) state: waiting for completed aio …
