Report this

What is the reason for this report?

MySQL Shutsdown After 10 Seconds

Posted on January 21, 2020

Newbie here. Eveyrtime I start the mysql service, it automatically goes down after 10-15 seconds. I’ve enabled and checked the error logs and to my understanding there is no actual error in the lines. Can you provide some feedback regarding to the issue?

Here is the log output…

2020-01-21 13:32:30 0 [Note] InnoDB: Using Linux native AIO
2020-01-21 13:32:30 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-01-21 13:32:30 0 [Note] InnoDB: Uses event mutexes
2020-01-21 13:32:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-21 13:32:30 0 [Note] InnoDB: Number of pools: 1
2020-01-21 13:32:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-01-21 13:32:30 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-01-21 13:32:30 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2020-01-21 13:32:30 0 [Note] InnoDB: Completed initialization of buffer pool
2020-01-21 13:32:30 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-01-21 13:32:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-01-21 13:32:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-01-21 13:32:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-01-21 13:32:30 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-01-21 13:32:30 0 [Note] InnoDB: Waiting for purge to start
2020-01-21 13:32:30 0 [Note] InnoDB: 10.4.10 started; log sequence number 114297397; transaction id 239043
2020-01-21 13:32:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-21 13:32:30 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-01-21 13:32:30 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-01-21 13:32:30 0 [Note] Reading of all Master_info entries succeeded
2020-01-21 13:32:30 0 [Note] Added new Master_info '' to hash table
2020-01-21 13:32:30 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.10-MariaDB-1:10.4.10+maria~bionic-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2020-01-21 13:32:31 0 [Note] InnoDB: Buffer pool(s) load completed at 200121 13:32:31
2020-01-21 13:34:00 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2020-01-21 13:34:00 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-01-21 13:34:00 0 [Note] InnoDB: FTS optimize thread exiting.
2020-01-21 13:34:00 0 [Note] InnoDB: Starting shutdown...
2020-01-21 13:34:00 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-01-21 13:34:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 200121 13:34:00
2020-01-21 13:34:00 0 [Note] InnoDB: Shutdown completed; log sequence number 114297406; transaction id 239046
2020-01-21 13:34:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-01-21 13:34:00 0 [Note] /usr/sbin/mysqld: Shutdown complete

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.