Hello,

i have a dedicated server which is:
AMD Athlon(tm) II X4 605e Processor
16GB Rams
1.5TB
---

Now i have SQL which is sometimes using up to 390% of my CPU & causing a HUGEEEEEEEEEEE server load.

that's my my.cnf:

[mysqld]
max_connections = 1000
table_cache = 4096
thread_cache_size = 64
key_buffer = 64M
query_cache_size = 128M
join_buffer_size = 256K
myisam_sort_buffer_size = 64M
thread_concurrency = 5

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

Need help to fix it ASAP please server will bomb soon :/

i don't know if i'll be able to help, i just wanted to say that nobody is going to be able to help you if you don't show the SQL that's causing the problem

i have no idea i checked the biggest sql status by phpmyadmin all looks fine!!!
so not even sure which one or i would stop it for now.

check the log files
examine the applications, look at the SQL being used
check the indexes
EXPLAIN queries

I assume in your universe that the rules of maths are slightly different to our own?

is this MYSQL ?

is this on Windows or Linix ?

we all need some clarity regarding your question then some one can help u from it try to elaborate it