…size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer pool(size of buffer pool…_scan. I tried to increase innodb_lru_scan_depth …MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…increasing…performance on this size will be the same or worse, but will require 1TB in size…buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I… and you can increase it a bit to be on the safe size and scale appropriately….MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… such “it can only do good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most important they often come with a need of warmup, because buffer pool…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…increased from 400 to 2000 by default. Good change making the default practical on larger set of installations innodb_buffer_pool…Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…. Interesting enough because of MySQL scaling issues it is also possible to see performance to go down as you increase buffer pool size. Some threads which would be safely sleeping waiting on IO completion are now finding their data in buffer pool so…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… allocator should help to improve scalability, increase throughput and keep memory footprint under …several memory allocators on the performance/scalability of MySQL server in the read-only … / CPU bound case innodb_buffer_pool_size=52G For every malloc allocator perform the following steps: start…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool… for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance, and BKA…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool…performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…buffer_pool_size you might find better use for memory available. innodb_additional_mem_pool_size This one does not really affect performance…
