Hello..
The MySQL in my server is crazyy...
My Server is a P4 2.4Ghz, 1GB RAM (2) 80GB HD...


Exists 1 database in my server with 70MB.. and this site have an average of 23,000,00 visites per day...

Now the load of mysql in memory is high... too much..
This line é of WHM
CPU Memory Proccess
mysql 6.37 893.76% 0.0

i don't know what to do!!! Please help-me... somebody than know what i can do for fix this.. Thanks..

Thanks..
[]'s

did you check the mysql log file(s), try restarting mysql, check the output of "mysqladmin processlist" to see what's going on with it ??

What version of MySQL are you running ?

Mickalo

post contents of your my.cnf file (have you optimized your my.cnf)?

In the my.cnf
Have the user Root...and password..

Only this..
I'm a newbie.. i can't find the Logs..

Please.. where they are?

hi.. i already edit the my.cnf for optimize...

but it continue the high load of memory and cpu..

but.. exists various of this line of command when i run the ps- aux in ssh

/usr/sbin/mysqld--basedir=/--datadir=/var/lib/mysql--user=mysql--pid-file=/var/lib/mysql/infra.hostpower.com.br.pid--skip-locking

this commando load the memory in an average of 5.0% and 7%....
But are various commandos like this in the same time.. So.. it load the fully memory.. and the server crash or have a big big big lag ...

if you know how fix.. please

Thanks!!!
sorrymy english!!