1,查看日志的ERROR
2018-05-23T01:26:59.230382Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-05-23T01:26:59.230409Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-05-23T01:26:59.230457Z 0 [Note] /usr/bin/mysqld (mysqld 5.7.18-log) starting as process 1274 ...
2018-05-23T01:26:59.232456Z 0 [Warning] Using pre 5.5 semantics to load error messages from /usr/share/.
2018-05-23T01:26:59.232467Z 0 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.
2018-05-23T01:26:59.338644Z 0 [Warning] InnoDB: Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
2018-05-23T01:26:59.338778Z 0 [Note] InnoDB: PUNCH HOLE support not available
2018-05-23T01:26:59.338797Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-23T01:26:59.338811Z 0 [Note] InnoDB: Uses event mutexes
2018-05-23T01:26:59.338820Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-05-23T01:26:59.338841Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-23T01:26:59.338849Z 0 [Note] InnoDB: Using Linux native AIO
2018-05-23T01:26:59.343415Z 0 [Note] InnoDB: Number of pools: 1
2018-05-23T01:26:59.343606Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-05-23T01:26:59.351180Z 0 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 8, chunk size = 128M
2018-05-23T01:27:01.144704Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-23T01:27:01.805956Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-05-23T01:27:01.869612Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-23T01:27:02.161447Z 0 [Note] InnoDB: The log sequence number 463085832558 in the system tablespace does not match the log sequence number 527415094655 in the ib_logfiles! --表示磁盘lsn和共享表空间中lsn不一致
2018-05-23T01:27:02.161487Z 0 [Note] InnoDB: Database was not shutdown normally! --显示没有正常关机
2018-05-23T01:27:02.161500Z 0 [Note] InnoDB: Starting crash recovery.
2018-05-23T01:27:03.342445Z 0 [Note] InnoDB: Last MySQL binlog file position 0 835316239, file name slave1-bin.000662
2018-05-23T01:27:14.727716Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-23T01:27:14.727757Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-23T01:27:14.735961Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-23T01:27:14.779905Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-05-23T01:27:14.781644Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-23T01:27:14.781675Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-23T01:27:14.783034Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-23T01:27:14.833225Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13028ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-23T01:27:14.844368Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 527415094655
2018-05-23T01:27:14.844947Z 0 [Note] InnoDB: Loading buffer pool(s) from /r2/mysqldata/ib_buffer_pool
2018-05-23T01:27:14.845201Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180523 9:27:14 (/r2/mysqldata/ib_buffer_pool was empty)
2018-05-23T01:27:14.850829Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-23T01:27:31.198380Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-05-23T01:27:31.198414Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-05-23T01:27:31.198460Z 0 [Note] IPv6 is available.
2018-05-23T01:27:31.198473Z 0 [Note] - '::' resolves to '::';
2018-05-23T01:27:31.198521Z 0 [Note] Server socket created on IP: '::'.
2018-05-23T01:27:31.198551Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2018-05-23T01:27:31.198557Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? --显示端口被占用
2018-05-23T01:27:31.198569Z 0 [ERROR] Aborting
2018-05-23T01:27:31.201402Z 0 [Note] Binlog end
2018-05-23T01:27:31.202398Z 0 [Note] Shutting down plugin 'ngram'
2018-05-23T01:27:31.202428Z 0 [Note] Shutting down plugin 'partition'
2018-05-23T01:27:31.202434Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-05-23T01:27:31.202439Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-05-23T01:27:31.202447Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-05-23T01:27:31.202453Z 0 [Note] Shutting down plugin 'MyISAM'
2018-05-23T01:27:31.203867Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-05-23T01:27:31.203880Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-05-23T01:27:31.203885Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-05-23T01:27:31.203890Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-05-23T01:27:31.203895Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-05-23T01:27:31.203899Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-05-23T01:27:31.203904Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-05-23T01:27:31.203909Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-05-23T01:27:31.203913Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-05-23T01:27:31.203923Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-05-23T01:27:31.203927Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-05-23T01:27:31.203932Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-05-23T01:27:31.203936Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-05-23T01:27:31.203940Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-05-23T01:27:31.203945Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-05-23T01:27:31.203950Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-05-23T01:27:31.203954Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-05-23T01:27:31.203959Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-05-23T01:27:31.203963Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-05-23T01:27:31.203968Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-05-23T01:27:31.203972Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-05-23T01:27:31.203984Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-05-23T01:27:31.203989Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-05-23T01:27:31.203993Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-05-23T01:27:31.203997Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-05-23T01:27:31.204002Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-05-23T01:27:31.204006Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-05-23T01:27:31.204010Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-05-23T01:27:31.204015Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-05-23T01:27:31.204019Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-05-23T01:27:31.204024Z 0 [Note] Shutting down plugin 'InnoDB'
2018-05-23T01:27:31.204097Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-05-23T01:27:31.204234Z 0 [Note] InnoDB: Starting shutdown...
2018-05-23T01:27:31.304450Z 0 [Note] InnoDB: Dumping buffer pool(s) to /r2/mysqldata/ib_buffer_pool
2018-05-23T01:27:31.305044Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180523 9:27:31
2018-05-23T01:27:33.817117Z 0 [Note] InnoDB: Shutdown completed; log sequence number 527415094683
2018-05-23T01:27:33.817469Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-23T01:27:33.817494Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-05-23T01:27:33.817618Z 0 [Note] Shutting down plugin 'MEMORY'
2018-05-23T01:27:33.817632Z 0 [Note] Shutting down plugin 'CSV'
2018-05-23T01:27:33.817642Z 0 [Note] Shutting down plugin 'sha256_password'
2018-05-23T01:27:33.817659Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-05-23T01:27:33.817898Z 0 [Note] Shutting down plugin 'binlog'
2018-05-23T01:27:33.819411Z 0 [Note] /usr/bin/mysqld: Shutdown complete2018-05-23T01:26:59.230382Z 0 [W
