…size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB…pool, sized to illustrate the case of index being significantly larger than amount of memory… additional Percona Server feature. Lets now see with 6GB buffer pool…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 320 MySQL thread id 30899, query… memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory pool (so you can check if it is sized…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…=2 innodb_file_per_table=1 innodb_doublewrite=0 # Set buffer pool size to 50-80% of your computer’s memory innodb_buffer_pool_size=4G innodb_additional_mem_pool_size=20M # Set the log file size to about 25% of the buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…memory usage too high innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such…memory and cause the server to swap until it is unresponsive and has to be power cycled. In addition…connections problems (the use of fixed-size connection pooling, for example, which can sometimes…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…/mysql/ # You can set .._buffer_pool_size up to 50 – 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…on it with 6GB allocated for innodb_buffer_pool which with other memory needs leaves roughly 1GB for OS … is approximately 30GB in size including indexes which is way more than buffer pool size and OS cache …something along these lines could be very valuable addition. MySQL 5.6 has more changes in IO …
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
…size 1mil records fully fitting in memory. I run it with innodb_thread_concurrency=16 to match threads inside InnoDB…innodb_buffer_pool_size=6GM \ –innodb_additional_mem_pool_size=20M \ –innodb_log_file_size=128M \ –innodb_log_files_in_group=2 \ –innodb_log_buffer_size=8M \ –innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… are available in both MySQL 5.6 and MariaDB 5.5, and MariaDB 5.5 has introduced some additional optimizations which we… entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed… of benchmarking IO bound workload, the InnoDB buffer pool size is set to 1G and the buffer pool was not warmed up, so that…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed… MRR related variable introduced in MySQL 5.6 and MariaDB 5.5 Handler_mrr_init and another additional one introduced in MariaDB…
