…-64 threads. Throughput: Response time: For same cases (i.e. 4 threads) we see some interesting patterns. As for response time… better than for Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns… in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with 4 and 8 threads the pattern…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… query executed in 0.03 secs whereas the second SQL query when using index merge executes in 3.8 secs. I dont…_desc); Using where | | 1 | SIMPLE | PersonTbl2 | eq_ref | PRIMARY | PRIMARY | 4 | oslogs_jan02_db.LinksTbl2.userid | 1 | | | 1 | SIMPLE | FileTbl | eq…_db.LinksTbl2.treeid | 1 | Using where | +—-+————-+————-+————-+————————————————————–+——————–+———+———————————-+——+————————————————–+ 4 rows in set (0.00 sec)
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… jump directly to results. First case is random write asynchronous 8 threads IO, the test is done just after a secure… even for small amount of threads. For 8 threads the 95% response time is 0.69ms. Now let me get back to…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
… 0.97/62k 1.65/108k 4 0.27/17k 1.55/102k 0.21/13k 1.55/102k 8 0.13/8k 1.45/95k 0…/185k 0.97/62k 2.57/168k 4 0.27/17k 3.68/241k 0.21/13k 3.41/223k 8 0.13/8k 4.42/290k 0.15/9k 4.16/273k 16 0.12/7k 4.95/325k 0.12/7k 4…
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
…, 4 are write) and a log thread and a insert buffer thread .just like follows: ——– FILE I/O ——– I/O thread 0…: waiting for completed aio requests (read thread) I/O thread 4 (thread id: 18582) state: waiting for completed aio requests (read…: waiting for completed aio requests (write thread) I/O thread 8 (thread id: 18586) state: waiting for completed aio requests (write…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… during these benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note that …’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer_size=6M mrr_buffer_size=6M Note …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 …
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…us following intervals (in sec) between events: 0.61, 0.43, 1.55, 0.18, 0.01, 0.76, 0.09, 1.26, … Or if … threads? You can see it from following graph (1-8 threads): The queue piles up, waiting time grows, and …’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
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… 95 96 97 98 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… 0.00 0.21 1052.67 0.41 8455.97 4.94 4227.98 2.47 8.03 1.01 0.96 0.96 101.44 dm-0 0.00 0.00 1052.67 0.62 8455.97 4…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
….4 90.8 0.0 0.0 4.0 25% 0 3.0 sdj1 0.6 0.2 12.3 0.3 0.1 4.8 9% 0 4.0 sdj1 0.2 0.1 8.7 0.0 0.0 1.4 2% 0 5.0 sdj1 0.7 4….4 17.4 15% 0 27.2 sdj1 0.0 0.0 0.0 0.0 0.0 1.2 0% 0 28.3 sdj1 0.8 0.5 19.3 0.1 0.0 3.2 8% 0 29.3 sdj1 0.0 0.0 0.0 0.1 0.0 9.5 4% 0…
