Optimizing MySQL on Server 2008 R2

Server 2008 R2

Optimizing IIS

Edit the my.ini file found in the MySQL installation


  • Set the innodb_buffer_pool_size=1G   Resource
  • Set the Max_Allowed_Packet = 100M
  • Set Key_Buffer_Size=512M
  • Set query_cache_size = 128MB
  • query_cache_limit = 4MB

  • table_cache=512
  • tmp_table_size = 64MB

Adjust your settings accordingly.

Note: Many of these settings can be made to the my.cnf file in Linux installations

Our performance increast?  50% savings on average (load times)


About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s