I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to set the query_cache_size.
Now, to do this, I believe that I will need to set the query_cache_size and join_buffer_size in my.cnf
Unfortunately, I do not have any experience with editing the my.cnf file so I am hoping that someone can kindly assist me here. How do I set it, and what should I set it to?
[mysqld] set-variable = max_connections=500 safe-show-database log_slow_queries = /var/log/mysql/log-slow-queries.log slow_query_log = 1 long_query_time = 2 log-queries-not-using-indexes