2016-04-28T10:06:21.728001Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/xyz/
2016-04-28T10:06:21.899180Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2016-04-28T10:06:21.899776Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12-log) starting as process 13852 ...
2016-04-28T10:06:21.903377Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-04-28T10:06:21.903404Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-28T10:06:21.903410Z 0 [Note] InnoDB: Uses event mutexes
2016-04-28T10:06:21.903414Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-04-28T10:06:21.903418Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-28T10:06:21.903422Z 0 [Note] InnoDB: Using Linux native AIO
2016-04-28T10:06:21.903626Z 0 [Note] InnoDB: Number of pools: 1
2016-04-28T10:06:21.903731Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-04-28T10:06:21.910772Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2016-04-28T10:06:22.148805Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-28T10:06:22.171048Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-04-28T10:06:22.182892Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-28T10:06:22.254558Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-28T10:06:22.254630Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-28T10:06:22.383000Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-04-28T10:06:22.384467Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-28T10:06:22.384485Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-28T10:06:22.384947Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-28T10:06:22.435180Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 2528046
2016-04-28T10:06:22.435431Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/xyz/ib_buffer_pool
2016-04-28T10:06:22.437098Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160428 12:06:22
2016-04-28T10:06:22.437389Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-28T10:06:22.453840Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2016-04-28T10:06:22.454179Z 0 [Warning] CA certificate ca.pem is self signed.
2016-04-28T10:06:22.456801Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-28T10:06:22.456853Z 0 [Note] IPv6 is available.
2016-04-28T10:06:22.456866Z 0 [Note]   - '::' resolves to '::';
2016-04-28T10:06:22.456922Z 0 [Note] Server socket created on IP: '::'.
2016-04-28T10:06:22.467690Z 0 [Note] Event Scheduler: Loaded 0 events
2016-04-28T10:06:22.467905Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.12-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2016-04-28T10:06:29.780687Z 2 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='mysql-bin.000037', master_log_pos= 94547783, master_bind=''.
Killed
2016-04-28T12:05:14.144290Z mysqld_safe Number of processes running now: 0
2016-04-28T12:05:14.146524Z mysqld_safe mysqld restarted
2016-04-28T12:05:14.563097Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2016-04-28T12:05:14.584994Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12-log) starting as process 14135 ...
2016-04-28T12:05:14.636567Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-04-28T12:05:14.636599Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-28T12:05:14.636605Z 0 [Note] InnoDB: Uses event mutexes
2016-04-28T12:05:14.636615Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-04-28T12:05:14.636621Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-28T12:05:14.636624Z 0 [Note] InnoDB: Using Linux native AIO
2016-04-28T12:05:14.640084Z 0 [Note] InnoDB: Number of pools: 1
2016-04-28T12:05:14.644416Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-04-28T12:05:14.651695Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2016-04-28T12:05:14.845200Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-28T12:05:14.867497Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-04-28T12:05:14.893106Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-28T12:05:15.207029Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 17155508000
2016-04-28T12:05:16.490402Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17160750592
2016-04-28T12:05:16.608501Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17165993472
2016-04-28T12:05:16.740549Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17171236352
2016-04-28T12:05:16.876010Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17176479232
2016-04-28T12:05:16.994880Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17181722112
2016-04-28T12:05:17.187790Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17186964992
2016-04-28T12:05:17.334144Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17192207872
2016-04-28T12:05:17.556788Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17197450752
2016-04-28T12:05:17.726588Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17202693632
2016-04-28T12:05:17.818201Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17207936512
2016-04-28T12:05:17.887653Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17213179392
2016-04-28T12:05:17.910299Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17218422272
2016-04-28T12:05:17.923535Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17221306093
2016-04-28T12:05:17.955499Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17157801472
2016-04-28T12:05:18.014124Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17163044352
2016-04-28T12:05:18.074941Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17168287232
2016-04-28T12:05:18.132361Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17173530112
2016-04-28T12:05:18.187777Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17178772992
2016-04-28T12:05:18.249933Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17184015872
2016-04-28T12:05:18.308346Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17189258752
2016-04-28T12:05:18.368988Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17194501632
2016-04-28T12:05:18.488287Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17199744512
2016-04-28T12:05:18.599434Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17204987392
2016-04-28T12:05:18.619672Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17210230272
2016-04-28T12:05:18.624134Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17215473152
2016-04-28T12:05:18.628703Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17220716032
2016-04-28T12:05:18.630084Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17221306093
2016-04-28T12:05:18.630574Z 0 [Note] InnoDB: Database was not shutdown normally!
2016-04-28T12:05:18.630585Z 0 [Note] InnoDB: Starting crash recovery.
2016-04-28T12:05:18.770994Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo
2016-04-28T12:05:18.771066Z 0 [Note] InnoDB: Trx id counter is 436480
2016-04-28T12:05:18.771196Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
2016-04-28T12:05:20.332600Z 0 [Note] InnoDB: Apply batch completed
2016-04-28T12:05:20.332792Z 0 [Note] InnoDB: Last MySQL binlog file position 0 259907369, file name xyz-db1_binlog.000015
2016-04-28T12:06:38.119395Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
2016-04-28T12:06:38.119471Z 0 [Note] InnoDB: Rolling back trx with id 435999, 1 rows to undo
2016-04-28T12:06:38.120552Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-04-28T12:06:38.120573Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-28T12:06:38.120629Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-28T12:06:38.122652Z 0 [Note] InnoDB: Rollback of trx with id 435999 completed
2016-04-28T12:06:38.123066Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2016-04-28T12:06:38.185003Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-04-28T12:06:38.190137Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-28T12:06:38.190160Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-28T12:06:38.190486Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-28T12:06:38.240602Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 17221306093
2016-04-28T12:06:38.240728Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 83373ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2016-04-28T12:06:38.240790Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/xyz/ib_buffer_pool
2016-04-28T12:06:38.242226Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-28T12:06:38.245835Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160428 14:06:38
2016-04-28T12:06:38.251560Z 0 [Note] Recovering after a crash using /var/lib/mysql/xyz-db1_binlog
2016-04-28T12:06:39.869980Z 0 [Note] Starting crash recovery...
2016-04-28T12:06:39.870099Z 0 [Note] Crash recovery finished.
2016-04-28T12:06:40.647982Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2016-04-28T12:06:40.651685Z 0 [Warning] CA certificate ca.pem is self signed.
2016-04-28T12:06:40.657519Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-28T12:06:40.657582Z 0 [Note] IPv6 is available.
2016-04-28T12:06:40.657598Z 0 [Note]   - '::' resolves to '::';
2016-04-28T12:06:40.657612Z 0 [Note] Server socket created on IP: '::'.
2016-04-28T12:06:40.696421Z 0 [Warning] Recovery from master pos 94547783 and file mysql-bin.000037 for channel ''. Previous relay log pos and relay log file had been set to 4, /var/lib/mysql/slave-relay.000001 respectively.
2016-04-28T12:06:40.749040Z 0 [Note] Event Scheduler: Loaded 0 events
2016-04-28T12:06:40.749475Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.12-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)