Results 1 to 3 of 3
-
04-02-2012, 07:13 AM #1New Member
- Join Date
- Apr 2012
- Posts
- 1
Cpanel Daily Process Logs - MySQL high usage
Hi All,
I have a VPS with a good host, but been having a few issues of late.
If someone or more can help me understand what the following means please, I'd be very grateful.
The below are two lines from the daily process log report in cpanel.
Recently my MySQL service has been going mental without any explanation to which script is using all the resources.
mysql 163 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --log-error/var/lib/mysql/VPS.DOMAIN.com.err --pid-file/var/lib/mysql/VPS.DOMAIN.com.pid
_________________________________________________
mysql 162 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --log-error/var/lib/mysql/VPS.DOMAIN.com.err --pid-file/var/lib/mysql/VPS.DOMAIN.com.pid
Any advise would be grateful.
Cheers,
Joe
-
04-06-2012, 04:34 PM #2Temporarily Suspended
- Join Date
- Feb 2004
- Location
- UK
- Posts
- 1,431
Hi
Enable slow query logging then you can at least see what running slowly. it maybe that a table has just gone over a certain size and is loading up your VPS.
Also it maybe that your VPS server is hosted in a busy node. (need to ask your host for some help)
Thanks
Andrew
-
04-09-2012, 12:30 AM #3Junior Guru
- Join Date
- Dec 2011
- Posts
- 218
I'd suggest you to check the database credentials with your hosting provider
Similar Threads
-
High mysql process load
By gozargah in forum Hosting Security and TechnologyReplies: 19Last Post: 12-28-2010, 01:09 PM -
cPanel Daily Process Log empty
By myk8022 in forum Hosting Security and TechnologyReplies: 2Last Post: 07-16-2010, 06:11 AM -
Could a blog with about 1k unique daily cause excessive Mysql usage ?
By myanlien in forum Web HostingReplies: 20Last Post: 07-21-2007, 06:00 AM -
MySQL high Process
By webhostbeginner in forum Hosting Security and TechnologyReplies: 1Last Post: 10-23-2005, 08:53 AM -
High MySQL Memory Usage - Kernel killing process
By HYB-Bryan in forum Hosting Security and TechnologyReplies: 4Last Post: 10-24-2004, 05:26 PM