… enterprise grade storage. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage… metrics for particular IO block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode…=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval=10 run You may see I gather…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… to test it. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage… metrics for particular IO block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode…=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval=10 run You may see I gather…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… [21,30],but it came out my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0… 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… /mnt/stec sysbench –test=fileio –file-num=1 –file-total-size=${size}G prepare sync echo 3 > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=3600 –max-requests…=0 –file-io-mode=sync –file-block-size=16384 –report-interval=10 run | tee -a run$size.thr$numthreads.txt done done Follow…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions: MySQL 5.5.20, Percona Server… to improve throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And to aggregate results and provide final numbers, jitter…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6 and… well. But this works only with joins and specifically with Block Access Join Algorithms. So I am not going to cover… cover it in my next post which will be on Block Access Join Algorithms. Conclusion There is a huge speedup when…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but … Run SHOW ENGINE INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
Vadim, This is indeed very useful. We (at the Sizing Servers Lab, a university lab) have implemented this in our …/show/3846/quad-xeon-7500-the-best-virtualized-datacenter-building-block-/4. We went a step further 1) By turning logs…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… Server: being adaptive I mentioned that I used innodb-log-block-size=4096 in Percona Server to get better throughput, but later… two runs, one with default innodb-log-block-size ( 512 bytes), and another with –innodb-log-block-size=4096. Full benchmark command is tpcc… to IO block size. And I know that other SSD/Flash drives like to have IO multiplied to their internal block size (which is…
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 8 Comments
It is well known fact that InnoDB standard page size is 16K or 16384 bytes. Sometime ago we added feature … 4K or 8K (innodb_page_size). That maybe useful for SSD that operates with 4K blocks and you can get really much… block size with more possibilities to compress (of course it is workload depended). This is also in our plans. Having 4K-64K block sizes…
