… fit. But with all 4 indexes the data itself is 2 or 3 times bigger, and the B-tree nodes are… IOstat. Tim’s measurements (http://www.tokutek.com/2012/01/1-billion-insertions-%E2%80%93-the-wait-is-over/) on… for version you used is http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages of the newer…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ‘MB’) DATA, CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free > 0 limit 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally… = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer…
Post: Testing Fusion-io ioDrive - now with driver 3.1
May 7, 2012 By 2 Comments
… about driver and firmware: Firmware v6.0.0, rev 107006. Fusion-io driver version: 3.1.1 build 172. Actually an upgrade was not… data. So there are results for driver 3.1 (with comparison to previous driver 2.3) Random writes: For random writes there… 3.1 Driver (remember to copy your data before). Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… θ=1.1, then if row 1 accessed 1,000,000 times, then row 2 is : 1,000,000/(2^1.1)=466,516 times, row 3: 1,000,000/(2^1.1)=298,652 times, …, row id=10000 : 1,000,000/(10,000^1.1) = 39 times. Obviously with θ=0 we are…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… 0 27638, ACTIVE 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread… intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… (LinksTbl2.deactive != 1) AND (LinksTbl2.item_desc =1) AND (LinksTbl2.hidden_element!=1) AND (FileTbl.hidden_element!=1) AND (FileTbl.folder_desc<2) AND (FileTbl.deactive!=1) AND (LinksTbl2.converted_from_id IS NULL OR LinksTbl2.converted_from_id=0…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… there is more or less stable performance only for 1 thread. For 2 or more, the throughput varies a lot from second…-75 percentiles. So there is no grow in throughput after 2 threads, and the result averages at 300 MiB/sec. I… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… devices. This is ioDrive2 Duo 2.4TB card and it is visible to OS as two devices (1.2TB each), which can… supply. Fusion-io ioDrive2 Firmware v6.0.0, rev 107004 Public, Fusion-io driver version: 3.1.1. Now to the results. For this… synchronous IO: There is also excellent response time characteristics. 0.25ms and 0.19ms for 8 threads, single and Duo cases. In…
Comment: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
That limitation is lifted, yes. It does need some kind of a unique key. The 2.1 version is a complete rewrite of the tool, though, and your experiences with 2.0 probably won’t indicate how 2.1 will work for you.
