Have to restart MySQL to reduce server load every hour

Hey all-

I'm running a Celeron 2.4ghz with 1GB of ram on Redhat 9 with CPanel.

My primary website receives about 15,000 unique visitors daily and is highly PHP/MySQL driven.

After I restart MySQL the server runs smooth even during peak times with a server load between 0.3 and 1.0. Then all of a sudden, after about an hour, the server load jumps up to 30-50+ and brings the system to a halt. As soon as I restart MySQL everything is back to normal. I can't seem to figure out what may be causing this.

I've noticed in top that the "RSS" goes up to about 77M for each MySQL instance during these horrible system load times, normally it's around 24M.

Here is the contents of my.cnf.. maybe something in here would help?

Code: 
[mysqld]
set-variable = max_connections=250
set-variable = query_cache_type=1
set-variable = query_cache_limit=1M
set-variable = query_cache_size=32M
set-variable = key_buffer=48M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1028
set-variable = thread_cache_size=128
set-variable = max_allowed_packet=5M
set-variable = connect_timeout=15
set-variable = thread_concurrency=2
safe-show-database

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer_size=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer = 20M
set-variable = sort_buffer_size = 20M
set-variable = read_buffer = 2M
set-variable = write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
Also, I ran /scripts/easyapache (cpanel script) and recompiled apache, also changed my max clients to 250 in apache.

Any advice would be appreciated.. I can't afford to have my server going down like this every hour, too many visitors affected.

Thanks,

Kurt

 

 

 

 

Top