What to add to my my.cnf file to speedup SQL?

What can I add to optimize my Mysql:


MYCNF FILE:

This is my file on a Linux server,Celeron 1.7GHz, 1 GIG memory.

busy server, consuming 300 gigs monthly with busy bbs etc.
cpu is mostly 0.80 to 1.5 in cpanel.

How to improve this? I run php4.3.9 and sql 3.23.49




[mysqld]
set-variable = max_connections=500

[mysqld]
set-variable = max_user_connections=200

[mysqld]
set-variable = wait_timeout=200

[mysqld]
set-variable = interactive_timeout=800




Thanks for any imput.

 

 

 

 

Top