mysql 启动失败

问答中心分类: OneinStackmysql 启动失败
匿名用户 asked 8年 ago
Starting MySQL
.... * The server quit without updating PID file (/data/mysql/mysql.pid).

2 Answers
wuyanzu answered 8年 ago
160126 15:13:34 mysqld_safe Starting mysqld daemon with databases from /data/mysql
2016-01-26T07:13:34.169538Z 0 [Warning] Insecure configuration for –secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-01-26T07:13:34.169585Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.10-log) starting as process 5410 …
2016-01-26T07:13:34.169613Z 0 [ERROR] Can’t find error-message file ‘/usr/share/mysql/errmsg.sys’. Check error-message file location and ‘lc-messages-dir’ configuration directive.
2016-01-26T07:13:34.182760Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-01-26T07:13:34.182803Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-01-26T07:13:34.182811Z 0 [Note] InnoDB: Uses event mutexes
2016-01-26T07:13:34.182817Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-01-26T07:13:34.182823Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-26T07:13:34.182828Z 0 [Note] InnoDB: Using Linux native AIO
2016-01-26T07:13:34.183382Z 0 [Note] InnoDB: Number of pools: 1
2016-01-26T07:13:34.183535Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-01-26T07:13:34.190082Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2016-01-26T07:13:34.254450Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-01-26T07:13:34.260912Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-01-26T07:13:34.273707Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-26T07:13:34.300599Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-01-26T07:13:34.300674Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2016-01-26T07:13:34.361840Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2016-01-26T07:13:34.363446Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-01-26T07:13:34.363472Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-01-26T07:13:34.363909Z 0 [Note] InnoDB: Waiting for purge to start
2016-01-26T07:13:34.414108Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 59597689
2016-01-26T07:13:34.414317Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool
2016-01-26T07:13:34.415268Z 0 [Note] InnoDB: not started
2016-01-26T07:13:34.415510Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2016-01-26T07:13:34.415594Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160126 15:13:34
2016-01-26T07:13:34.416213Z 0 [ERROR] unknown variable ‘key_buffer=16M’
2016-01-26T07:13:34.416238Z 0 [ERROR] Aborting
2016-01-26T07:13:34.416252Z 0 [Note] Binlog end
2016-01-26T07:13:34.416369Z 0 [Note] Shutting down plugin ‘ngram’
2016-01-26T07:13:34.416386Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2016-01-26T07:13:34.416395Z 0 [Note] Shutting down plugin ‘partition’
2016-01-26T07:13:34.416403Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2016-01-26T07:13:34.416411Z 0 [Note] Shutting down plugin ‘MEMORY’
2016-01-26T07:13:34.416420Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2016-01-26T07:13:34.416428Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2016-01-26T07:13:34.416435Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2016-01-26T07:13:34.416442Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2016-01-26T07:13:34.416450Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2016-01-26T07:13:34.416457Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2016-01-26T07:13:34.416464Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2016-01-26T07:13:34.416471Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2016-01-26T07:13:34.416478Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2016-01-26T07:13:34.416486Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2016-01-26T07:13:34.416493Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2016-01-26T07:13:34.416500Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2016-01-26T07:13:34.416520Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2016-01-26T07:13:34.416529Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2016-01-26T07:13:34.416536Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2016-01-26T07:13:34.416544Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2016-01-26T07:13:34.416551Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2016-01-26T07:13:34.416558Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2016-01-26T07:13:34.416565Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2016-01-26T07:13:34.416572Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2016-01-26T07:13:34.416579Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2016-01-26T07:13:34.416586Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2016-01-26T07:13:34.416593Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2016-01-26T07:13:34.416600Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2016-01-26T07:13:34.416607Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2016-01-26T07:13:34.416614Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2016-01-26T07:13:34.416621Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2016-01-26T07:13:34.416628Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2016-01-26T07:13:34.416635Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2016-01-26T07:13:34.416642Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2016-01-26T07:13:34.416649Z 0 [Note] Shutting down plugin ‘InnoDB’
2016-01-26T07:13:34.416727Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-01-26T07:13:34.416829Z 0 [Note] InnoDB: Starting shutdown…
2016-01-26T07:13:34.517086Z 0 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/ib_buffer_pool
2016-01-26T07:13:34.517478Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160126 15:13:34
2016-01-26T07:13:36.251442Z 0 [Note] InnoDB: Shutdown completed; log sequence number 59597708
2016-01-26T07:13:36.252907Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2016-01-26T07:13:36.252920Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2016-01-26T07:13:36.252985Z 0 [Note] Shutting down plugin ‘MyISAM’
2016-01-26T07:13:36.253006Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2016-01-26T07:13:36.253011Z 0 [Note] Shutting down plugin ‘CSV’
2016-01-26T07:13:36.253017Z 0 [Note] Shutting down plugin ‘sha256_password’
2016-01-26T07:13:36.253020Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2016-01-26T07:13:36.253155Z 0 [Note] Shutting down plugin ‘binlog’
2016-01-26T07:13:36.253436Z 0 [Note]
160126 15:13:36 mysqld_safe mysqld from pid file /data/mysql/mysql.pid ended

oneinstack answered 8年 ago
是不是之前有安装mysql,读到其它配置文件,看看是否有/etc/mysql/ 目录,删掉 重启试试