Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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?

share|improve this question
    
Is the MySQL server a 32-bit binary that runs into the 2 GB limit of 32-bit apps? –  Aeyoun Feb 7 '13 at 22:13
    
@aeyoun please, how do i verify this? –  kayfun Feb 7 '13 at 22:22
    
You can run file $(which mysqld) and see whether the output mentions x86-64 or i386. –  Aeyoun Feb 7 '13 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 '13 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. –  Aeyoun Feb 7 '13 at 22:32

2 Answers 2

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.