MYSQLD Crash

[acscomputer]

MySQL 5.5.44-cll-lve
Plesk 12.0.18 Update 68

Here is the log file

151009 13:18:20 [Note] /usr/libexec/mysqld: Normal shutdown

151009 13:18:20 [Note] Event Scheduler: Purging the queue. 0 events
151009 13:18:22 [Warning] /usr/libexec/mysqld: Forcing close of thread 30 user: 'admin'

151009 13:18:22 InnoDB: Starting shutdown...
151009 13:18:23 InnoDB: Shutdown completed; log sequence number 934651450
151009 13:18:23 [Note] /usr/libexec/mysqld: Shutdown complete

151009 13:18:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151009 13:18:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151009 13:18:24 [Note] libgovernor.so not found
151009 13:18:24 [Warning] Using unique option prefix thread_cache instead of thread_cache_size is deprecated and will be removed in a future release. Please use the full name instead.
151009 13:18:24 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
151009 13:18:24 [Note] /usr/libexec/mysqld (mysqld 5.5.44-cll-lve) starting as process 9683 ...
151009 13:18:24 [Note] Plugin 'FEDERATED' is disabled.
151009 13:18:24 InnoDB: The InnoDB memory heap is disabled
151009 13:18:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151009 13:18:24 InnoDB: Compressed tables use zlib 1.2.3
151009 13:18:24 InnoDB: Using Linux native AIO
151009 13:18:24 InnoDB: Initializing buffer pool, size = 1000.0M
151009 13:18:24 InnoDB: Completed initialization of buffer pool
151009 13:18:24 InnoDB: highest supported file format is Barracuda.
151009 13:18:24 InnoDB: Waiting for the background threads to start
151009 13:18:25 InnoDB: 5.5.44 started; log sequence number 934651450
/usr/libexec/mysqld: File '/var/log/mysqld.slow.log' not found (Errcode: 13)
151009 13:18:25 [ERROR] Could not use /var/log/mysqld.slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
151009 13:18:25 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151009 13:18:25 [Note] - '0.0.0.0' resolves to '0.0.0.0';
151009 13:18:25 [Note] Server socket created on IP: '0.0.0.0'.
151009 13:18:25 [Note] Event Scheduler: Loaded 0 events
151009 13:18:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Atomicorp

After this the mysqld is death. But my website sill works....
But the Script does not...it hang up.

 

[IgorG]

Do you have this file /var/log/mysqld.slow.log ?
Are you sure that this file has correct permissions?

 

[Amin Taheri]

Your log doesnt show mysql exiting, its mostly just warnings and notes


This line specifically seems to indicate that the server is online and ready for work

151009 13:18:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Atomicorp​