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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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) 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???


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


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

Browse other questions tagged or ask your own question.