Forum Moderators: open
I am experiencing something really weird.
Two days ago I update the tmpdir of my mysql master and slaves because I notice that on the scheduled auto-repair & maintenance script, the /tmp was getting full and creating a big lag between slaves and master.
The slaves are running on a RAID 10 configuration and I still have a lot of available space. I setup the tmpdir to use the RAID 10 drive but on a different directory than the DBs.
Now from time to time I see the following error on the mysqld.log file:
-----------------------------------
/usr/sbin/mysqld: Out of memory (Needed 877944832 bytes)
/usr/sbin/mysqld: Out of memory (Needed 658458624 bytes)
/usr/sbin/mysqld: Out of memory (Needed 493842432 bytes)
-----------------------------------
Any help will be highly appreciated.
Note: each slave is running in a dedicated box with 16 processors at 2.4Ghz each with 16GB of ram and 4 drive of 76GB @ 15K rpms for the RAID 10 and one extra drive for the OS, RHEL 5.2 at 64 bits.
I'm not sure exactly what your problem is, but it seems that it might mean exactly what it sounds like ... you're out of memory ;)
[bugs.mysql.com...]
Quote from that page
When server tried to use almost 4G of
memory (for whatever reason. like a lot of MEMORY and/or temporary tables used) it fails
with "Out of memory" error message. This is expected. Why do you think there is any bug
here?
Thank you for the welcome and for replying.
So far I had see the bug on mysql bugs site, but on my case I am running 64 bits so the 4Gb limit is not the issue, although I have also seen some post where it is mention the fact that the global variable key_sort_buffer auto readjust to less than 4Gb.
I was able to fix the issue yesterday by running the mysql tuner script and with it I noticed I had the threats variable with to much memory assigned (over 1250% of server available memory) so that was causing the issue.
Just a note for people having the same issue make sure to check the units of the variable before making changes as I had just put Gbs where bytes should be.
Thank you.
Enjoy. !-)
