Help - Search - Members - Calendar
Full Version: mYSQL CRAZY .. Urgent!!!
The Planet Forums > Control Panels > cPanel/WHM
Sabaote
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
mickalo
QUOTE
Originally posted by Sabaote
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
Angel78
post contents of your my.cnf file (have you optimized your my.cnf)?
Sabaote
In the my.cnf
Have the user Root...and password..

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

Please.. where they are?
Sabaote
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!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.