1

My MYSQL is using up all the ram/cpu

view story
linux-howto

http://forums.cpanel.net – /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 (HowTos)

Songlist's picture
Submitted by Songlist on 10/06/2012

Stories similar to My MYSQL is using up all the ram/cpu

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 the following problem: I cant get etherpad running, when my firewall rules are active.

My firewall: http://pastebin.com/82APzKhi

telnet localhost 3306 gives connection timeout

ps aux | grep mysql:

root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 15526 0.7 0.9 426056 75392 ?

MySQL process explanation 25 weeks 16 hours ago

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.

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

PS Aux memory usage 17.1? 15 weeks 5 days ago

I'm very new to SSH/Linux and was wondering if someone could kindly help out.

We've had our server crash a few times over the past month or so, and it was from huge spikes of 'traffic'. Not from web traffic, but I believe it's from our cron scripts/mysql.

After typing in psaux, I noticed that there is one line where the memory usage and %CPU spike.

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 ?

heavy load on mysql 30 weeks 5 days 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

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 can’t start MySQL on Ubuntu 12.04 after restored backup from innobackupex.

Before I tried to restore the db from backup I moved the datadir and got the same problem.