… tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally…_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx…_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… even for small amount of threads. For 8 threads the 95% response time is 0.69ms. Now let me get back to… synchronous IO varying amount of threads and with measurements every 1 sec to see how bad are drops. So there is…. Maybe 8 threads in the first graph is too much and we should go with 1 thread? So even with 1 async write…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
…:22>delete from t where i=25; Query OK, 1 row affected (0.00 sec) root@localhost:test 14:35:29>select…: —TRANSACTION 0 27638, ACTIVE 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql tables in use 1, locked 1 LOCK WAIT… intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; —————— The…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable throughput topping… IO mode, now for 1-64 threads. The throughput: We are getting to the peak throughput at 8 threads. And response time: For 8 threads, we may expect 0.62ms response time. In general…
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…<2) AND (FileTbl.deactive!=1) AND (LinksTbl2.converted_from_id IS NULL OR LinksTbl2.converted_from_id=0) ORDER BY LinksTbl2.tstamp…_db.LinksTbl2.treeid | 1 | Using where | +—-+————-+————-+————-+————————————————————–+——————–+———+———————————-+——+————————————————–+ 4 rows in set (0.00 sec)
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… more interesting when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (i.e… better than for Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns… timeline (from 0 to 1800 sec): I am not sure how to explain it, that with 4 and 8 threads the pattern…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… card and it is visible to OS as two devices (1.2TB each), which can be connected together via software RAID… supply. Fusion-io ioDrive2 Firmware v6.0.0, rev 107004 Public, Fusion-io driver version: 3.1.1. Now to the results. For this… IO: There is also excellent response time characteristics. 0.25ms and 0.19ms for 8 threads, single and Duo cases. In general ioDrive2…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): It seems that InnoDB is not alone… flashing problems. You can see there periodical stalls in throughput (0 throughput for 20-30 sec period of time). When there… time: For 16 threads, we may expect 0.96ms response time, which increases to 1.62ms under 32 threads. The periodic drops…
Comment: InnoDB's gap locks
April 13, 2012 By 14 Comments
…=latin1 mysql> select * from t; +——+——–+ | i | c | +——+——–+ | 1 | miguel | | 3 | andy | | 5 | aaron | | 8 | repls | +——+——–+ Then I start two transactions, session1 and…: session1> delete from t where i=1; Query OK, 0 rows affected (0.00 sec) Rows affected 0 
Because the row doesn’t exist… | +——+——–+ | 1 | miguel | | 3 | andy | | 5 | aaron | | 8 | repls | +——+——–+ session1> update t set c=”peter” where c=”andy”; Query OK, 0 rows affected (0.00…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
… 1.41/92k 2 1.01/64k 1.65/108k 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.15/9k 1…
