mysql - abnormally high CPU usage

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.example.com.err --open-files-limit=20000 --pid-file=/var/lib/mysql/server1.example.com.pid

Memory is at %10 always and Cpu at %1 Also /usr/local/apache/bin/httpd -k start -DSSL I have like 10 of them running

i have dedicated server with very good configuation like 16 gb ram etc but i am facing heavy load from mysql i am running a music wesbite however only one database is running and 5-10 pages are only running.when i click on whm show processlist it shows only 2-3 processes

However whm load is always less than one but when i click on whm load it shows 20% of cpu usage by mysql and after some time it

My server hangs everyday

So i checked system health - process manager in whm

there was a command given below

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306

see this image

here this mysql command process is taking

I've been seeing this in Process Manager for some time, for months actually, but I don't know what it is and would like to know.

It has my hostname in it.

Quote:

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.xxxxx.xxx.err --pid-file=/var/lib/mysql/xxx.xxxxx.xxx.pid

I have one MySQL process on my server running linux and it's always running it takes at least 50% usage of 1 Core (I have 8 cores)... This is process command:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid

What this process is doing? This is not the issue just a question.

very high load mysql load seen for 5-6 hours daily, when daily compressed backups run. load seems to be with mysql process. Typical ps snaphot is as;

mysql 6896 14.2 4.0 802300 373804 ?

server taking high cpu usage load average: 108.87, 105.92, 85.82

netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

Reselt showing too much connect from server IP

cpanel Process Manager showing

19.4 | 0.5 | /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/zebra546.serverstall.com.err --pid-file=/var/lib/mysql/zebra546.servers

I have two instances of mysql running on a server. I need two different init.d scripts. The two instances have different configuration files /etc/my.cnf and /etc/my-slave.cnf. I copied the /etc/init.d/mysql files to /etc/init.d/mysql-slave and changed the conf parameter to /etc/my-slave.cnf but the mysql-slave service is still controlling the first instance of mysql.

I tried to change the database dirrectory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit

Install: sudo apt-get install mysql-server mysql-client All Ok, I can create databases, tables, all ok. Change the datadir:

1) $ /etc/init.d/mysql stop 2) $ cp -R -p /var/lib/mysql /new_path 3) $ rm /new_path (this only remove files unnecessary) 4) $ gedit /e