… to fill the B-tree pretty efficiently. With a 55GB buffer pool, we would expect the primary table to simply fit… RAM, Inno would hit a memory wall. Given that Memory sizes are perhaps 10 times bigger than they were 4 years…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb…_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized at 55G and I am using 4 buffer pool instances to reduce the contention caused by buffer pool…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full…: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51:16 InnoDB: Started; log sequence number 119… /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I… to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult… e.g instead of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… grade storage. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage… testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=18000 –max-requests… you did not attend my talk – you are welcome to join the webinar. Disclaimer: This benchmark is done as part of…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… test it. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage… testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=18000 –max-requests… you did not attend my talk – you are welcome to join the webinar. Follow @VadimTk !function(d,s,id){var js…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Mark, Probably what you are referring to is provided by the configuration option “innodb_ibuf_accel_rate” available in Percona (as mentioned by Justin). Increasing/decreasing the value of innodb_ibuf_accel_rate, you will increase/decrease the insert buffer activity.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
Partitioning probably reduces the stress on the insert buffer. Does XtraDB/Percona Server have an option to use more IO for insert buffer merges when the ibuf gets too big?
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… in performance which might be the result of the insert buffer filling up and then decreasing performance until some space is… again. XtraDB lets you accelerate the rate at which insert buffer pages are flushed to disk (innodb_ibuf_accel_rate) which… seen big performance difference on insertion rate when increased insert buffer flushing was enabled (using the FB patch, not XtraDB but…
Comment: Side load may massively impact your MySQL Performance
May 15, 2012 By 7 Comments
http://bugs.mysql.com/bug.php?id=45015 (InnoDB buffer pool can be severely affected by table scans)
