dreamwest Posted August 21, 2011 Share Posted August 21, 2011 Ive set up my new VPS and mysqld is using 60% - 90% cpu and 6% memory per process (6-8 processors). Im not running any databases yet, so its currently not being used Heres the PID thats causing the issue /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/site.com.err --pid-file=/var/lib/mysql/site.com.pid Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/ Share on other sites More sharing options...
trq Posted August 21, 2011 Share Posted August 21, 2011 And your question is? Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1259998 Share on other sites More sharing options...
dreamwest Posted August 21, 2011 Author Share Posted August 21, 2011 Why is it using so many resources. I killed the proccess but it keeps returning, ive restarted mysql server, check /etc/my.cnf for errors, still no luck I assuming --log-error=/var/lib/mysql/site.com.err is writing to a log and the PID's are lasting for 74Hours+ . Ive checked the site.com.err log and it doesnt have any errors So whats causing mysqld to use so many resources? Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260039 Share on other sites More sharing options...
fenway Posted August 21, 2011 Share Posted August 21, 2011 InnoDB? Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260288 Share on other sites More sharing options...
dreamwest Posted August 21, 2011 Author Share Posted August 21, 2011 I have skip-innodb in my /etc/my.cnf but it doesn't help Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260316 Share on other sites More sharing options...
fenway Posted August 22, 2011 Share Posted August 22, 2011 Basedir off the root? Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260483 Share on other sites More sharing options...
dreamwest Posted August 22, 2011 Author Share Posted August 22, 2011 I took basedir away from /etc/my.cnf because mysql couldnt restart with it, but the PID has --basedir=/ Im running the latest version root@blue [~]# mysql --version mysql Ver 14.14 Distrib 5.1.56, for pc-linux-gnu (i686) using readline 5.1 Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260674 Share on other sites More sharing options...
fenway Posted August 23, 2011 Share Posted August 23, 2011 I took basedir away from /etc/my.cnf because mysql couldnt restart with it, but the PID has --basedir=/ I don't understand what that means. Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260917 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.