…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…buffer pool. Such process means the following variables are important. Checkpointing interval This is mainly controlled by size of log files as Innodb needs to…to recover longer. Buffer Pool Size This affects recovery time from two parts aspects – first if you have small buffer pool…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size compared to…updates. Value 0 is a bit faster but is a bit less secure as you can lose transactions even in case MySQL…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…mysql, 500w (around 50GB of data) on RAID10. I used innodb_buffer_pool_size=24G, innodb_log_file_size=2000M (innodb_log_files_in_group=2), and innodb…to fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer_pool…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… sec) Now let’s see how performance is affected when …VARCHAR column to trigger table rebuilds without affecting the table size. mysql> SET… copying the data to a temporary table without updating indexes took 18 …test with innodb_buffer_pool_sizeset to approximately 1/10th of the dataset: mysql> SET…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… enabling log_slave_updates, setting innodb_flush_log_… buffer pool size could cause performance problems. MySQL Restart MySQL Restarts…buffer pool content is lost on restart. Many people understanding this do not quite recognize how…24+hours to feel 200GB buffer pool. Automatic Buffer Pool Save…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
How does Buffer Pool size affects Innodb Performance ? I always expected the effect to be positive, Innodb with large buffer pool to…to scan good portion of it finding place to insert the page. So I took a shot at restarting MySQL with much smaller buffer pool size…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… mysqld mysqld buf_LRU_invalidate_tablespace 168823 0.6009 mysql mysql completion_hash_update(hashtable*, char*, unsigned int, char*) 53667 0.1910 oprofiled… really need to think how large it can get. We’re already seeing half a TB innodb_buffer_pool size and I expect it to close 1TB…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is a safe bet. I set it to 12G on 16GB box. UPDATE…
