API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 26th, 2017
216
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 52.99 KB | None | 0 0
raw download clone embed print report
  1. 2017-01-26T17:40:07.635585Z 0 [Note] Giving 3 client threads a chance to die gracefully
  2. 2017-01-26T17:40:07.635673Z 0 [Note] Shutting down slave threads
  3. 2017-01-26T17:40:09.635827Z 0 [Note] Forcefully disconnecting 0 remaining clients
  4. 2017-01-26T17:40:09.635872Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  5. 2017-01-26T17:40:09.636053Z 0 [Note] Binlog end
  6. 2017-01-26T17:40:09.666715Z 0 [Note] Shutting down plugin 'ngram'
  7. 2017-01-26T17:40:09.666742Z 0 [Note] Shutting down plugin 'ARCHIVE'
  8. 2017-01-26T17:40:09.666747Z 0 [Note] Shutting down plugin 'partition'
  9. 2017-01-26T17:40:09.666751Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  10. 2017-01-26T17:40:09.666756Z 0 [Note] Shutting down plugin 'MEMORY'
  11. 2017-01-26T17:40:09.666802Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  12. 2017-01-26T17:40:09.666807Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  13. 2017-01-26T17:40:09.666810Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  14. 2017-01-26T17:40:09.666813Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  15. 2017-01-26T17:40:09.666816Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  16. 2017-01-26T17:40:09.666819Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  17. 2017-01-26T17:40:09.666822Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  18. 2017-01-26T17:40:09.666825Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  19. 2017-01-26T17:40:09.666828Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  20. 2017-01-26T17:40:09.666831Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  21. 2017-01-26T17:40:09.666834Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  22. 2017-01-26T17:40:09.666836Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  23. 2017-01-26T17:40:09.666839Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  24. 2017-01-26T17:40:09.666842Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  25. 2017-01-26T17:40:09.666845Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  26. 2017-01-26T17:40:09.666848Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  27. 2017-01-26T17:40:09.666851Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  28. 2017-01-26T17:40:09.666854Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  29. 2017-01-26T17:40:09.666857Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  30. 2017-01-26T17:40:09.666859Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  31. 2017-01-26T17:40:09.666862Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  32. 2017-01-26T17:40:09.666865Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  33. 2017-01-26T17:40:09.666868Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  34. 2017-01-26T17:40:09.666871Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  35. 2017-01-26T17:40:09.666873Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  36. 2017-01-26T17:40:09.666876Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  37. 2017-01-26T17:40:09.666879Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  38. 2017-01-26T17:40:09.666882Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  39. 2017-01-26T17:40:09.666884Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  40. 2017-01-26T17:40:09.666887Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  41. 2017-01-26T17:40:09.666890Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  42. 2017-01-26T17:40:09.666893Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
  43. 2017-01-26T17:40:09.666896Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  44. 2017-01-26T17:40:09.666899Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  45. 2017-01-26T17:40:09.666901Z 0 [Note] Shutting down plugin 'InnoDB'
  46. 2017-01-26T17:40:09.666990Z 0 [Note] InnoDB: FTS optimize thread exiting.
  47. 2017-01-26T17:40:09.667100Z 0 [Note] InnoDB: Starting shutdown...
  48. 2017-01-26T17:40:09.767296Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  49. 2017-01-26T17:40:09.782033Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170126 9:40:09
  50. 2017-01-26T17:40:10.467990Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
  51. 2017-01-26T17:40:13.471339Z 0 [Note] InnoDB: Shutdown completed; log sequence number 457919377691
  52. 2017-01-26T17:40:13.471786Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  53. 2017-01-26T17:40:13.471811Z 0 [Note] Shutting down plugin 'CSV'
  54. 2017-01-26T17:40:13.471819Z 0 [Note] Shutting down plugin 'MyISAM'
  55. 2017-01-26T17:40:13.471838Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  56. 2017-01-26T17:40:13.471847Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  57. 2017-01-26T17:40:13.471875Z 0 [Note] Shutting down plugin 'sha256_password'
  58. 2017-01-26T17:40:13.471878Z 0 [Note] Shutting down plugin 'mysql_native_password'
  59. 2017-01-26T17:40:13.472032Z 0 [Note] Shutting down plugin 'binlog'
  60. 2017-01-26T17:40:13.473537Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  61.  
  62. 2017-01-26T17:40:13.488229Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  63. 2017-01-26T17:40:14.333088Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
  64. 2017-01-26T17:40:14.523066Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  65. 2017-01-26T17:40:14.523147Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  66. 2017-01-26T17:40:14.524405Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-10-log) starting as process 3408 ...
  67. 2017-01-26T17:40:14.530842Z 0 [Note] InnoDB: PUNCH HOLE support available
  68. 2017-01-26T17:40:14.530888Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  69. 2017-01-26T17:40:14.530898Z 0 [Note] InnoDB: Uses event mutexes
  70. 2017-01-26T17:40:14.530906Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  71. 2017-01-26T17:40:14.530915Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  72. 2017-01-26T17:40:14.530927Z 0 [Note] InnoDB: Using Linux native AIO
  73. 2017-01-26T17:40:14.531855Z 0 [Note] InnoDB: Number of pools: 1
  74. 2017-01-26T17:40:14.531998Z 0 [Note] InnoDB: Using CPU crc32 instructions
  75. 2017-01-26T17:40:14.533372Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M
  76. 2017-01-26T17:40:16.173796Z 0 [Note] InnoDB: Completed initialization of buffer pool
  77. 2017-01-26T17:40:28.097441Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  78. 2017-01-26T17:40:28.112428Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  79. 2017-01-26T17:40:28.113556Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  80. 2017-01-26T17:40:30.444423Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes
  81. 2017-01-26T17:40:32.142548Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  82. 2017-01-26T17:40:32.142620Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  83. 2017-01-26T17:40:32.151387Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  84. 2017-01-26T17:40:32.152278Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  85. 2017-01-26T17:40:32.152286Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  86. 2017-01-26T17:40:32.152419Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4717ms. The settings might not be optimal. (flushed=0, during the time.)
  87. 2017-01-26T17:40:32.154283Z 0 [Note] InnoDB: Waiting for purge to start
  88. 2017-01-26T17:40:32.204526Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.16-10 started; log sequence number 457919377691
  89. 2017-01-26T17:40:32.205375Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  90. 2017-01-26T17:40:32.205538Z 0 [Note] Plugin 'FEDERATED' is disabled.
  91. 2017-01-26T17:40:32.222033Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  92. 2017-01-26T17:40:32.222047Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  93. 2017-01-26T17:40:32.228778Z 0 [Warning] CA certificate ca.pem is self signed.
  94. 2017-01-26T17:40:32.228830Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  95. 2017-01-26T17:40:32.229113Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  96. 2017-01-26T17:40:32.229207Z 0 [Note] IPv6 is available.
  97. 2017-01-26T17:40:32.229219Z 0 [Note] - '::' resolves to '::';
  98. 2017-01-26T17:40:32.229250Z 0 [Note] Server socket created on IP: '::'.
  99. 2017-01-26T17:40:32.249171Z 0 [Note] Event Scheduler: Loaded 0 events
  100. 2017-01-26T17:40:32.249318Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  101. Version: '5.7.16-10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 10, Revision a0c7d0d
  102. 2017-01-26T17:40:33.050503Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
  103. 2017-01-26T17:41:09.293794Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170126 9:41:09
  104. 2017-01-26T17:45:21.934942Z 0 [Note] Giving 4 client threads a chance to die gracefully
  105. 2017-01-26T17:45:21.935021Z 0 [Note] Shutting down slave threads
  106. 2017-01-26T17:45:23.935202Z 0 [Note] Forcefully disconnecting 2 remaining clients
  107. 2017-01-26T17:45:23.935245Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 6 user: 'eximstats'
  108.  
  109. 2017-01-26T17:45:23.935267Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 1604 user: 'root'
  110.  
  111. 2017-01-26T17:45:23.935328Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  112. 2017-01-26T17:45:23.935855Z 0 [Note] Binlog end
  113. 2017-01-26T17:45:23.964158Z 0 [Note] Shutting down plugin 'ngram'
  114. 2017-01-26T17:45:23.964181Z 0 [Note] Shutting down plugin 'ARCHIVE'
  115. 2017-01-26T17:45:23.964185Z 0 [Note] Shutting down plugin 'partition'
  116. 2017-01-26T17:45:23.964188Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  117. 2017-01-26T17:45:23.964193Z 0 [Note] Shutting down plugin 'MEMORY'
  118. 2017-01-26T17:45:23.964296Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  119. 2017-01-26T17:45:23.964302Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  120. 2017-01-26T17:45:23.964308Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  121. 2017-01-26T17:45:23.964311Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  122. 2017-01-26T17:45:23.964314Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  123. 2017-01-26T17:45:23.964316Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  124. 2017-01-26T17:45:23.964319Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  125. 2017-01-26T17:45:23.964321Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  126. 2017-01-26T17:45:23.964324Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  127. 2017-01-26T17:45:23.964326Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  128. 2017-01-26T17:45:23.964329Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  129. 2017-01-26T17:45:23.964331Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  130. 2017-01-26T17:45:23.964334Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  131. 2017-01-26T17:45:23.964336Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  132. 2017-01-26T17:45:23.964338Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  133. 2017-01-26T17:45:23.964341Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  134. 2017-01-26T17:45:23.964343Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  135. 2017-01-26T17:45:23.964346Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  136. 2017-01-26T17:45:23.964348Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  137. 2017-01-26T17:45:23.964351Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  138. 2017-01-26T17:45:23.964353Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  139. 2017-01-26T17:45:23.964355Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  140. 2017-01-26T17:45:23.964358Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  141. 2017-01-26T17:45:23.964360Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  142. 2017-01-26T17:45:23.964362Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  143. 2017-01-26T17:45:23.964365Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  144. 2017-01-26T17:45:23.964367Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  145. 2017-01-26T17:45:23.964369Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  146. 2017-01-26T17:45:23.964372Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  147. 2017-01-26T17:45:23.964374Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  148. 2017-01-26T17:45:23.964376Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  149. 2017-01-26T17:45:23.964379Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
  150. 2017-01-26T17:45:23.964413Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  151. 2017-01-26T17:45:23.964416Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  152. 2017-01-26T17:45:23.964418Z 0 [Note] Shutting down plugin 'InnoDB'
  153. 2017-01-26T17:45:23.964524Z 0 [Note] InnoDB: FTS optimize thread exiting.
  154. 2017-01-26T17:45:23.964611Z 0 [Note] InnoDB: Starting shutdown...
  155. 2017-01-26T17:45:24.064759Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  156. 2017-01-26T17:45:24.079866Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170126 9:45:24
  157. 2017-01-26T17:45:24.565202Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
  158. 2017-01-26T17:45:26.975196Z 0 [Note] InnoDB: Shutdown completed; log sequence number 457925643146
  159. 2017-01-26T17:45:26.977370Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  160. 2017-01-26T17:45:26.977383Z 0 [Note] Shutting down plugin 'CSV'
  161. 2017-01-26T17:45:26.977390Z 0 [Note] Shutting down plugin 'MyISAM'
  162. 2017-01-26T17:45:26.977409Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  163. 2017-01-26T17:45:26.977417Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  164. 2017-01-26T17:45:26.977446Z 0 [Note] Shutting down plugin 'sha256_password'
  165. 2017-01-26T17:45:26.977450Z 0 [Note] Shutting down plugin 'mysql_native_password'
  166. 2017-01-26T17:45:26.977612Z 0 [Note] Shutting down plugin 'binlog'
  167. 2017-01-26T17:45:26.978714Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  168.  
  169. 2017-01-26T17:45:26.994038Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  170. 2017-01-26T17:45:28.619704Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
  171. 2017-01-26T17:45:28.815070Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  172. 2017-01-26T17:45:28.815164Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  173. 2017-01-26T17:45:28.816613Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-10-log) starting as process 5864 ...
  174. 2017-01-26T17:45:28.824354Z 0 [Note] InnoDB: PUNCH HOLE support available
  175. 2017-01-26T17:45:28.824403Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  176. 2017-01-26T17:45:28.824414Z 0 [Note] InnoDB: Uses event mutexes
  177. 2017-01-26T17:45:28.824427Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  178. 2017-01-26T17:45:28.824436Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  179. 2017-01-26T17:45:28.824444Z 0 [Note] InnoDB: Using Linux native AIO
  180. 2017-01-26T17:45:28.825473Z 0 [Note] InnoDB: Number of pools: 1
  181. 2017-01-26T17:45:28.825629Z 0 [Note] InnoDB: Using CPU crc32 instructions
  182. 2017-01-26T17:45:28.827131Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M
  183. 2017-01-26T17:45:30.517141Z 0 [Note] InnoDB: Completed initialization of buffer pool
  184. 2017-01-26T17:45:31.340254Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  185. 2017-01-26T17:45:31.355119Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  186. 2017-01-26T17:45:31.356179Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  187. 2017-01-26T17:45:39.044944Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes
  188. 2017-01-26T17:45:39.824077Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  189. 2017-01-26T17:45:39.824141Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  190. 2017-01-26T17:45:39.830967Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  191. 2017-01-26T17:45:39.831721Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  192. 2017-01-26T17:45:39.831729Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  193. 2017-01-26T17:45:39.831891Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8492ms. The settings might not be optimal. (flushed=0, during the time.)
  194. 2017-01-26T17:45:39.832055Z 0 [Note] InnoDB: Waiting for purge to start
  195. 2017-01-26T17:45:39.882302Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.16-10 started; log sequence number 457925643146
  196. 2017-01-26T17:45:39.882617Z 0 [Note] Plugin 'FEDERATED' is disabled.
  197. 2017-01-26T17:45:39.883065Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  198. 2017-01-26T17:45:39.897368Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  199. 2017-01-26T17:45:39.897383Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  200. 2017-01-26T17:45:39.903650Z 0 [Warning] CA certificate ca.pem is self signed.
  201. 2017-01-26T17:45:39.903711Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  202. 2017-01-26T17:45:39.904055Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  203. 2017-01-26T17:45:39.904169Z 0 [Note] IPv6 is available.
  204. 2017-01-26T17:45:39.904194Z 0 [Note] - '::' resolves to '::';
  205. 2017-01-26T17:45:39.904245Z 0 [Note] Server socket created on IP: '::'.
  206. 2017-01-26T17:45:39.927546Z 0 [Note] Event Scheduler: Loaded 0 events
  207. 2017-01-26T17:45:39.927734Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  208. Version: '5.7.16-10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 10, Revision a0c7d0d
  209. 2017-01-26T17:45:40.258502Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
  210. 2017-01-26T17:46:02.972189Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170126 9:46:02
  211. 2017-01-26T17:50:27.165537Z 0 [Note] Giving 7 client threads a chance to die gracefully
  212. 2017-01-26T17:50:27.165630Z 0 [Note] Shutting down slave threads
  213. 2017-01-26T17:50:29.165755Z 0 [Note] Forcefully disconnecting 1 remaining clients
  214. 2017-01-26T17:50:29.165794Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 10 user: 'eximstats'
  215.  
  216. 2017-01-26T17:50:29.165821Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  217. 2017-01-26T17:50:29.166122Z 0 [Note] Binlog end
  218. 2017-01-26T17:50:29.199453Z 0 [Note] Shutting down plugin 'ngram'
  219. 2017-01-26T17:50:29.199480Z 0 [Note] Shutting down plugin 'ARCHIVE'
  220. 2017-01-26T17:50:29.199487Z 0 [Note] Shutting down plugin 'partition'
  221. 2017-01-26T17:50:29.199490Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  222. 2017-01-26T17:50:29.199496Z 0 [Note] Shutting down plugin 'MEMORY'
  223. 2017-01-26T17:50:29.199624Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  224. 2017-01-26T17:50:29.199631Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  225. 2017-01-26T17:50:29.199634Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  226. 2017-01-26T17:50:29.199638Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  227. 2017-01-26T17:50:29.199641Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  228. 2017-01-26T17:50:29.199644Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  229. 2017-01-26T17:50:29.199647Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  230. 2017-01-26T17:50:29.199651Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  231. 2017-01-26T17:50:29.199654Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  232. 2017-01-26T17:50:29.199657Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  233. 2017-01-26T17:50:29.199660Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  234. 2017-01-26T17:50:29.199663Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  235. 2017-01-26T17:50:29.199666Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  236. 2017-01-26T17:50:29.199669Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  237. 2017-01-26T17:50:29.199672Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  238. 2017-01-26T17:50:29.199675Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  239. 2017-01-26T17:50:29.199678Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  240. 2017-01-26T17:50:29.199681Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  241. 2017-01-26T17:50:29.199685Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  242. 2017-01-26T17:50:29.199688Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  243. 2017-01-26T17:50:29.199691Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  244. 2017-01-26T17:50:29.199728Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  245. 2017-01-26T17:50:29.199732Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  246. 2017-01-26T17:50:29.199735Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  247. 2017-01-26T17:50:29.199738Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  248. 2017-01-26T17:50:29.199741Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  249. 2017-01-26T17:50:29.199744Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  250. 2017-01-26T17:50:29.199747Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  251. 2017-01-26T17:50:29.199750Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  252. 2017-01-26T17:50:29.199753Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  253. 2017-01-26T17:50:29.199757Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  254. 2017-01-26T17:50:29.199759Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
  255. 2017-01-26T17:50:29.199763Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  256. 2017-01-26T17:50:29.199766Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  257. 2017-01-26T17:50:29.199769Z 0 [Note] Shutting down plugin 'InnoDB'
  258. 2017-01-26T17:50:29.199863Z 0 [Note] InnoDB: FTS optimize thread exiting.
  259. 2017-01-26T17:50:29.199960Z 0 [Note] InnoDB: Starting shutdown...
  260. 2017-01-26T17:50:29.300190Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  261. 2017-01-26T17:50:29.319731Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170126 9:50:29
  262. 2017-01-26T17:50:29.500326Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
  263. 2017-01-26T17:50:31.809746Z 0 [Note] InnoDB: Shutdown completed; log sequence number 457932741494
  264. 2017-01-26T17:50:31.810813Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  265. 2017-01-26T17:50:31.810826Z 0 [Note] Shutting down plugin 'CSV'
  266. 2017-01-26T17:50:31.810833Z 0 [Note] Shutting down plugin 'MyISAM'
  267. 2017-01-26T17:50:31.810853Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  268. 2017-01-26T17:50:31.810864Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  269. 2017-01-26T17:50:31.810896Z 0 [Note] Shutting down plugin 'sha256_password'
  270. 2017-01-26T17:50:31.810899Z 0 [Note] Shutting down plugin 'mysql_native_password'
  271. 2017-01-26T17:50:31.811059Z 0 [Note] Shutting down plugin 'binlog'
  272. 2017-01-26T17:50:31.812358Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  273.  
  274. 2017-01-26T17:50:31.827470Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  275. 2017-01-26T17:50:32.854323Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
  276. 2017-01-26T17:50:33.051573Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  277. 2017-01-26T17:50:33.051662Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  278. 2017-01-26T17:50:33.053100Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-10-log) starting as process 8114 ...
  279. 2017-01-26T17:50:33.059475Z 0 [Note] InnoDB: PUNCH HOLE support available
  280. 2017-01-26T17:50:33.059499Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  281. 2017-01-26T17:50:33.059507Z 0 [Note] InnoDB: Uses event mutexes
  282. 2017-01-26T17:50:33.059511Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  283. 2017-01-26T17:50:33.059515Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  284. 2017-01-26T17:50:33.059519Z 0 [Note] InnoDB: Using Linux native AIO
  285. 2017-01-26T17:50:33.060214Z 0 [Note] InnoDB: Number of pools: 1
  286. 2017-01-26T17:50:33.060290Z 0 [Note] InnoDB: Using CPU crc32 instructions
  287. 2017-01-26T17:50:33.061500Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M
  288. 2017-01-26T17:50:34.998314Z 0 [Note] InnoDB: Completed initialization of buffer pool
  289. 2017-01-26T17:50:35.837035Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  290. 2017-01-26T17:50:35.852085Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  291. 2017-01-26T17:50:35.852884Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  292. 2017-01-26T17:50:36.594001Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes
  293. 2017-01-26T17:50:37.596958Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  294. 2017-01-26T17:50:37.597023Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  295. 2017-01-26T17:50:37.604048Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  296. 2017-01-26T17:50:37.604734Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  297. 2017-01-26T17:50:37.604741Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  298. 2017-01-26T17:50:37.605539Z 0 [Note] InnoDB: Waiting for purge to start
  299. 2017-01-26T17:50:37.655722Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.16-10 started; log sequence number 457932741494
  300. 2017-01-26T17:50:37.656404Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  301. 2017-01-26T17:50:37.657234Z 0 [Note] Plugin 'FEDERATED' is disabled.
  302. 2017-01-26T17:50:37.675653Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  303. 2017-01-26T17:50:37.675672Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  304. 2017-01-26T17:50:37.683961Z 0 [Warning] CA certificate ca.pem is self signed.
  305. 2017-01-26T17:50:37.684023Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  306. 2017-01-26T17:50:37.684406Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  307. 2017-01-26T17:50:37.684511Z 0 [Note] IPv6 is available.
  308. 2017-01-26T17:50:37.684534Z 0 [Note] - '::' resolves to '::';
  309. 2017-01-26T17:50:37.684565Z 0 [Note] Server socket created on IP: '::'.
  310. 2017-01-26T17:50:37.702366Z 0 [Note] Event Scheduler: Loaded 0 events
  311. 2017-01-26T17:50:37.702524Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  312. Version: '5.7.16-10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 10, Revision a0c7d0d
  313. 2017-01-26T17:50:38.412245Z 9 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
  314. 2017-01-26T17:50:56.712829Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170126 9:50:56
  315. 2017-01-26T17:55:49.909087Z 0 [Note] Giving 6 client threads a chance to die gracefully
  316. 2017-01-26T17:55:49.909203Z 0 [Note] Shutting down slave threads
  317. 2017-01-26T17:55:51.909566Z 0 [Note] Forcefully disconnecting 2 remaining clients
  318. 2017-01-26T17:55:51.909604Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 13 user: 'eximstats'
  319.  
  320. 2017-01-26T17:55:51.909625Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 2227 user: 'root'
  321.  
  322. 2017-01-26T17:55:51.909678Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  323. 2017-01-26T17:55:51.909972Z 0 [Note] Binlog end
  324. 2017-01-26T17:55:51.935669Z 0 [Note] Shutting down plugin 'ngram'
  325. 2017-01-26T17:55:51.935695Z 0 [Note] Shutting down plugin 'ARCHIVE'
  326. 2017-01-26T17:55:51.935699Z 0 [Note] Shutting down plugin 'partition'
  327. 2017-01-26T17:55:51.935702Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  328. 2017-01-26T17:55:51.935706Z 0 [Note] Shutting down plugin 'MEMORY'
  329. 2017-01-26T17:55:51.935774Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  330. 2017-01-26T17:55:51.935780Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  331. 2017-01-26T17:55:51.935782Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  332. 2017-01-26T17:55:51.935785Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  333. 2017-01-26T17:55:51.935787Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  334. 2017-01-26T17:55:51.935790Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  335. 2017-01-26T17:55:51.935792Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  336. 2017-01-26T17:55:51.935794Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  337. 2017-01-26T17:55:51.935797Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  338. 2017-01-26T17:55:51.935799Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  339. 2017-01-26T17:55:51.935801Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  340. 2017-01-26T17:55:51.935804Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  341. 2017-01-26T17:55:51.936196Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  342. 2017-01-26T17:55:51.936209Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  343. 2017-01-26T17:55:51.936215Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  344. 2017-01-26T17:55:51.936220Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  345. 2017-01-26T17:55:51.936226Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  346. 2017-01-26T17:55:51.936232Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  347. 2017-01-26T17:55:51.936238Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  348. 2017-01-26T17:55:51.936244Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  349. 2017-01-26T17:55:51.936250Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  350. 2017-01-26T17:55:51.936256Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  351. 2017-01-26T17:55:51.936261Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  352. 2017-01-26T17:55:51.936267Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  353. 2017-01-26T17:55:51.936273Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  354. 2017-01-26T17:55:51.936278Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  355. 2017-01-26T17:55:51.936284Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  356. 2017-01-26T17:55:51.936290Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  357. 2017-01-26T17:55:51.936295Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  358. 2017-01-26T17:55:51.936301Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  359. 2017-01-26T17:55:51.936322Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  360. 2017-01-26T17:55:51.936327Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
  361. 2017-01-26T17:55:51.936334Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  362. 2017-01-26T17:55:51.936339Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  363. 2017-01-26T17:55:51.936345Z 0 [Note] Shutting down plugin 'InnoDB'
  364. 2017-01-26T17:55:51.936449Z 0 [Note] InnoDB: FTS optimize thread exiting.
  365. 2017-01-26T17:55:51.936577Z 0 [Note] InnoDB: Starting shutdown...
  366. 2017-01-26T17:55:52.036835Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  367. 2017-01-26T17:55:52.051728Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170126 9:55:52
  368. 2017-01-26T17:55:52.937803Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
  369. 2017-01-26T17:55:55.442366Z 0 [Note] InnoDB: Shutdown completed; log sequence number 457941132996
  370. 2017-01-26T17:55:55.443512Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  371. 2017-01-26T17:55:55.443525Z 0 [Note] Shutting down plugin 'CSV'
  372. 2017-01-26T17:55:55.443533Z 0 [Note] Shutting down plugin 'MyISAM'
  373. 2017-01-26T17:55:55.443552Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  374. 2017-01-26T17:55:55.443562Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  375. 2017-01-26T17:55:55.443595Z 0 [Note] Shutting down plugin 'sha256_password'
  376. 2017-01-26T17:55:55.443598Z 0 [Note] Shutting down plugin 'mysql_native_password'
  377. 2017-01-26T17:55:55.443751Z 0 [Note] Shutting down plugin 'binlog'
  378. 2017-01-26T17:55:55.445289Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  379.  
  380. 2017-01-26T17:55:55.457711Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  381. 2017-01-26T17:55:56.622949Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
  382. 2017-01-26T17:55:56.819208Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  383. 2017-01-26T17:55:56.819284Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  384. 2017-01-26T17:55:56.820729Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-10-log) starting as process 10168 ...
  385. 2017-01-26T17:55:56.827693Z 0 [Note] InnoDB: PUNCH HOLE support available
  386. 2017-01-26T17:55:56.827737Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  387. 2017-01-26T17:55:56.827751Z 0 [Note] InnoDB: Uses event mutexes
  388. 2017-01-26T17:55:56.827760Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  389. 2017-01-26T17:55:56.827768Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  390. 2017-01-26T17:55:56.827776Z 0 [Note] InnoDB: Using Linux native AIO
  391. 2017-01-26T17:55:56.828693Z 0 [Note] InnoDB: Number of pools: 1
  392. 2017-01-26T17:55:56.828831Z 0 [Note] InnoDB: Using CPU crc32 instructions
  393. 2017-01-26T17:55:56.829900Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M
  394. 2017-01-26T17:55:58.496542Z 0 [Note] InnoDB: Completed initialization of buffer pool
  395. 2017-01-26T17:55:59.294289Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  396. 2017-01-26T17:55:59.309161Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  397. 2017-01-26T17:55:59.309732Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  398. 2017-01-26T17:56:00.032463Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes
  399. 2017-01-26T17:56:00.826369Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  400. 2017-01-26T17:56:00.826449Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  401. 2017-01-26T17:56:00.833562Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  402. 2017-01-26T17:56:00.834397Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  403. 2017-01-26T17:56:00.834406Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  404. 2017-01-26T17:56:00.835286Z 0 [Note] InnoDB: Waiting for purge to start
  405. 2017-01-26T17:56:00.885479Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.16-10 started; log sequence number 457941132996
  406. 2017-01-26T17:56:00.885920Z 0 [Note] Plugin 'FEDERATED' is disabled.
  407. 2017-01-26T17:56:00.886367Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  408. 2017-01-26T17:56:00.910789Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  409. 2017-01-26T17:56:00.910818Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  410. 2017-01-26T17:56:00.922356Z 0 [Warning] CA certificate ca.pem is self signed.
  411. 2017-01-26T17:56:00.922417Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  412. 2017-01-26T17:56:00.922744Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  413. 2017-01-26T17:56:00.922842Z 0 [Note] IPv6 is available.
  414. 2017-01-26T17:56:00.922861Z 0 [Note] - '::' resolves to '::';
  415. 2017-01-26T17:56:00.922892Z 0 [Note] Server socket created on IP: '::'.
  416. 2017-01-26T17:56:00.946870Z 0 [Note] Event Scheduler: Loaded 0 events
  417. 2017-01-26T17:56:00.947103Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  418. Version: '5.7.16-10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 10, Revision a0c7d0d
  419. 2017-01-26T17:56:01.150491Z 2 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
  420. 2017-01-26T17:56:10.339175Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170126 9:56:10
  421. 2017-01-26T18:00:46.949467Z 0 [Note] Giving 3 client threads a chance to die gracefully
  422. 2017-01-26T18:00:46.949529Z 0 [Note] Shutting down slave threads
  423. 2017-01-26T18:00:48.949681Z 0 [Note] Forcefully disconnecting 2 remaining clients
  424. 2017-01-26T18:00:48.949721Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 1521 user: 'root'
  425.  
  426. 2017-01-26T18:00:48.949770Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 12 user: 'eximstats'
  427.  
  428. 2017-01-26T18:00:48.949792Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  429. 2017-01-26T18:00:48.950139Z 0 [Note] Binlog end
  430. 2017-01-26T18:00:48.975542Z 0 [Note] Shutting down plugin 'ngram'
  431. 2017-01-26T18:00:48.975573Z 0 [Note] Shutting down plugin 'ARCHIVE'
  432. 2017-01-26T18:00:48.975579Z 0 [Note] Shutting down plugin 'partition'
  433. 2017-01-26T18:00:48.975582Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  434. 2017-01-26T18:00:48.975588Z 0 [Note] Shutting down plugin 'MEMORY'
  435. 2017-01-26T18:00:48.975635Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  436. 2017-01-26T18:00:48.975640Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  437. 2017-01-26T18:00:48.975675Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  438. 2017-01-26T18:00:48.975679Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  439. 2017-01-26T18:00:48.975682Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  440. 2017-01-26T18:00:48.975685Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  441. 2017-01-26T18:00:48.975688Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  442. 2017-01-26T18:00:48.975691Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  443. 2017-01-26T18:00:48.975694Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  444. 2017-01-26T18:00:48.975697Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  445. 2017-01-26T18:00:48.975700Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  446. 2017-01-26T18:00:48.975703Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  447. 2017-01-26T18:00:48.975706Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  448. 2017-01-26T18:00:48.975709Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  449. 2017-01-26T18:00:48.975712Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  450. 2017-01-26T18:00:48.975715Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  451. 2017-01-26T18:00:48.975718Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  452. 2017-01-26T18:00:48.975721Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  453. 2017-01-26T18:00:48.975724Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  454. 2017-01-26T18:00:48.975727Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  455. 2017-01-26T18:00:48.975730Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  456. 2017-01-26T18:00:48.975733Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  457. 2017-01-26T18:00:48.975736Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  458. 2017-01-26T18:00:48.975739Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  459. 2017-01-26T18:00:48.975742Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  460. 2017-01-26T18:00:48.975745Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  461. 2017-01-26T18:00:48.975748Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  462. 2017-01-26T18:00:48.975751Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  463. 2017-01-26T18:00:48.975754Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  464. 2017-01-26T18:00:48.975757Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  465. 2017-01-26T18:00:48.975760Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  466. 2017-01-26T18:00:48.975763Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
  467. 2017-01-26T18:00:48.975766Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  468. 2017-01-26T18:00:48.975769Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  469. 2017-01-26T18:00:48.975772Z 0 [Note] Shutting down plugin 'InnoDB'
  470. 2017-01-26T18:00:48.975889Z 0 [Note] InnoDB: FTS optimize thread exiting.
  471. 2017-01-26T18:00:48.975987Z 0 [Note] InnoDB: Starting shutdown...
  472. 2017-01-26T18:00:49.076171Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  473. 2017-01-26T18:00:49.093004Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170126 10:00:49
  474. 2017-01-26T18:00:50.077235Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
  475. 2017-01-26T18:00:52.402219Z 0 [Note] InnoDB: Shutdown completed; log sequence number 457946241723
  476. 2017-01-26T18:00:52.403382Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  477. 2017-01-26T18:00:52.403393Z 0 [Note] Shutting down plugin 'CSV'
  478. 2017-01-26T18:00:52.403400Z 0 [Note] Shutting down plugin 'MyISAM'
  479. 2017-01-26T18:00:52.403418Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  480. 2017-01-26T18:00:52.403427Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  481. 2017-01-26T18:00:52.403454Z 0 [Note] Shutting down plugin 'sha256_password'
  482. 2017-01-26T18:00:52.403457Z 0 [Note] Shutting down plugin 'mysql_native_password'
  483. 2017-01-26T18:00:52.403619Z 0 [Note] Shutting down plugin 'binlog'
  484. 2017-01-26T18:00:52.404886Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  485.  
  486. 2017-01-26T18:00:52.419242Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  487. 2017-01-26T18:00:53.631888Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
  488. 2017-01-26T18:00:53.825171Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  489. 2017-01-26T18:00:53.825246Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  490. 2017-01-26T18:00:53.826695Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-10-log) starting as process 12055 ...
  491. 2017-01-26T18:00:53.834435Z 0 [Note] InnoDB: PUNCH HOLE support available
  492. 2017-01-26T18:00:53.834487Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  493. 2017-01-26T18:00:53.834498Z 0 [Note] InnoDB: Uses event mutexes
  494. 2017-01-26T18:00:53.834506Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  495. 2017-01-26T18:00:53.834514Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  496. 2017-01-26T18:00:53.834526Z 0 [Note] InnoDB: Using Linux native AIO
  497. 2017-01-26T18:00:53.835538Z 0 [Note] InnoDB: Number of pools: 1
  498. 2017-01-26T18:00:53.835670Z 0 [Note] InnoDB: Using CPU crc32 instructions
  499. 2017-01-26T18:00:53.837215Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M
  500. 2017-01-26T18:00:55.747158Z 0 [Note] InnoDB: Completed initialization of buffer pool
  501. 2017-01-26T18:00:56.583670Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  502. 2017-01-26T18:00:56.598173Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  503. 2017-01-26T18:00:56.599126Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  504. 2017-01-26T18:00:57.362900Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes
  505. 2017-01-26T18:00:58.340823Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  506. 2017-01-26T18:00:58.340897Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  507. 2017-01-26T18:00:58.347926Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  508. 2017-01-26T18:00:58.348692Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  509. 2017-01-26T18:00:58.348699Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  510. 2017-01-26T18:00:58.351027Z 0 [Note] InnoDB: Waiting for purge to start
  511. 2017-01-26T18:00:58.401219Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.16-10 started; log sequence number 457946241723
  512. 2017-01-26T18:00:58.401647Z 0 [Note] Plugin 'FEDERATED' is disabled.
  513. 2017-01-26T18:00:58.402259Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  514. 2017-01-26T18:00:58.420793Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  515. 2017-01-26T18:00:58.420809Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  516. 2017-01-26T18:00:58.427280Z 0 [Warning] CA certificate ca.pem is self signed.
  517. 2017-01-26T18:00:58.427330Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  518. 2017-01-26T18:00:58.427687Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  519. 2017-01-26T18:00:58.427799Z 0 [Note] IPv6 is available.
  520. 2017-01-26T18:00:58.427830Z 0 [Note] - '::' resolves to '::';
  521. 2017-01-26T18:00:58.427875Z 0 [Note] Server socket created on IP: '::'.
  522. 2017-01-26T18:00:58.453072Z 0 [Note] Event Scheduler: Loaded 0 events
  523. 2017-01-26T18:00:58.453278Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  524. Version: '5.7.16-10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 10, Revision a0c7d0d
  525. 2017-01-26T18:00:59.191706Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
  526. 2017-01-26T18:01:08.692958Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170126 10:01:08
  527. 2017-01-26T18:05:49.742478Z 0 [Note] Giving 3 client threads a chance to die gracefully
  528. 2017-01-26T18:05:49.742607Z 0 [Note] Shutting down slave threads
  529. 2017-01-26T18:05:51.742745Z 0 [Note] Forcefully disconnecting 1 remaining clients
  530. 2017-01-26T18:05:51.742770Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 4 user: 'eximstats'
  531.  
  532. 2017-01-26T18:05:51.742814Z 0 [Note] Event Scheduler: Purging the queue. 0 events
  533. 2017-01-26T18:05:51.743370Z 0 [Note] Binlog end
  534. 2017-01-26T18:05:51.771852Z 0 [Note] Shutting down plugin 'ngram'
  535. 2017-01-26T18:05:51.771883Z 0 [Note] Shutting down plugin 'ARCHIVE'
  536. 2017-01-26T18:05:51.771888Z 0 [Note] Shutting down plugin 'partition'
  537. 2017-01-26T18:05:51.771892Z 0 [Note] Shutting down plugin 'BLACKHOLE'
  538. 2017-01-26T18:05:51.771896Z 0 [Note] Shutting down plugin 'MEMORY'
  539. 2017-01-26T18:05:51.771989Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
  540. 2017-01-26T18:05:51.771996Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  541. 2017-01-26T18:05:51.771999Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  542. 2017-01-26T18:05:51.772003Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  543. 2017-01-26T18:05:51.772006Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  544. 2017-01-26T18:05:51.772009Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  545. 2017-01-26T18:05:51.772013Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  546. 2017-01-26T18:05:51.772016Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  547. 2017-01-26T18:05:51.772019Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  548. 2017-01-26T18:05:51.772022Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  549. 2017-01-26T18:05:51.772025Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  550. 2017-01-26T18:05:51.772028Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  551. 2017-01-26T18:05:51.772031Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  552. 2017-01-26T18:05:51.772034Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  553. 2017-01-26T18:05:51.772038Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  554. 2017-01-26T18:05:51.772041Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  555. 2017-01-26T18:05:51.772044Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  556. 2017-01-26T18:05:51.772047Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
  557. 2017-01-26T18:05:51.772050Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
  558. 2017-01-26T18:05:51.772053Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  559. 2017-01-26T18:05:51.772057Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  560. 2017-01-26T18:05:51.772060Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  561. 2017-01-26T18:05:51.772063Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  562. 2017-01-26T18:05:51.772066Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  563. 2017-01-26T18:05:51.772069Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  564. 2017-01-26T18:05:51.772072Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
  565. 2017-01-26T18:05:51.772075Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  566. 2017-01-26T18:05:51.772078Z 0 [Note] Shutting down plugin 'INNODB_CMP'
  567. 2017-01-26T18:05:51.772081Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  568. 2017-01-26T18:05:51.772084Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
  569. 2017-01-26T18:05:51.772087Z 0 [Note] Shutting down plugin 'INNODB_TRX'
  570. 2017-01-26T18:05:51.772090Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
  571. 2017-01-26T18:05:51.772094Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  572. 2017-01-26T18:05:51.772097Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  573. 2017-01-26T18:05:51.772100Z 0 [Note] Shutting down plugin 'InnoDB'
  574. 2017-01-26T18:05:51.772199Z 0 [Note] InnoDB: FTS optimize thread exiting.
  575. 2017-01-26T18:05:51.772313Z 0 [Note] InnoDB: Starting shutdown...
  576. 2017-01-26T18:05:51.872542Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
  577. 2017-01-26T18:05:51.884452Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170126 10:05:51
  578. 2017-01-26T18:05:52.673361Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
  579. 2017-01-26T18:05:55.459033Z 0 [Note] InnoDB: Shutdown completed; log sequence number 457953136069
  580. 2017-01-26T18:05:55.459462Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  581. 2017-01-26T18:05:55.459471Z 0 [Note] Shutting down plugin 'CSV'
  582. 2017-01-26T18:05:55.459477Z 0 [Note] Shutting down plugin 'MyISAM'
  583. 2017-01-26T18:05:55.459491Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
  584. 2017-01-26T18:05:55.459516Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  585. 2017-01-26T18:05:55.459543Z 0 [Note] Shutting down plugin 'sha256_password'
  586. 2017-01-26T18:05:55.459545Z 0 [Note] Shutting down plugin 'mysql_native_password'
  587. 2017-01-26T18:05:55.459679Z 0 [Note] Shutting down plugin 'binlog'
  588. 2017-01-26T18:05:55.460696Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  589.  
  590. 2017-01-26T18:05:55.474883Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  591. 2017-01-26T18:05:56.420662Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
  592. 2017-01-26T18:05:56.611546Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  593. 2017-01-26T18:05:56.611628Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
  594. 2017-01-26T18:05:56.613076Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-10-log) starting as process 14125 ...
  595. 2017-01-26T18:05:56.620364Z 0 [Note] InnoDB: PUNCH HOLE support available
  596. 2017-01-26T18:05:56.620393Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  597. 2017-01-26T18:05:56.620399Z 0 [Note] InnoDB: Uses event mutexes
  598. 2017-01-26T18:05:56.620403Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  599. 2017-01-26T18:05:56.620407Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  600. 2017-01-26T18:05:56.620412Z 0 [Note] InnoDB: Using Linux native AIO
  601. 2017-01-26T18:05:56.621260Z 0 [Note] InnoDB: Number of pools: 1
  602. 2017-01-26T18:05:56.621354Z 0 [Note] InnoDB: Using CPU crc32 instructions
  603. 2017-01-26T18:05:56.622765Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M
  604. 2017-01-26T18:05:58.591204Z 0 [Note] InnoDB: Completed initialization of buffer pool
  605. 2017-01-26T18:05:59.427992Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  606. 2017-01-26T18:05:59.442353Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  607. 2017-01-26T18:05:59.443152Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  608. 2017-01-26T18:06:00.194548Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes
  609. 2017-01-26T18:06:01.214983Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  610. 2017-01-26T18:06:01.215051Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  611. 2017-01-26T18:06:01.222515Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  612. 2017-01-26T18:06:01.223218Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  613. 2017-01-26T18:06:01.223226Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  614. 2017-01-26T18:06:01.224799Z 0 [Note] InnoDB: Waiting for purge to start
  615. 2017-01-26T18:06:01.275032Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.16-10 started; log sequence number 457953136069
  616. 2017-01-26T18:06:01.275331Z 0 [Note] Plugin 'FEDERATED' is disabled.
  617. 2017-01-26T18:06:01.275925Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  618. 2017-01-26T18:06:01.291984Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  619. 2017-01-26T18:06:01.291998Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  620. 2017-01-26T18:06:01.298333Z 0 [Warning] CA certificate ca.pem is self signed.
  621. 2017-01-26T18:06:01.298378Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  622. 2017-01-26T18:06:01.298684Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  623. 2017-01-26T18:06:01.298788Z 0 [Note] IPv6 is available.
  624. 2017-01-26T18:06:01.298811Z 0 [Note] - '::' resolves to '::';
  625. 2017-01-26T18:06:01.298853Z 0 [Note] Server socket created on IP: '::'.
  626. 2017-01-26T18:06:01.315905Z 0 [Note] Event Scheduler: Loaded 0 events
  627. 2017-01-26T18:06:01.316052Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  628. Version: '5.7.16-10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 10, Revision a0c7d0d
  629. 2017-01-26T18:06:01.992493Z 5 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
  630. 2017-01-26T18:06:09.614994Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170126 10:06:09
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!