Nach 1-2 Tagen schaltet sich die Mysql bei mir aus. In den 1-2 Tagen habe ich nicht auf dem Server zugegriffen. Wenn ich dann mit dem Befehl "service mysql-sever start" starte, dann ist Mysql trotzdem noch off und erst nachdem ich ganze Root rebootet habe, läuft alles wieder.
Code
- 2017-09-17 20:26:49 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.37) starting as process 5074 ...
- 2017-09-17 20:26:49 5074 [Note] Plugin 'FEDERATED' is disabled.
- 2017-09-17 20:26:49 5074 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2017-09-17 20:26:49 5074 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-09-17 20:26:49 5074 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-09-17 20:26:49 5074 [Note] InnoDB: Memory barrier is not used
- 2017-09-17 20:26:49 5074 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-09-17 20:26:49 5074 [Note] InnoDB: Using CPU crc32 instructions
- 2017-09-17 20:26:49 5074 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Completed initialization of buffer pool
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Highest supported file format is Barracuda.
- 2017-09-17 20:26:50 5074 [Note] InnoDB: The log sequence numbers 6881298 and 6881298 in ibdata files do not match the log sequence number 7419104 in the ib_logfiles!
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Database was not shutdown normally!
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Starting crash recovery.
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Reading tablespace information from the .ibd files...
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Restoring possible half-written data pages
- 2017-09-17 20:26:50 5074 [Note] InnoDB: from the doublewrite buffer...
- 2017-09-17 20:26:50 5074 [Note] InnoDB: 128 rollback segment(s) are active.
- 2017-09-17 20:26:50 5074 [Note] InnoDB: Waiting for purge to start
- 2017-09-17 20:26:50 5074 [Note] InnoDB: 5.6.37 started; log sequence number 7419104
- 170917 20:27:30 mysqld_safe mysqld from pid file /var/db/mysql/root600795.kms4.cc.pid ended
- 170917 23:01:14 mysqld_safe Logging to '/var/db/mysql/root600795.kms4.cc.err'.
- 170917 23:01:15 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2017-09-17 23:01:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2017-09-17 23:01:18 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.37) starting as process 5583 ...
- 2017-09-17 23:01:25 5583 [Note] Plugin 'FEDERATED' is disabled.
- 2017-09-17 23:01:25 5583 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2017-09-17 23:01:25 5583 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-09-17 23:01:25 5583 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-09-17 23:01:25 5583 [Note] InnoDB: Memory barrier is not used
- 2017-09-17 23:01:25 5583 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-09-17 23:01:25 5583 [Note] InnoDB: Using CPU crc32 instructions
- 2017-09-17 23:01:25 5583 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2017-09-17 23:01:44 5583 [Note] InnoDB: Completed initialization of buffer pool
- 170917 23:04:56 mysqld_safe mysqld from pid file /var/db/mysql/root600795.kms4.cc.pid ended
- 170917 23:11:40 mysqld_safe Logging to '/var/db/mysql/root600795.kms4.cc.err'.
- 170917 23:11:40 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2017-09-17 23:11:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2017-09-17 23:11:42 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.37) starting as process 5993 ...
- 2017-09-17 23:11:42 5993 [Note] Plugin 'FEDERATED' is disabled.
- 2017-09-17 23:11:42 5993 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2017-09-17 23:11:42 5993 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-09-17 23:11:42 5993 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-09-17 23:11:42 5993 [Note] InnoDB: Memory barrier is not used
- 2017-09-17 23:11:42 5993 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-09-17 23:11:42 5993 [Note] InnoDB: Using CPU crc32 instructions
- 2017-09-17 23:11:42 5993 [Note] InnoDB: Initializing buffer pool, size = 128.0M
