Denis Jedig Troubleshoot excessive memory usage in InnoDB
Apr 19, 2013; 23:17
Denis Jedig
Troubleshoot excessive memory usage in InnoDB
Hi all.
In a specific MySQL installation of 5.6.10 using InnoDB tables, I am observing unusual memory consumption patterns. The memory usage is growing constantly - even beyond the physical memory limits. The entire on-disk storage is 41 GB (uncompressed), yet memory usage is happily growing to values larger than 50 GB.
The databases mainly experience read load with complex queries and subSELECTs running ~60-100 connection threads.
Although the docs state that "there should be no memory leaks", this case certainly looks like one at first glance.
http://dev.mysql.com/doc/refman/5.6/en/memory-use.html suggests that temporary in-memory tables would be used for this purpose so I suspected unfreed temporary tables to be the culprit. But memory usage growth rates did not change significantly even after lowering tmp_table_size to 2M (from 64M). Also, I have been unable to find a way to determine the size of in-memory temporary tables at any given time.
A replication slave of this very host is running 5.6.10 with MyISAM tables and the mysqld process does not exceed 1 GB in memory utilization even after several hours of operation under similar load.
I have posted a question to <http://dba.stackexchange.com/questions/40413> which I will update with further information as I get it.
Any hints on how to hunt the resource hog greatly appreciated, -- Denis Jedig
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Apr 20
Ilya Kazakevich RE: Troubleshoot excessive memory usage in InnoDB
Apr 20, 2013; 01:39
Ilya Kazakevich
RE: Troubleshoot excessive memory usage in InnoDB
Apr 19
Rick James RE: Troubleshoot excessive memory usage in InnoDB
Apr 19, 2013; 22:26
Rick James
RE: Troubleshoot excessive memory usage in InnoDB
Apr 20
Denis Jedig Re: Troubleshoot excessive memory usage in InnoDB
Apr 20, 2013; 11:15
Denis Jedig
Re: Troubleshoot excessive memory usage in InnoDB
Apr 29
Rick James RE: Troubleshoot excessive memory usage in InnoDB
Apr 29, 2013; 18:29
Rick James
RE: Troubleshoot excessive memory usage in InnoDB
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!