Skip to content

Instantly share code, notes, and snippets.

@kirreen
Created April 17, 2018 08:37
Show Gist options
  • Save kirreen/5b5e8f41caf8b38c10652639a8bb32b6 to your computer and use it in GitHub Desktop.
Save kirreen/5b5e8f41caf8b38c10652639a8bb32b6 to your computer and use it in GitHub Desktop.
[Entrypoint] Starting MySQL 5.7.20-1.1.2
2018-04-17T08:36:21.205522Z 0 [Note] mysqld (mysqld 5.7.20-log) starting as process 1 ...
2018-04-17T08:36:21.208642Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=erik-nginx-mysql-1-bin' to avoid this problem.
2018-04-17T08:36:21.225541Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-04-17T08:36:21.225569Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-17T08:36:21.225575Z 0 [Note] InnoDB: Uses event mutexes
2018-04-17T08:36:21.225586Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-04-17T08:36:21.225592Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-17T08:36:21.225597Z 0 [Note] InnoDB: Using Linux native AIO
2018-04-17T08:36:21.225628Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 4 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2018-04-17T08:36:21.226016Z 0 [Note] InnoDB: Number of pools: 1
2018-04-17T08:36:21.226185Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-04-17T08:36:21.229067Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-04-17T08:36:21.240993Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-04-17T08:36:21.243883Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-04-17T08:36:21.303099Z 0 [Note] InnoDB: Opened 2 undo tablespaces
2018-04-17T08:36:21.303127Z 0 [Note] InnoDB: 0 undo tablespaces made active
2018-04-17T08:36:21.303418Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-17T08:36:21.347119Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-04-17T08:36:21.347291Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-04-17T08:36:21.624416Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-04-17T08:36:21.624807Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
2018-04-17T08:36:21.625801Z 0 [Note] InnoDB: 1 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
2018-04-17T08:36:21.625817Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-04-17T08:36:21.626501Z 0 [Note] InnoDB: Waiting for purge to start
2018-04-17T08:36:21.677333Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 10698596
2018-04-17T08:36:21.677768Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-04-17T08:36:21.677966Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-04-17T08:36:21.699736Z 0 [Warning] unknown variable 'loose-group-replication-ip-whitelist=0.0.0.0/0'
2018-04-17T08:36:22.103753Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-04-17T08:36:22.103778Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2018-04-17T08:36:22.104713Z 0 [Warning] CA certificate ca.pem is self signed.
2018-04-17T08:36:22.104785Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2018-04-17T08:36:22.105216Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-17T08:36:22.105270Z 0 [Note] IPv6 is available.
2018-04-17T08:36:22.105297Z 0 [Note] - '::' resolves to '::';
2018-04-17T08:36:22.105328Z 0 [Note] Server socket created on IP: '::'.
2018-04-17T08:36:22.121731Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180417 8:36:22
2018-04-17T08:36:22.157742Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.157819Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.157840Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.157858Z 0 [Warning] 'user' entry 'healthchecker@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.157905Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.157912Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.157933Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.188482Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.188515Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-04-17T08:36:22.207432Z 0 [Note] Event Scheduler: Loaded 0 events
2018-04-17T08:36:22.207723Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-04-17T08:36:22.207740Z 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.
2018-04-17T08:36:22.207744Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-04-17T08:36:22.224363Z 0 [Note] End of list of non-natively partitioned tables
2018-04-17T08:36:30.413451Z 5 [Note] Aborted connection 5 to db: 'unconnected' user: 'root' host: '10.42.232.48' (Got an error reading communication packets)
2018-04-17T08:36:30.474510Z 7 [Note] Aborted connection 7 to db: 'unconnected' user: 'root' host: '10.42.232.48' (Got an error reading communication packets)
2018-04-17T08:36:40.405197Z 9 [Note] Aborted connection 9 to db: 'unconnected' user: 'root' host: '10.42.232.48' (Got an error reading communication packets)
2018-04-17T08:36:41.138017Z 12 [Note] Aborted connection 12 to db: 'unconnected' user: 'root' host: '10.42.232.48' (Got an error reading communication packets)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment