MySQL process doesnt end, is it normal ??

absolutenetwork

• January 29, 2014 23:59

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 cPanel Staff

  • January 30, 2014 13:11

  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?

  0
• 

  cPanelMichael

  • January 30, 2014 13:33

  [quote="absolutenetwork, post: 1559641">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.

  0

Please sign in to leave a comment.