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

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 –  George W Bush Aug 17 '09 at 22:38

3 Answers 3

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:

http://www.theodorenguyen-cao.com/2008/12/07/reduce-mysql-memory-usage/

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

http://www.omh.cc/mycnf/

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

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.