Home / server / Questions / 40778
Accepted
Brian Webster
Asked: 2009-07-15 14:28:09 +0800 CST

Installing MYSQL on Windows Server 2003 - Low Memory Usage Mode

  • 772

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.

windows-server-2003 mysql memory low-memory

3 Answers

  1. Best Answer

    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.

    • 1

  2. 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.

    • 0

  3. 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.

    • 0