… is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer… in set (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has allocated. In fact this is… global memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory usage growing…
Comment: Troubleshooting MySQL Memory Usage
March 22, 2012 By 3 Comments
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: InnoDB memory usage
May 30, 2006 By 6 Comments
… and memory for locking system, size=5 * 4 * NBLOCKS So the final formula for innodb: innodb_buffer_pool_size + innodb_log_buffer_size + innodb_additional…, InnoDB will allocate = 1500M + 20M + 8M + 1500/20M + 17.5M = 1620.5M. Take the additional memory into account when you are planning memory usage…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… do with real memory consumptions. In fact typical server with 8GB of memory will often run with maximum theoretical memory usage of 100GB or… always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them… days need to consider the added memory for InnoDB: specifically, the buffer pool. (There’s also an innodb_additional_mem_pool_size but… there simply is no formula to compute the maximum possible memory usage, and there cannot be because there are some things that…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… using too much memory. I would look at memory consumed by Innodb (it is often higher than innodb_buffer_pool_size) substract memory used by… some mysterous memory which I can’t really explain. It can be several Gigabytes accounting for over 50% of memory usage of MySQL… to SHOW STATUS – threads could account statistics for their own memory usage which is when merged together to show GLOBAL status – this…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… a good use for that memory anyway. Another thing you should keep into account is Innodb allocates more memory in structures related to… be allocated. There are also things like innodb additional memory pool (which can grow more than memory you allocated for it, especially in… can try locking MySQL in memory by using –memlock – just be careful as in case you have memory usage spike you may have…
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 pool…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…tunability, more metrics, more scalability on many cores, and better memory usage. We choose features and fixes based on customer requests …added more memory information and lock information, and fixed problems with lock information. documentation Improvements to InnoDB IO. Improvements of InnoDB IO …
Comment: Why you don't want to shard.
August 12, 2009 By 33 Comments
…, queries against this information are frequent and very varied! Unfortunately, InnoDb is a non starter here due to budget (and therefore… blog post re. partitioning (including advancements in MySQL 5.4), InnoDb, Memory usage, storage requirements, etc that I can take to the powers…
