2

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.

2
  • Is this a test server?
    – Jim B
    Jul 14, 2009 at 22:30
  • nope, it's production Aug 17, 2009 at 22:38

3 Answers 3

1

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.

0

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.

2
  • MySQL and MSSQL "play fine" together. Just dont overcommit memory to either.
    – SirStan
    Aug 4, 2009 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, 2009 at 15:40
0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .