2020-10-28T18:37:07.660318Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:37:07.858749Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-28T18:37:07.906553Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-28T18:37:07.920781Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 955f8b08-194c-11eb-8152-fa163e3faba4.
2020-10-28T18:37:07.922371Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-10-28T18:37:09.044224Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:37:09.307788Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-10-28T18:37:16.057993Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:37:16.060211Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41521 ...
2020-10-28T18:37:16.066611Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:37:16.066649Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:37:16.066658Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:37:16.066665Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:37:16.066673Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:37:16.066680Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:37:16.067005Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:37:16.067147Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:37:16.069754Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:37:16.081831Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:37:16.084944Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-28T18:37:16.097070Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:37:16.107894Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:37:16.107976Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:37:16.132608Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:37:16.133685Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:37:16.133703Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:37:16.134609Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070
2020-10-28T18:37:16.134891Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:37:16.135303Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:37:16.137013Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:37:16
2020-10-28T18:37:16.143419Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:37:16.143440Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:37:16.144266Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:37:16.144314Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:37:16.146003Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2020-10-28T18:37:16.159026Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:37:16.159329Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/tmp/tmp.FMScultsJP/mysqld.sock'  port: 0  (Ubuntu)
2020-10-28T18:37:16.169215Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-10-28T18:37:16.171976Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T18:37:16.172000Z 0 [Note] Shutting down slave threads
2020-10-28T18:37:16.172011Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T18:37:16.172020Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T18:37:16.172094Z 0 [Note] Binlog end
2020-10-28T18:37:16.172584Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T18:37:16.172600Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T18:37:16.172607Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T18:37:16.172613Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T18:37:16.172619Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T18:37:16.172651Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T18:37:16.172658Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T18:37:16.172666Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T18:37:16.172673Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T18:37:16.172678Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T18:37:16.172683Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T18:37:16.172688Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T18:37:16.172694Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T18:37:16.172699Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T18:37:16.172704Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T18:37:16.172709Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T18:37:16.172715Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T18:37:16.172720Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T18:37:16.172725Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T18:37:16.172730Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T18:37:16.172735Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T18:37:16.172740Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T18:37:16.172745Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T18:37:16.172751Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T18:37:16.172756Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T18:37:16.172761Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T18:37:16.172766Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T18:37:16.172771Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T18:37:16.172776Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T18:37:16.172781Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T18:37:16.172786Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T18:37:16.172791Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T18:37:16.172796Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T18:37:16.172801Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T18:37:16.172806Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T18:37:16.172811Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T18:37:16.172816Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T18:37:16.172821Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T18:37:16.172897Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T18:37:16.173037Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T18:37:16.273270Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T18:37:16.273531Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 18:37:16
2020-10-28T18:37:17.781194Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089
2020-10-28T18:37:17.783415Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T18:37:17.783436Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T18:37:17.783445Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T18:37:17.783453Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T18:37:17.783471Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T18:37:17.783643Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T18:37:17.784086Z 0 [Note] mysqld: Shutdown complete

2020-10-28T18:37:19.788933Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:37:19.791197Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41664 ...
2020-10-28T18:37:19.797506Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:37:19.797546Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:37:19.797556Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:37:19.797564Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:37:19.797571Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:37:19.797580Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:37:19.797902Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:37:19.798043Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:37:19.800753Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:37:19.812727Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:37:19.815637Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-28T18:37:19.827879Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:37:19.838545Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:37:19.838637Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:37:19.862903Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:37:19.864026Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:37:19.864046Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:37:19.864511Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T18:37:19.914680Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089
2020-10-28T18:37:19.914938Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:37:19.915246Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:37:19.917740Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:37:19
2020-10-28T18:37:19.923009Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:37:19.923030Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:37:19.923855Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:37:19.923906Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:37:19.924014Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-10-28T18:37:19.924032Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-10-28T18:37:19.924085Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-28T18:37:19.935653Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:37:19.936036Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-28T18:43:59.325835Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T18:43:59.325884Z 0 [Note] Shutting down slave threads
2020-10-28T18:43:59.325905Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T18:43:59.325924Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T18:43:59.326025Z 0 [Note] Binlog end
2020-10-28T18:43:59.327246Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T18:43:59.327268Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T18:43:59.327279Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T18:43:59.327311Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T18:43:59.327320Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T18:43:59.327357Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T18:43:59.327364Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T18:43:59.327373Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T18:43:59.327380Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T18:43:59.327385Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T18:43:59.327391Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T18:43:59.327396Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T18:43:59.327401Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T18:43:59.327406Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T18:43:59.327411Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T18:43:59.327416Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T18:43:59.327421Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T18:43:59.327426Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T18:43:59.327431Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T18:43:59.327436Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T18:43:59.327441Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T18:43:59.327446Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T18:43:59.327451Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T18:43:59.327456Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T18:43:59.327461Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T18:43:59.327466Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T18:43:59.327471Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T18:43:59.327476Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T18:43:59.327482Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T18:43:59.327487Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T18:43:59.327492Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T18:43:59.327497Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T18:43:59.327502Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T18:43:59.327507Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T18:43:59.327512Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T18:43:59.327517Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T18:43:59.327522Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T18:43:59.327527Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T18:43:59.327615Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T18:43:59.327806Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T18:43:59.428126Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T18:43:59.428592Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 18:43:59
2020-10-28T18:44:00.738050Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117
2020-10-28T18:44:00.740682Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T18:44:00.740705Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T18:44:00.740714Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T18:44:00.740723Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T18:44:00.740729Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T18:44:00.740901Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T18:44:00.741386Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T18:44:00.865007Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T18:44:00.865320Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T18:44:01.081484Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:44:01.083592Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63173 ...
2020-10-28T18:44:01.090809Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:44:01.090846Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:44:01.090855Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:44:01.090862Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:44:01.090869Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:44:01.090877Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:44:01.091654Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:44:01.091819Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:44:01.094544Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:44:01.106205Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:44:01.109379Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-28T18:44:01.121532Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:44:01.142775Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:44:01.142877Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:44:01.168596Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:44:01.170430Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:44:01.170458Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:44:01.171660Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117
2020-10-28T18:44:01.171907Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:44:01.172162Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:44:01.174972Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:44:01
2020-10-28T18:44:01.181356Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:44:01.181387Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:44:01.182427Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:44:01.182487Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:44:01.182647Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T18:44:01.182674Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T18:44:01.182749Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T18:44:01.200204Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:44:01.200573Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-28T18:44:24.134964Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:44:39.242862Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:52:08.551822Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:52:08.552043Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:52:12.937991Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:53:54.115928Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:53:54.117266Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:58:48.238187Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-28T18:58:48.501141Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T18:58:48.501186Z 0 [Note] Shutting down slave threads
2020-10-28T18:58:48.501199Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T18:58:48.501210Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T18:58:48.501288Z 0 [Note] Binlog end
2020-10-28T18:58:48.503049Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T18:58:48.503066Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T18:58:48.503073Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T18:58:48.503080Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T18:58:48.503085Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T18:58:48.503123Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T18:58:48.503129Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T18:58:48.503138Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T18:58:48.503145Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T18:58:48.503150Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T18:58:48.503155Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T18:58:48.503160Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T18:58:48.503165Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T18:58:48.503170Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T18:58:48.503175Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T18:58:48.503180Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T18:58:48.503185Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T18:58:48.503190Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T18:58:48.503195Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T18:58:48.503200Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T18:58:48.503204Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T18:58:48.503209Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T18:58:48.503214Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T18:58:48.503219Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T18:58:48.503224Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T18:58:48.503229Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T18:58:48.503234Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T18:58:48.503239Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T18:58:48.503244Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T18:58:48.503249Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T18:58:48.503254Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T18:58:48.503259Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T18:58:48.503264Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T18:58:48.503269Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T18:58:48.503274Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T18:58:48.503279Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T18:58:48.503284Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T18:58:48.503288Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T18:58:48.503367Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T18:58:48.503511Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T18:58:48.603786Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T18:58:48.604339Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 18:58:48
2020-10-28T18:58:49.919348Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11823363
2020-10-28T18:58:49.921590Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T18:58:49.921638Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T18:58:49.921657Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T18:58:49.921669Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T18:58:49.921675Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T18:58:49.921851Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T18:58:49.922496Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T18:58:50.032547Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T18:58:50.032892Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T18:58:50.242490Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:58:50.244677Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 105694 ...
2020-10-28T18:58:50.252431Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:58:50.252466Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:58:50.252475Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:58:50.252483Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:58:50.252490Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:58:50.252498Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:58:50.253306Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:58:50.253454Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:58:50.256909Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:58:50.269557Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:58:50.273285Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-28T18:58:50.285510Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:58:50.314075Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:58:50.314189Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:58:50.338409Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:58:50.339544Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:58:50.339563Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:58:50.340675Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 11823363
2020-10-28T18:58:50.340947Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:58:50.341093Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:58:50.350532Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:58:50.350560Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:58:50.372481Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:58:50.372535Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:58:50.372648Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T18:58:50.372666Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T18:58:50.372703Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T18:58:50.375246Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:58:50
2020-10-28T18:58:50.386332Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:58:50.386650Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-28T18:59:13.918639Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:59:27.755961Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:06:44.896504Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:06:44.896718Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:06:49.545771Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:08:34.573745Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:08:34.584167Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:13:25.533624Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-28T19:13:25.798755Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T19:13:25.798790Z 0 [Note] Shutting down slave threads
2020-10-28T19:13:25.798803Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T19:13:25.798813Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T19:13:25.799054Z 0 [Note] Binlog end
2020-10-28T19:13:25.800913Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T19:13:25.800931Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T19:13:25.800939Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T19:13:25.800946Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T19:13:25.800953Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T19:13:25.800991Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T19:13:25.800998Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T19:13:25.801007Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T19:13:25.801014Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T19:13:25.801020Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T19:13:25.801026Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T19:13:25.801032Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T19:13:25.801038Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T19:13:25.801044Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T19:13:25.801050Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T19:13:25.801055Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T19:13:25.801061Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T19:13:25.801067Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T19:13:25.801073Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T19:13:25.801079Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T19:13:25.801084Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T19:13:25.801090Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T19:13:25.801096Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T19:13:25.801102Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T19:13:25.801107Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T19:13:25.801113Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T19:13:25.801119Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T19:13:25.801125Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T19:13:25.801130Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T19:13:25.801136Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T19:13:25.801142Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T19:13:25.801148Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T19:13:25.801154Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T19:13:25.801159Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T19:13:25.801178Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T19:13:25.801184Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T19:13:25.801190Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T19:13:25.801195Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T19:13:25.801276Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T19:13:25.801425Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T19:13:25.901641Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T19:13:25.902845Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 19:13:25
2020-10-28T19:13:27.120229Z 0 [Note] InnoDB: Shutdown completed; log sequence number 22877316
2020-10-28T19:13:27.123252Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T19:13:27.123276Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T19:13:27.123285Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T19:13:27.123294Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T19:13:27.123300Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T19:13:27.123476Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T19:13:27.124125Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T19:13:27.235980Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T19:13:27.236265Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T19:13:27.449498Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T19:13:27.451852Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 17415 ...
2020-10-28T19:13:27.457916Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T19:13:27.457951Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T19:13:27.457960Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T19:13:27.457968Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T19:13:27.457976Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T19:13:27.457984Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T19:13:27.458788Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T19:13:27.458934Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T19:13:27.461816Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T19:13:27.474412Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T19:13:27.477380Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-28T19:13:27.489581Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T19:13:27.522654Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T19:13:27.522768Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T19:13:27.548722Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T19:13:27.549842Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T19:13:27.549860Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T19:13:27.550787Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 22877316
2020-10-28T19:13:27.551040Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T19:13:27.551340Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T19:13:27.576362Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T19:13:27.576391Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T19:13:27.577275Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T19:13:27.577326Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T19:13:27.577455Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T19:13:27.577474Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T19:13:27.577510Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T19:13:27.609748Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 19:13:27
2020-10-28T19:13:27.613888Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T19:13:27.614226Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-28T19:13:50.842877Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:14:05.225289Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:21:23.288655Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:21:23.288839Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:21:27.776291Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:23:13.363627Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:23:13.374980Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:28:03.393269Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-28T19:28:03.680018Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T19:28:03.680055Z 0 [Note] Shutting down slave threads
2020-10-28T19:28:03.680068Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T19:28:03.680079Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T19:28:03.680181Z 0 [Note] Binlog end
2020-10-28T19:28:03.682225Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T19:28:03.682243Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T19:28:03.682251Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T19:28:03.682258Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T19:28:03.682264Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T19:28:03.682302Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T19:28:03.682312Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T19:28:03.682329Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T19:28:03.682344Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T19:28:03.682356Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T19:28:03.682369Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T19:28:03.682381Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T19:28:03.682392Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T19:28:03.682402Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T19:28:03.682413Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T19:28:03.682425Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T19:28:03.682437Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T19:28:03.682447Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T19:28:03.682457Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T19:28:03.682468Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T19:28:03.682480Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T19:28:03.682491Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T19:28:03.682503Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T19:28:03.682513Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T19:28:03.682534Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T19:28:03.682541Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T19:28:03.682546Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T19:28:03.682551Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T19:28:03.682556Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T19:28:03.682562Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T19:28:03.682567Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T19:28:03.682572Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T19:28:03.682578Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T19:28:03.682583Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T19:28:03.682588Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T19:28:03.682593Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T19:28:03.682598Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T19:28:03.682603Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T19:28:03.682735Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T19:28:03.685905Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T19:28:03.786175Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T19:28:03.786906Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 19:28:03
2020-10-28T19:28:05.404719Z 0 [Note] InnoDB: Shutdown completed; log sequence number 33711228
2020-10-28T19:28:05.407222Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T19:28:05.407244Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T19:28:05.407254Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T19:28:05.407263Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T19:28:05.407269Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T19:28:05.407446Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T19:28:05.408168Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T19:28:05.526792Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T19:28:05.527099Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T19:28:05.744112Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T19:28:05.746601Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 59995 ...
2020-10-28T19:28:05.753025Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T19:28:05.753061Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T19:28:05.753070Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T19:28:05.753078Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T19:28:05.753086Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T19:28:05.753094Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T19:28:05.753941Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T19:28:05.754087Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T19:28:05.757762Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T19:28:05.771892Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T19:28:05.774996Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-28T19:28:05.787381Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T19:28:05.821032Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T19:28:05.821143Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T19:28:05.838879Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T19:28:05.840104Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T19:28:05.840139Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T19:28:05.840889Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T19:28:05.891068Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 33711228
2020-10-28T19:28:05.891321Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T19:28:05.891519Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T19:28:05.925203Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T19:28:05.925233Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T19:28:05.926073Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T19:28:05.926117Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T19:28:05.926228Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T19:28:05.926246Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T19:28:05.926300Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T19:28:05.959597Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T19:28:05.959937Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-28T19:28:06.902703Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 19:28:06
2020-10-28T19:28:29.103956Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:28:43.252037Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:36:02.252695Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:36:02.252898Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:36:06.656446Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:38:01.020723Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:38:01.030509Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)