1

Mysql Server shuts down periodically on Ubuntu. I looked through the system log file and found the following lines in the log files i checked :

 Out of memory: Kill process 719 (mysqld) score 114 or sacrifice child

We are however using just about 20% of the allocated memory.

What could be the cause of this problem?

6
  • Is the MySQL server a 32-bit binary that runs into the 2 GB limit of 32-bit apps?
    – Daniel
    Feb 7, 2013 at 22:13
  • @aeyoun please, how do i verify this?
    – kayfun
    Feb 7, 2013 at 22:22
  • You can run file $(which mysqld) and see whether the output mentions x86-64 or i386.
    – Daniel
    Feb 7, 2013 at 22:25
  • it reads ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.24, BuildID[sha1]=0xba5b9662c68585316ea5538b55184861e228eb22, stripped
    – kayfun
    Feb 7, 2013 at 22:31
  • Then that is your problem. You need to install a 64-bit server on a 64-bit system to allow a single process to use more memory.
    – Daniel
    Feb 7, 2013 at 22:32

2 Answers 2

0

It says what is wrong right in the error message. It is out of memory.

It could be a 32-bit application with 2–3 GB memory restriction that 32-bit apps have. You can run file $(which mysqld) and see whether the output mentions x86-64 or 32-bit/i386.

Or there could be a upper limit on the server. Check the configuration in /etc/mysql/my.cnf and look at the upper memory limits.

0

It's also always a good idea to check for the biggest tables or tables with the biggest overhead via localhost/phpmyadmin (if installed). Sometimes it's just a matter of cleaning the caches of a cms (if you're using mysql for a CMS) and looking for overhead and get rid of it via phpmyadmin

additionally if this helps and your are using mysql for a cms that is causing the problems it might be necessary to check the caching policies and setup a cron job to clean caches periodically

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .