Optimize MySQL?

I have a forum (SMF script) on a server and every time I try to do a search, the whole thing slows down. I have managed to figure out that the problem occurs when MySQL creates temporary tables for the search.

In PHPMyAdmin I can see one process creating a temp table and all the rest are "Locked" until the search is done. Which means nobody can do anything on the forum while a search is being done. I've had to disable search for normal visitors due to this.

The server has a 1.7 GHz Intel Celeron, 512 MB RAM and the MySQL version is 3.23.58.

Is there any way to help the situation? The database table with all the posts is around 100Mb so I know it's sort of big.

I've tried increasing some of the buffersizes mentioned in the optimization guide.

For example myisam_sort_buffer_size is now set to 16M.


Any ideas of what could be done to help the situation?



Thanks.

 

 

 

 

Top