Server Fault is a question and answer site for system and network administrators. 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'd like to setup MySQL on a Windows 2003 server. However, the server is already running SQL Server 2005 and I'd like to reserve most of the 4 GB of memory for that purpose. Is there some way to cap my MySQL at a certain Memory Usage?

Thanks in advance for your time.

share|improve this question
Is this a test server? – Jim B Jul 14 '09 at 22:30
nope, it's production – Brian Webster Aug 17 '09 at 22:38
up vote 1 down vote accepted

Here is a decent article on managing MySQL memory usage. It looks like there is no single setting to set a maximum amount of memory usage, but by adjusting the key_buffer, query_cache_size, and max_connections (among some others) in your my.cnf, you can reduce the memory footprint.

share|improve this answer

I'd stick Mysql on a VM on that same box if at all possible. I'm not too sure how well sql server and mysql play together.

share|improve this answer
MySQL and MSSQL "play fine" together. Just dont overcommit memory to either. – SirStan Aug 4 '09 at 23:16
as the article in adams answers shows- it's a pain to get mysql to use only X amount of ram- so sticking it in a vm is probably preferable. – Jim B Aug 5 '09 at 15:40

This gives you good directions for reducing your base memory usage:

You can then use this to estimate your MySQL memory usages based on the my.ini/my.cnf

And of course, you should check out the MySQL Performance Blog.

share|improve this answer

Your Answer


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.