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 Quote 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? Quote 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? Quote 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? Quote 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 Quote 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? Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/245322-mysqld/#findComment-1260917 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.