…memory usage might be even larger – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if done to MyISAM tables. myisam_sort_buffer…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… added memory for InnoDB: specifically, the buffer pool. (There’s also an innodb_additional_…sort_buffer_size := 1 * 1024 * 1024 * 1024;” and my sort_buffer_size is now 1GB. And a single query may cause multiple sort buffers… to compute the maximum possible memory usage, and there cannot be because …
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
…memory. I would look at memory consumed by Innodb (it is often higher than innodb_buffer_pool_size) substract memory used by other global buffers… space for temporary tables or sort memory. Though I’m not expecting … could account statistics for their own memory usage which is when merged together to …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated. There are also things like innodb additional memory… can try locking MySQL in memory by using –memlock – just be careful as in case you have memory usage spike you may have…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…rows each) ~50G data / CPU bound case innodb_buffer_pool_size=52G For every malloc …Memory usage for others allocators looks more or less acceptable. Taking into account all 3 factors – throughput, latency and memory usage…) and gathered mysqld size with ‘ps –sort=-rss -eopid,rss,vsz,pcpu’ during the…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even… any data on memory usage for these tests? No, I didn’t measure the memory usage for each test. I did allocate buffers in what I hope was a realistic way. For instance, when testing the 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…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. …and accessing large amount of Innodb tables you can allocate large amount of memory on server. The … allows to run queries with uncontrolled resource usage. Host Block You can have given client …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… compression. The downside in gzip is increased usage of CPU time. PZ: We will see …sorted indexes with Innodb (with index built by sort) this is when this should be helpful the most. Q3: Does Innodb…kernel’s buffer pool. In high load situations where INNODB is using most of the system’s memory …
Comment: MySQL Wish for 2013 - Better Memory Accounting
January 1, 2013 By 6 Comments
… it comes to MySQL and memory usage, I’d like to see totally different approach to tuning the memory usage. There are dozens of knobs to configure the amount of memory for each particular need, but… be used for the innodb_buffer_pool_size, some memory for the sort and read buffers, some memory for the query cache, some memory for the temp…
