Thursday, January 29, 2009

speed up moodle performance with MySQL query cache

MySQL performance
The following are the MySQL settings which can be adjusted for better performance in my.cnf (my.ini in Windows). The file contains a list of settings and their values.

1. Enable the query cache with query_cache_type = 1
2. Set query cache size with query_cache_size = 36M
3. and query_cache_min_res_unit = 2K
4. Set table cache with table_cache = 512 (from moodle 1.7 or higher)

Note: Please make backups of your database before changing any MySQL server configuration.
After the changes to the my.cnf,restart mysql server using the command "service mysqld restart".

No comments: