Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 112019-11-16T02:40:23.509403Z 0 [Note] Giving 0 client threads a chance to die gracefully
- 2019-11-16T02:40:23.965013Z 0 [Note] Shutting down slave threads
- 2019-11-16T02:40:23.965051Z 0 [Note] Forcefully disconnecting 0 remaining clients
- 2019-11-16T02:40:23.965077Z 0 [Note] Event Scheduler: Purging the queue. 0 events
- 2019-11-16T02:40:24.190165Z 0 [Note] Binlog end
- 2019-11-16T02:40:25.411626Z 0 [Note] Shutting down plugin 'ngram'
- 2019-11-16T02:40:25.496665Z 0 [Note] Shutting down plugin 'partition'
- ...
- 019-11-16T02:40:25.769528Z 0 [Note] InnoDB: Starting shutdown...
- 2019-11-16T02:40:25.869892Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
- 2019-11-16T02:40:26.126344Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 191116 8:10:26
- 2019-11-16T02:41:25.983262Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:42:26.185150Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:43:26.379025Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:44:26.559561Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:45:26.768094Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:46:26.954149Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:47:27.161839Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:48:27.355070Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:49:27.550413Z 0 [Note] InnoDB: Waiting for 1 active transactions to finish
- 2019-11-16T02:50:52.237203Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
- 2019-11-16T02:50:52.237237Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
- 2019-11-16T02:50:52.395369Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2019-11-16T02:50:52.413670Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1) starting as process 1132 ...
- 2019-11-16T02:50:52.496921Z 0 [Note] InnoDB: PUNCH HOLE support available
- 2019-11-16T02:50:52.496936Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2019-11-16T02:50:52.496939Z 0 [Note] InnoDB: Uses event mutexes
- 2019-11-16T02:50:52.496944Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
- 2019-11-16T02:50:52.496946Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2019-11-16T02:50:52.496949Z 0 [Note] InnoDB: Using Linux native AIO
- 2019-11-16T02:50:52.497103Z 0 [Note] InnoDB: Number of pools: 1
- 2019-11-16T02:50:52.497169Z 0 [Note] InnoDB: Using CPU crc32 instructions
- 2019-11-16T02:50:52.506477Z 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M
- 2019-11-16T02:50:52.961562Z 0 [Note] InnoDB: Completed initialization of buffer pool
- 2019-11-16T02:50:53.045433Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
- 2019-11-16T02:50:53.180558Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
- 2019-11-16T02:50:53.335396Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 4739454800197
- 2019-11-16T02:50:53.951014Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4739460042752
- 2019-11-16T02:50:54.593468Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4739465285632
- 2019-11-16T02:50:55.738765Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4739470528512
- 2019-11-16T02:50:55.786231Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4739470775770
- 2019-11-16T02:50:55.788862Z 0 [Note] InnoDB: Database was not shutdown normally!
- 2019-11-16T02:50:55.788869Z 0 [Note] InnoDB: Starting crash recovery.
- 2019-11-16T03:07:33.594010Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1053M row operations to undo
- 2019-11-16T03:07:33.617731Z 0 [Note] InnoDB: Trx id counter is 28142848
- 2019-11-16T03:07:33.619528Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
- InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
- 2019-11-16T03:07:35.985926Z 0 [Note] InnoDB: Apply batch completed
- 2019-11-16T03:07:43.274781Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
- 2019-11-16T03:07:43.274886Z 0 [Note] InnoDB: Rolling back trx with id 28097028, 1053M rows to undo
- 2019-11-16T03:07:43.292713Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
- 2019-11-16T03:07:43.292776Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
- 2019-11-16T03:07:43.292915Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
- InnoDB: Progress in percents: 12019-11-16T03:07:44.414671Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
- 2019-11-16T03:07:44.416617Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
- 2019-11-16T03:07:44.416647Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
- 2019-11-16T03:07:44.417598Z 0 [Note] InnoDB: Waiting for purge to start
- 2019-11-16T03:07:44.467957Z 0 [Note] InnoDB: Waiting for purge to start
- 2019-11-16T03:07:44.518303Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 4739470775770
- 2019-11-16T03:07:44.518338Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 1011288ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
- 2019-11-16T03:07:44.618261Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
- 2019-11-16T03:07:44.638373Z 0 [Note] Plugin 'FEDERATED' is disabled.
- 2019-11-16T03:07:44.891422Z 0 [Warning] CA certificate /etc/mysql/ssl/ca.pem is self signed.
- 2019-11-16T03:07:44.894750Z 0 [Note] Server hostname (bind-address): '10.0.0.21'; port: 3306
- 2019-11-16T03:07:44.894794Z 0 [Note] - '10.0.0.21' resolves to '10.0.0.21';
- 2019-11-16T03:07:44.894840Z 0 [Note] Server socket created on IP: '10.0.0.21'.
- 2019-11-16T03:07:45.962105Z 0 [Note] Event Scheduler: Loaded 0 events
- 2019-11-16T03:07:45.962644Z 0 [Note] /usr/sbin/mysqld: ready for connections.
- Version: '5.7.27-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
- 2019-11-16T03:15:39.226555Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4545ms. The settings might not be optimal. (flushed=147 and evicted=0, during the time.)
- 2019-11-16T03:16:44.393023Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4319ms. The settings might not be optimal. (flushed=404 and evicted=0, during the time.)
- 2019-11-16T03:18:47.555235Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4579ms. The settings might not be optimal. (flushed=107 and evicted=0, during the time.)
- 2019-11-16T03:18:57.282261Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4004ms. The settings might not be optimal. (flushed=245 and evicted=0, during the time.)
- 2019-11-16T03:23:52.890499Z 0 [Note] InnoDB: Buffer pool(s) load completed at 191116 8:53:52
- 22019-11-16T04:35:07.265717Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4157ms. The settings might not be optimal. (flushed=208 and evicted=0, during the time.)
- 3 4 5
Add Comment
Please, Sign In to add comment