MySQL process doesnt end, is it normal ??

absolutenetwork

Active Member
Dec 12, 2006
34
0
156
Im looking at my Process Manager and shows contantly this proceess:

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

Is this a normal?? my load numbers are all normal... so is not loading the server .. but dont know if it means that something is not working right..

The error log shows:

140130 00:56:23 mysqld_safe Number of processes running now: 0
140130 00:56:23 mysqld_safe mysqld restarted
140130 0:56:23 [Note] Plugin 'FEDERATED' is disabled.
140130 0:56:23 InnoDB: The InnoDB memory heap is disabled
140130 0:56:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140130 0:56:23 InnoDB: Compressed tables use zlib 1.2.3
140130 0:56:23 InnoDB: Using Linux native AIO
140130 0:56:23 InnoDB: Initializing buffer pool, size = 128.0M
140130 0:56:23 InnoDB: Completed initialization of buffer pool
140130 0:56:23 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140130 0:56:23 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140130 0:56:28 InnoDB: Waiting for the background threads to start
140130 0:56:29 InnoDB: 5.5.34 started; log sequence number 11318076719
140130 0:56:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140130 0:56:29 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140130 0:56:29 [Note] Server socket created on IP: '0.0.0.0'.
140130 0:56:29 [Note] Event Scheduler: Loaded 0 events
140130 0:56:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.34-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
 

cPanelPeter

Technical Analyst III
Staff member
Sep 23, 2013
575
21
143
cPanel Access Level
Root Administrator
Twitter
Hello,

This looks fairly normal. The log file shows that MySQL was not previously shutdown properly, but went into recovery and appears to be recovered fine.

You said MySQL isn't running, what happens when you try to access MySQL, do you get any errors?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Im looking at my Process Manager and shows contantly this proceess:

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

Is this a normal?? my load numbers are all normal... so is not loading the server .. but dont know if it means that something is not working right..
Yes, it's normal for the MySQL server to constantly run. Otherwise, your databases would not be accessible.

Thank you.