Optimizing MySQL on Server 2008 R2

Server 2008 R2

Optimizing IIS
(http://msdn.microsoft.com/en-us/library/ee377050(v=bts.10).aspx)

Edit the my.ini file found in the MySQL installation

http://dev.mysql.com/doc/refman/5.0/en/optimization.html

  • 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)

Chart

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