Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
linux eats all memory, seems like it is not for specific application

TOP shows that almost all the memory is consued on a dedicated MySQL box. I stopped mysql and checked the top and there is no difference. There is no other process running that would consume that kind of memory. How do I release the locked memory?

# /etc/init.d/mysqld status
mysqld dead but subsys locked

# free -m
             total       used       free     shared    buffers     cached
Mem:         35007      34913         94          0        186      33045
-/+ buffers/cache:       1681      33326
Swap:            0          0          0

Do I need to restart the server?

share|improve this question

marked as duplicate by Iain May 24 '12 at 5:27

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

up vote 1 down vote accepted

Look at the third line (-/+ buffers/cache) which shows you memory used by the operating system for filesystem buffers and caches, but that can immediately be made available for use by any process which needs it. You do not have a memory shortage.

share|improve this answer
    
When I start mysql, the queries are extremely slow. How do I know if it is an OS issue or MySQL ? –  shantanuo May 24 '12 at 5:17
    
You should probably ask that as a separate question, with more details of your MySql configuration and OS, and whether it is all queries (even trivial ones) that are slow or just some (in which case look at the slow query log). You might also investigate "mysqld dead but subsys locked" in your OP. –  ramruma May 24 '12 at 5:27
    
Actually, now you know how to read its output, you should run the free command while MySql is running. –  ramruma May 24 '12 at 5:30

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