I think it’s worth to say here that the InnoDB team has already made some effort to address memory usage problems: http://blogs.innodb.com/wp/2011/12/improving-innodb-memory-usage-continued/ . Results seem very promising, and also maybe these fixes will allow more precise memory usage monitoring.
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced in… when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to… 2.2G Innodb_data_reads 329115 355323 143808 335526 16164 15506 Innodb_pages_read 329115 355323 143808 358308 144798 144881 Innodb_rows_read…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read… when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to… workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory access at sequential locations…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…couple of threshold-based alerts later in this blog post, and explain the need to be … pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as …-memory plugin checks for a single process consuming too much memory and/or for too little free memory…
Comment: Terms of Use
November 3, 2007 By 17 Comments
Peter, The Innodb memory blog posting you have done over the last week or so …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…look up blog posts…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…shared_memory_…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… how InnoDB works internally? Let me show some details. Internally, InnoDB uses two lists for flushing (writing pages from the Innodb buffer pool memory… may see from Dimitri’s post, http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas-tpcclike-workload-on…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is… and memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory… of 10 byte rows is much cheaper than accessing 10MB blog, but it is still much more helpful than number of…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to … InnoDB tries to keep the working set in memory (InnoDB Buffer Pool), therefore the changes made by transactions will occur in volatile memory and…
