1

MySQL process explanation

view story
linux-howto

http://serverfault.com – 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. (HowTos)

grtyyu's picture
Submitted by grtyyu on 11/29/2012

Stories similar to MySQL process explanation

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

/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'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

php mysql cpanel high cpu usage 22 weeks 5 hours ago

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

heavy load on mysql 30 weeks 8 hours ago

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

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 ?

I have recently noticed that my MySQL server consumes abnormally large amount of CPU resources:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2427 mysql 20 0 2198m 161m 5568 S 1600.0 4.4 5121391h /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql

I am attaching two files - one with my MySQL configuration and another with the mysqlreport output.

I have a standard MySQL Server running on Red hat 5.7. I have edited /etc/my.cnf to specify the bind address as my server's public IP address.

Title says it all. I previously had mysql version 5.1 on my CENTOS 6 x86_64 OS. I attempted to remove mysql 5.1 and replace it with an install of mysql 5.6.

Here is my uninstall process for mysql 5.1:

yum remove mysql yum remove mysql-devel yum remove mysql-client

rpm -qa | grep -i mysql rpm -e mysql --nodeps

Here is my install process for mysql 5.6:

I got three rpm's for mysql 5.6.