Bug #15242 | mysqld's memory is increased by problem. | ||
---|---|---|---|
Submitted: | 25 Nov 2005 6:24 | Modified: | 25 Nov 2005 8:53 |
Reporter: | EUN KEYONG YUN | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | mysql-standard-4.1.14-pc-linux-gnu-i686 | OS: | Linux (Red Hat Enterprise Linux AS rele) |
Assigned to: | CPU Architecture: | Any |
[25 Nov 2005 6:24]
EUN KEYONG YUN
[25 Nov 2005 6:28]
EUN KEYONG YUN
DB's status and variable
Attachment: status&variables.txt (text/plain), 48.16 KiB.
[25 Nov 2005 8:05]
Heikki Tuuri
Hi! Please post a few outputs of: SHOW INNODB STATUS\G during the problem. This looks like a memory leak in InnoDB. Do you have many InnoDB tables? If you have > 100 000 InnoDB tables, memory usage in the InnoDB data dictionary cache could get as big as this. Regards, Heikki
[25 Nov 2005 8:08]
Heikki Tuuri
Hi! Please post your my.cnf. Regards, Heikki
[25 Nov 2005 8:12]
Valeriy Kravchuk
Thank you for a problem report. Please, describe the hardware you use (EM64T, AMD64, IA64)? You may need to use the other binary to be able to overcome that 2.5G limit (http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.15-unknown-linux-gnu-x86_6..., for example). You my.cnf content may be useful too. Some setting may need adjustments.
[25 Nov 2005 8:14]
Hartmut Holzgraefe
You are overcommiting memory, see http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html Warning: On 32-bit GNU/Linux x86, you must be careful not to set memory usage too high. glibc may allow the process heap to grow over thread stacks, which crashes your server. It is a risk if the value of the following expression is close to or exceeds 2GB: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB Each thread uses a stack (often 2MB, but only 256KB in MySQL AB binaries) and in the worst case also uses sort_buffer_size + read_buffer_size additional memory. Your innodb_pool_buffer_size is 1.8GB alone, together with the other buffers this easily sums up to the operating systems per-process memory limit Additional memory is even required whenever a temporary table is created for sorting which happens quite a lot on your server.
[25 Nov 2005 8:45]
EUN KEYONG YUN
my.cnf
Attachment: my.cnf (application/octet-stream, text), 14.05 KiB.
[25 Nov 2005 8:46]
EUN KEYONG YUN
data of innodb's status
Attachment: INNODBMONITOROUTPUT.txt (text/plain), 49.68 KiB.
[25 Nov 2005 8:53]
EUN KEYONG YUN
First of all, Thank you for your comments and your informations. I uploaded my.cnf & data of innodb status. There are 100 under innodb tables in db. and cpu is Intel(R) Xeon(TM) MP CPU 2.20GHz.