Diagnosing MySQL problems/reading log

Hi everyone,

My load is spiking really high and I see this as the top process in the Process Manager in WHM:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/my.server.com.err --pid-file=/var/lib/mysql/my.server.com..pid
I notice that my ib_logfile0 and ib_logfile1 are huge compared to the size of the my.server.name.com.err log - and the .err log seems to be last updated yesterday. I'm assuming the ib_logfile's are what's connected to the process that's showing up in the process manager.

When I view those files I see a bunch of weird characters like ^^^^^^^^^^^^^^*^^^^^^^^ then one URL's from one of my websites.

I'm not sure how to diagnose the errors or find out what's going on.

Any help is greatly appreciated.

Thank you

 

 

 

 

Top