… cost, and the performance difference is basically that factor of 4. The variance is lower with only the primary key because… Memory sizes are perhaps 10 times bigger than they were 4 years ago when the iiBench project started, today the challenge… 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
…=’abc’ and Data_free > 0 limit 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space) after this… TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free > 0 limit 10; still the free space remains the same. that…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush…_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized at 55G and I am using 4 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… 3.1 Driver (remember to copy your data before). Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
…db.LinksTbl2.treeid | 1 | Using where | +—-+————-+————-+————-+————————————————————–+——————–+———+———————————-+——+————————————————–+ 4 rows in set (0.00 sec)
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first… to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (i.e. 4 threads) we see some interesting… in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with 4 and 8 threads the…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…file-test-mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=64…I ran random read sync IO mode, now for 1-64 threads. The throughput: We are getting to … sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more …
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… 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…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… IO varying amount of threads and with measurements every 1 sec to see how bad are drops. So there …function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js….’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
… by default uses 25W (turbo=0). To force full power, I load a driver with turbo=1. I also use “maxperformance” formatting for Virident, which gives less capacity (1.2TB visible for user), but reserves internally more space to…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
