Server 2008 R2
- install Wincache by Microsoft
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)
