Home > database >  Do not regularly without automatic restart MYSQL service
Do not regularly without automatic restart MYSQL service

Time:09-27

This is when the restart of the LOG, there is no other error!
The T10:2018-08-15 57:04. 065617 z 0 [Note] InnoDB: page_cleaner: 1000 ms intended loop took 6912 ms. The Settings took The not be optimal. (flushed=200 and evicted=0, during The time.)
: the 2018-08-15 T11 46:19. 671500 z 0 [Note]/usr/sbin/mysqld (mysqld 5.7.17) starting as the process of 27823...
: the 2018-08-15 T11 46:19. 850184 z 0 [Note] InnoDB: PUNCH HOLE support available
: the 2018-08-15 T11 46:19. 850224 z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
: the 2018-08-15 T11 46:19. 850230 z 0 [Note] InnoDB: Uses the event mutexes
: the 2018-08-15 T11 46:19. 850235 z 0 [Note] InnoDB: GCC builtin __sync_synchronize () is 2 for the memory barrier
: the 2018-08-15 T11 46:19. 850240 z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
: the 2018-08-15 T11 46:19. 850247 z 0 [Note] InnoDB: Using Linux native AIO
: the 2018-08-15 T11 46:19. 852433 z 0 [Note] InnoDB: Number of pools: 1
: the 2018-08-15 T11 46:19. 852569 z 0 [Note] InnoDB: Using CPU crc32 instructions
: the 2018-08-15 T11 46:19. 853861 z 0 [Note] InnoDB: Initializing buffer pool, the total size=3 g, the instances=2, the chunk size=128 m
The 2018-08-15 T11: now. 117924 z 0 [Note] InnoDB: Completed initialization of buffer pool
: the 2018-08-15 T11 now. 144739 z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority ().
: the 2018-08-15 T11 now. 175240 z 0 [Note] InnoDB: Highest supported file format is Barracuda.
The 2018-08-15 T11: now. 213402 z 0 [Note] InnoDB: Log scan progressed past the checkpoint LSN 187352683223
: the 2018-08-15 T11 now. 213452 z 0 [Note] InnoDB: Doing recovery: scanned one log sequence number 187352683232
: the 2018-08-15 T11 now. 228231 z 0 [Note] InnoDB: Doing recovery: scanned one log sequence number 187352683232
: the 2018-08-15 T11 now. 228259 z 0 InnoDB [Note] : the Database was not shutdown normally!
The 2018-08-15 T11: now. 228266 z 0 [Note] InnoDB: Starting crash recovery.
: the 2018-08-15 T11 46:21. 017925 z 0 [Note] InnoDB: Removed temporary in tablespace data file: "ibtmp1
": the 2018-08-15 T11 46:21. 017950 z 0 [Note] InnoDB: Creating Shared in tablespace for temporary tables
: the 2018-08-15 T11 46:21. 017994 z 0 [Note] InnoDB: Setting the file './ibtmp1 'size to 12 MB. Physically their file full; Both Please wait...
: the 2018-08-15 T11 46:21. 105443 z 0 [Note] InnoDB: the File './ibtmp1 'size is now 12 MB.
: the 2018-08-15 T11 46:21. 106249 z 0 [Note] InnoDB: 96 redo the rollback segment (s) found. 96 redo the rollback segment (s) are active.
: the 2018-08-15 T11 46:21. 106263 z 0 [Note] InnoDB: 32 non - redo the rollback segment (s) are active.
: the 2018-08-15 T11 46:21. 106600 z 0 [Note] InnoDB: Waiting for purge to start
: the 2018-08-15 T11 46:21. 156748 z 0 [Note] InnoDB: 5.7.17 started; The log sequence number 187352683232
: the 2018-08-15 T11 46:21. 157534 z 0 [Note] the Plugin 'FEDERATED is disabled.
: the 2018-08-15 T11 46:21. 158340 z 0 [Note] InnoDB: Loading buffer pool (s) from the/var/lib/mysql/ib_buffer_pool
: the 2018-08-15 T11 46:21. 186059 z 0 [Note] Found ca. Pem, server - cert. Pem and server - key. Pem in data directory. Trying to enable SSL support using them.
: the 2018-08-15 T11 46:21. 189986 z 0 [Warning] CA certificate CA. The pem is self signed.
[Note: the 2018-08-15 T11 46:21. 195839 z 0] Server hostname (bind - address) : '*'; Port: 3306
: the 2018-08-15 T11 46:21. 195883 z 0 [Note] IPv6 is available.
: the 2018-08-15 T11 46:21. 195897 z 0 [Note] - ': :' resolves to '... ';
[Note: the 2018-08-15 T11 46:21. 195919 z 0] Server socket created on IP: ':'.
: the 2018-08-15 T11 46:21. 212616 z 0 [Warning] 'user' entry 'root @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212665 z 0 [Warning] 'user' entry 'mysql. Sys @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212675 z 0 [Warning] 'user' entry 'KPPW @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212684 z 0 [Warning] 'user' entry 'lvshiguan @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212692 z 0 [Warning] 'user' entry 'BBS @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212701 z 0 [Warning] 'user' entry 'zhimeng @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212709 z 0 [Warning] 'user' entry 'VLCMS @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212717 z 0 [Warning] 'user' entry 'foxphp @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212725 z 0 [Warning] 'user' entry 'h5 @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212737 z 0 [Warning] 'user' entry 'zhibo @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212746 z 0 [Warning] 'user' entry 'luhan @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 212754 z 0 [Warning] 'user' entry 'lili @ localhost' ignored - in the skip - name - resolve mode.
: the 2018-08-15 T11 46:21. 213514 z 0 [Warning] 'db' entry 'sys mysql. Sys @ localhost' ignored - in the skip - name - resolve mode.
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related