Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm facing a frustrating issue.

I have a MySQL Server 5.5 running on top of Ubuntu Server 12.04.3 LTS (VMWare guest w/ 16GB RAM - 8 Cores)

mysqltuner.pl says

[OK] Maximum possible memory usage: 6.6G (41% of installed RAM)

Also 'my.ini' says these:

MySQL settings

But MySQL is draining all my physical memory and making me swap, even the server restarts MySQL when it detects the memory is exhaust.

TOP capture

How can i REALLY restrict MySQL memory consumption???

EDIT

Server version: 5.5.32-0ubuntu0.12.04.1 (Ubuntu)

+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| thread_cache_size | 128   |
+-------------------+-------+
share|improve this question
    
What is the exact version of MySQL Server (5.5.x?). What does show global variables like 'thread_cache_size'; say? –  Michael - sqlbot Nov 5 '13 at 22:20
    
@Michael-sqlbot See the bottom of the question as i have edited to give you the version and variable status –  Frederic Yesid Peña Sánchez Nov 6 '13 at 22:00

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.