Portal Home > Knowledgebase > Articles Database > tuning-primer.sh results, how to act on them?
Posted by mifbody, 11-22-2007, 12:00 AM Anyone know how to make the changes in red? My server works good for awhile, but then gets REALLY REALLY slow. It's really frustrating.
Posted by david510, 11-22-2007, 02:46 AM SLOW QUERIES It tells, mysql does not need this much long_query time. You can reduce it by adding following line under [mysqld] inside my.conf file. set-variable=long_query_time=5 MAX CONNECTIONS You have set max_connections a high value. Lower it to about 200. max_connections=200 MEMORY USAGE and KEY BUFFER Reduce the key_buffer size. TABLE SCANS Increase read_buffer_size under mysqld TABLE LOCKING It is the default value. It can be ignored.
Add to Favourites 
Print this Article
