… bigger, and the B-tree nodes are filled perhaps only 3/4 full, making the database a total of, say, 4… 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 version…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer… primary index, and against the table purchases_index which has 3 secondary indexes. Another thing I would like to share is…
Post: Testing Fusion-io ioDrive - now with driver 3.1
May 7, 2012 By 2 Comments
… pointed that it may be fixed in new drivers VSL 3.1.1. I am not sure if this driver is available for…. Information about driver and firmware: Firmware v6.0.0, rev 107006. Fusion-io driver version: 3.1.1 build 172. Actually an upgrade was not… to 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
… 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…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
…, 1 row affected (0.00 sec) root@localhost:test 14:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0…: —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…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… SQL query executed in 0.03 secs whereas the second SQL query when using index merge executes in 3.8 secs. I…<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 ioDrive2 Duo
May 10, 2012 By 12 Comments
… power 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… !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 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 of previous… more interesting when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (i.e… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Post: Percona Toolkit 2.0.4 released
March 8, 2012 By Leave a Comment
Percona Toolkit version 2.0.4 is available for immediate download. This release fixes 25 …) and only fix bugs in the current (2.0) series. When 2.1 is released as GA, we will freeze its features… work on 2.2, and so on. After the 2.0.3 release, which included complete rewrites of some tools, it was…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…, it had many limitations and missing features. The new 2.1 version of the tool removes those limitations and makes the… be many talks about various parts of the toolkit: A 3-hour tutorial about the toolkit on Tuesday Daniel will talk… Percona Toolkit’s release today, there is also a version 1.0 GA release of the Percona Monitoring Plugins project. It features…
