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

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Computer hardware, Computers, Education, freeware, Information Technology, Linux, network, Networking, Software, Technology, Windows and tagged , , , , . Bookmark the permalink.

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