MySQL gone crazy

[desiguru]

I have been looking at my shared server's "top" or "Show Current CPU Usage" for quite sometime now and the one thing that is always on top is the MySQL error pid. which is something like this

 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/etc/httpd/logs/mysqld.err --pid-file=/var/lib/mysql/server.server.com.pid

Here is my my.cnf

[mysqld]
max_allowed_packet=100M
set-variable = max_connections=600
safe-show-database
# Connection timeout
connect_timeout                   = 20

# Timeout for inactive connections
wait_timeout                      = 60

# Network buffer length (I think this is the linux default)
net_buffer_length                 = 16K
log-error                         = /etc/httpd/logs/mysqld.err
binlog_cache_size                 = 2M
table_cache                       = 6588
join_buffer_size                  = 320M
tmp_table_size                    = 512M
sort_buffer_size                  = 128M
thread_cache_size                 = 6
max_heap_table_size               = 320M
query_cache_size                  = 312M
key_buffer_size                   = 128M
[client]
socket=/var/lib/mysql/mysql.sock

How can I optimize mySQL so that it doesnt end up using a lot of my CPU resources and slowing down a lot of work for my users?

Thanks a lot for anyone who helps.

[rlshosting]

Run MYSQL Tuner
MySQLTuner

[johnburk]

And / or


tuning-primer.sh
Sundry MySQL Scripts and Docs

[desiguru]

And / or


tuning-primer.sh
Sundry MySQL Scripts and Docs

Thank you. That script is really awesome.

How can I fix this? I got everything else working fine now.

MEMORY USAGE
Max Memory Ever Allocated : 11.39 G
Configured Max Per-thread Buffers : 262.86 G
Configured Max Global Buffers : 450 M
Configured Max Memory Limit : 263.30 G
Physical Memory : 7.78 G

nMax memory limit exceeds 90% of physical memory

[GaryT]

Thank you. That script is really awesome.

How can I fix this? I got everything else working fine now.

MEMORY USAGE
Max Memory Ever Allocated : 11.39 G
Configured Max Per-thread Buffers : 262.86 G
Configured Max Global Buffers : 450 M
Configured Max Memory Limit : 263.30 G
Physical Memory : 7.78 G

nMax memory limit exceeds 90% of physical memory

Lower your max connections, That will remove the error, Its cause each connection is allocated a set amount of memory and your exceeding that.