MySQL Error in WHM Service Status Daily Process Log
Hi,
firstly, I hope I am posting this in the correct location.
I am trying to troubleshoot why my site is very slow and hangs and I read somewhere on cpanel forums (one of many things I am trying) to see what the error logs say. One thread I am following now is this one:
As when I checked the processes in WHM I sawl the following message:
/usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql --plugin-dir/usr/lib64/mysql/plugin --usermysql --log-error432267.vps-06.com.err --open-files-limit50000 --pid-file/var/lib/mysql/423267.vps-06.com.pid
I have just ran the following as per the above mentioned post:
/var/lib/mysql/hostname.err
And this is what it returned:
2017-02-26 19:46:56 8248 [Note] Plugin 'FEDERATED' is disabled.
2017-02-26 19:46:56 8248 [Note] InnoDB: Using atomics to ref count buffer pool $
2017-02-26 19:46:56 8248 [Note] InnoDB: The InnoDB memory heap is disabled
2017-02-26 19:46:56 8248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic bui$
2017-02-26 19:46:56 8248 [Note] InnoDB: Memory barrier is not used
2017-02-26 19:46:56 8248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-02-26 19:46:56 8248 [Note] InnoDB: Using Linux native AIO
2017-02-26 19:46:56 8248 [Note] InnoDB: Not using CPU crc32 instructions
2017-02-26 19:46:56 8248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-02-26 19:46:56 8248 [Note] InnoDB: Completed initialization of buffer pool
2017-02-26 19:46:58 8248 [Note] InnoDB: Highest supported file format is Barrac$
2017-02-26 19:46:58 8248 [Note] InnoDB: 128 rollback segment(s) are active.
2017-02-26 19:46:58 8248 [Note] InnoDB: Waiting for purge to start
2017-02-26 19:46:58 8248 [Note] InnoDB: 5.6.35 started; log sequence number 162$
2017-02-26 19:46:58 8248 [Warning] No existing UUID has been found, so we assum$
2017-02-26 19:46:58 8248 [Note] Server hostname (bind-address): '*'; port: 3306
2017-02-26 19:46:58 8248 [Note] IPv6 is available.
2017-02-26 19:46:58 8248 [Note] - '::' resolves to '::';
2017-02-26 19:46:58 8248 [Note] Server socket created on IP: '::'.
My question is, are any of the above cause for concern? If yes, can anyone give me any tips on how to fix them?
Kind regards
-
There are no errors. /usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql --plugin-dir/usr/lib64/mysql/plugin --usermysql --log-error432267.vps-06.com.err --open-files-limit50000 --pid-file/var/lib/mysql/423267.vps-06.com.pid
This mysql transaction represents the pid and the command line. There is also no problem with your mysql logs. In whm, follow the prompts in the queries "show mysql process"0 -
Hello, The previous post is correct. The output you provided is normal and does not suggest there are any errors with MySQL. As far as performance, the following resource is a good place to start (even if the loads are not high): Thank you. 0
Please sign in to leave a comment.
Comments
2 comments