… innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs Fixed: Fix for bug #1131187 introduced a regression that could cause a memory leak if query…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to swap, that…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 24, 2013 By 26 Comments
… our performance, because it prevents us from accurately tracking our memory usage. I have passed along the feedback that you were not…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… EXT4 is pretty surprising.. – did you monitor by chance the memory usage during your tests?.. – I’m asking about because in the…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… 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 which can’t be connected to any known resource use. For example for global memory leaks you would see memory usage…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…, indicating a possible memory bug. Whatever the reason, there is a simple but powerful way to profile MySQL memory usage; the Massif tool from Valgrind. An excerpt from the Massif manual page (Heap memory being simply the allotted pool of memory… memory usage/trigger the memory problem. You could also just leave the server running for some time (for example, if you have experienced memory…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… to worry about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will… do with real memory consumptions. In fact typical server with 8GB of memory will often run with maximum theoretical memory usage of 100GB or… some special queries memory usage might be even larger – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if done to…
Post: InnoDB memory usage
May 30, 2006 By 8 Comments
… are many questions how InnoDB allocates memory. I’ll try to give some explanation about the memory allocation at startup. Some important…, which is used for syncronization primitives, size = OS_THREADS * 152 memory for os_events, which are also used for syncronization primitives… + 8M + 1500/20M + 17.5M = 1620.5M. Take the additional memory into account when you are planning memory usage for your server.
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… the memory diet. It would be easy to extend QA suite to check for peak memory usage after each test and hence find memory usage regression – when new code unexpectedly requires a lot more memory than previous variant. If memory accounting is implemented it can be used to help restricting memory usage in addition to…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… 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… can have a lot different sizes, while tools for analyzing memory usage have not improved since MySQL version 3.23, in fact…
