… MySQL memory usage; the Massif tool from Valgrind. An excerpt from the Massif manual page (Heap memory being simply the allotted pool of memory… increase memory usage/trigger the memory problem. You could also just leave the server running for some time (for example, if you have experienced memory increase…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 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… space can add up. Running small queries might only barely increase memory consumption for given thread, however if table will perform complex… some special queries memory usage might be even larger – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if done to…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… to 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: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… how much should I see performance improved in case I increase memory say from 16GB to 32GB. The benefit indeed can be… wait we typically do not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does… may be increasing memory is helpful to solve this problem. If it is IO bound (high IO system utilization, low CPU usage) one…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… of CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory footprint under the control. …5G. Memory usage for others allocators looks more or less acceptable. Taking into account all 3 factors – throughput, latency and memory usage for …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… is number of unpurged transactions in undo space. It is increased as transactions which have done updates are commited and decreased… 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…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…: Do you have any data on memory usage for these tests? No, I didn’t measure the memory usage for each test. I did… increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory… changes, using application code. Since RT indexes are in volatile memory, not stored on disk, you are responsible for integrating new…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… this way; some have multiple processes that communicate through shared memory or other means. It’s cheap to create a connection… get 5000 threads in the server. That increases the overhead from thread scheduling, and potentially memory usage as well. I feel like I…. And because MySQL is a multi-threaded database for Web usage that tends to be used in sharded environments with tons…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…. There are also things like innodb additional memory pool (which can grow more than memory you allocated for it, especially in case… you can increase it a bit to be on the safe size and scale appropriately. The third important memory consumer would be… can try locking MySQL in memory by using –memlock – just be careful as in case you have memory usage spike you may have…
Comment: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
… adoption in desktop,embedded environments and default usage. Whereas Falcon’s goals mention things like increased memory utilization and greater multiprocessor performance. Is…
