2017-09-27T11:29:35.551655Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-09-27T11:29:35.551807Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-09-27T11:29:35.554273Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-09-27T11:29:35.554292Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-09-27T11:29:36.068801Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-09-27T11:29:36.188213Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-09-27T11:29:36.313059Z 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: 24468171-a377-11e7-84c2-080027747f04.
2017-09-27T11:29:36.320214Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-09-27T11:29:37.177264Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-27T11:29:37.280446Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2017-09-27T11:29:39.570895Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-09-27T11:29:39.571005Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-09-27T11:29:39.926773Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-09-27T11:29:39.926820Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-09-27T11:29:41.099507Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-27T11:29:44.712506Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2017-09-27T11:29:44.839146Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-09-27T11:29:44.914989Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-09-27T11:29:44.918062Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-09-27T11:29:45.243179Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-09-27T11:29:45.243201Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-09-27T11:29:45.250698Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-17) starting as process 13155 ...
2017-09-27T11:29:45.327167Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-09-27T11:29:45.327205Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-27T11:29:45.327213Z 0 [Note] InnoDB: Uses event mutexes
2017-09-27T11:29:45.327219Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-27T11:29:45.327226Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-27T11:29:45.327231Z 0 [Note] InnoDB: Using Linux native AIO
2017-09-27T11:29:45.328388Z 0 [Note] InnoDB: Number of pools: 1
2017-09-27T11:29:45.330225Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-09-27T11:29:45.334073Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-09-27T11:29:45.351554Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-09-27T11:29:45.357587Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-09-27T11:29:45.439565Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2017-09-27T11:29:45.444879Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-27T11:29:45.473179Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
2017-09-27T11:29:45.566291Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-09-27T11:29:45.566364Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-09-27T11:29:45.672342Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-09-27T11:29:45.680162Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-09-27T11:29:45.680189Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-09-27T11:29:45.732058Z 0 [Note] InnoDB: Waiting for purge to start
2017-09-27T11:29:45.782330Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.19-17 started; log sequence number 2544802
2017-09-27T11:29:45.785730Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-09-27T11:29:45.791391Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-09-27T11:29:45.888252Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170927 11:29:45
2017-09-27T11:29:45.993812Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-09-27T11:29:45.998899Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-09-27T11:29:46.049928Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-27T11:29:46.055221Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-09-27T11:29:46.061727Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-09-27T11:29:46.065002Z 0 [Note] IPv6 is available.
2017-09-27T11:29:46.066312Z 0 [Note]   - '::' resolves to '::';
2017-09-27T11:29:46.067036Z 0 [Note] Server socket created on IP: '::'.
2017-09-27T11:29:46.283276Z 0 [Note] Event Scheduler: Loaded 0 events
2017-09-27T11:29:46.284092Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.19-17'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '17', Revision 'e19a6b7b73f'
2017-09-27T11:29:46.284115Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 
2017-09-27T11:29:46.284122Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-09-27T11:29:46.417217Z 0 [Note] End of list of non-natively partitioned tables