产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请✓ 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[综合话题] 后台无法登陆，打开后提示您当前系统无法正常工作，请排查解决：No such file or directory MySQ...

aduydgd
铝牌会员
217.19 价值分

aduydgd 发表于 2021-07-23 23:04:50
后台无法登陆，打开后提示您当前系统无法正常工作，请排查解决：No such file or directory MySQL连接出错。

手动启动mysql57时出现下面的错误，请帮忙看看是什么原因引起的，谢谢！

确定环境没有动过，mysql没有修改过配置，突然出现这种情况！

mysql-5.7
[OK] mysql-5.7 is already installed.
Starting MySQL
... * The server quit without updating PID file (/home/usrdata/mysql-5.7/mysql.pid).
2021-07-23T03:19:24.349482Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-07-23T03:19:24.349509Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-07-23T03:19:24.349522Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-07-23T03:19:24.349535Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-07-23T03:19:24.349547Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-07-23T03:19:24.349559Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-07-23T03:19:24.349572Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-07-23T03:19:24.349584Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-07-23T03:19:24.349596Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-07-23T03:19:24.349621Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-07-23T03:19:24.349634Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-07-23T03:19:24.349646Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-07-23T03:19:24.349659Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-07-23T03:19:24.349672Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-07-23T03:19:24.349684Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-07-23T03:19:24.349715Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-07-23T03:19:24.349732Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-07-23T03:19:24.349750Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-07-23T03:19:24.349769Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-07-23T03:19:24.349785Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-07-23T03:19:24.349798Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-07-23T03:19:24.349810Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-07-23T03:19:24.349831Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-07-23T03:19:24.349843Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-07-23T03:19:24.349855Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-07-23T03:19:24.349867Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-07-23T03:19:24.349879Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-07-23T03:19:24.349891Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-07-23T03:19:24.349903Z 0 [Note] Shutting down plugin 'InnoDB'
2021-07-23T03:19:24.350184Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-07-23T03:19:24.350565Z 0 [Note] InnoDB: Starting shutdown...
2021-07-23T03:19:24.451198Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:19:24.451777Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210723 11:19:24
2021-07-23T03:19:26.066284Z 0 [Note] InnoDB: Shutdown completed; log sequence number 96865728
2021-07-23T03:19:26.069054Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-23T03:19:26.069086Z 0 [Note] Shutting down plugin 'MEMORY'
2021-07-23T03:19:26.069126Z 0 [Note] Shutting down plugin 'CSV'
2021-07-23T03:19:26.069140Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-23T03:19:26.069149Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-23T03:19:26.069387Z 0 [Note] Shutting down plugin 'binlog'
2021-07-23T03:19:26.069722Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete

2021-07-23T03:22:15.475427Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-23T03:22:15.475511Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-07-23T03:22:15.475580Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-07-23T03:22:15.475621Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.27-log) starting as process 19900 ...
2021-07-23T03:22:15.485896Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-07-23T03:22:15.485942Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-23T03:22:15.485955Z 0 [Note] InnoDB: Uses event mutexes
2021-07-23T03:22:15.485966Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-07-23T03:22:15.485977Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-23T03:22:15.485987Z 0 [Note] InnoDB: Using Linux native AIO
2021-07-23T03:22:15.487013Z 0 [Note] InnoDB: Number of pools: 1
2021-07-23T03:22:15.487198Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-07-23T03:22:15.496169Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-23T03:22:15.509894Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-23T03:22:15.514325Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-23T03:22:15.527508Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-23T03:22:15.561516Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-23T03:22:15.561740Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-23T03:22:15.935798Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-23T03:22:15.937720Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-07-23T03:22:15.937755Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-07-23T03:22:15.938718Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 96865728
2021-07-23T03:22:15.939290Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:22:15.939552Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-07-23T03:22:15.953767Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210723 11:22:15
2021-07-23T03:22:15.983246Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2021-07-23T03:22:15.983309Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-23T03:22:15.983512Z 0 [Note] IPv6 is available.
2021-07-23T03:22:15.983546Z 0 [Note] - '::' resolves to '::';
2021-07-23T03:22:15.983615Z 0 [Note] Server socket created on IP: '::'.
2021-07-23T03:22:15.983844Z 0 [ERROR] Could not write unix socket lock file /tmp/mysql-5.7.sock.lock errno 28.
2021-07-23T03:22:15.983870Z 0 [ERROR] Unable to setup unix socket lock file.
2021-07-23T03:22:15.983890Z 0 [ERROR] Aborting

2021-07-23T03:22:15.983917Z 0 [Note] Binlog end
2021-07-23T03:22:15.989723Z 0 [Note] Shutting down plugin 'ngram'
2021-07-23T03:22:15.989780Z 0 [Note] Shutting down plugin 'partition'
2021-07-23T03:22:15.989801Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-07-23T03:22:15.989821Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-07-23T03:22:15.989841Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-07-23T03:22:15.989948Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-07-23T03:22:15.989973Z 0 [Note] Shutting down plugin 'MyISAM'
2021-07-23T03:22:15.990041Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-07-23T03:22:15.990064Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-07-23T03:22:15.990078Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-07-23T03:22:15.990147Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-07-23T03:22:15.990174Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-07-23T03:22:15.990189Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-07-23T03:22:15.990204Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-07-23T03:22:15.990220Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-07-23T03:22:15.990238Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-07-23T03:22:15.990253Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-07-23T03:22:15.990267Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-07-23T03:22:15.990284Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-07-23T03:22:15.990300Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-07-23T03:22:15.990314Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-07-23T03:22:15.990330Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-07-23T03:22:15.990347Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-07-23T03:22:15.990362Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-07-23T03:22:15.990378Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-07-23T03:22:15.990394Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-07-23T03:22:15.990411Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-07-23T03:22:15.990425Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-07-23T03:22:15.990440Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-07-23T03:22:15.990457Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-07-23T03:22:15.990473Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-07-23T03:22:15.990487Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-07-23T03:22:15.990504Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-07-23T03:22:15.990520Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-07-23T03:22:15.990534Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-07-23T03:22:15.990549Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-07-23T03:22:15.990566Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-07-23T03:22:15.990597Z 0 [Note] Shutting down plugin 'InnoDB'
2021-07-23T03:22:15.991148Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-07-23T03:22:15.992070Z 0 [Note] InnoDB: Starting shutdown...
2021-07-23T03:22:16.092784Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:22:16.093278Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210723 11:22:16
2021-07-23T03:22:17.709010Z 0 [Note] InnoDB: Shutdown completed; log sequence number 96865747
2021-07-23T03:22:17.711710Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-23T03:22:17.711748Z 0 [Note] Shutting down plugin 'MEMORY'
2021-07-23T03:22:17.711762Z 0 [Note] Shutting down plugin 'CSV'
2021-07-23T03:22:17.711775Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-23T03:22:17.711791Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-23T03:22:17.712035Z 0 [Note] Shutting down plugin 'binlog'
2021-07-23T03:22:17.712369Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete

2021-07-23T03:24:17.291538Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-23T03:24:17.291635Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-07-23T03:24:17.291701Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-07-23T03:24:17.291772Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.27-log) starting as process 23028 ...
2021-07-23T03:24:17.304422Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-07-23T03:24:17.304495Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-23T03:24:17.304532Z 0 [Note] InnoDB: Uses event mutexes
2021-07-23T03:24:17.304544Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-07-23T03:24:17.304555Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-23T03:24:17.304566Z 0 [Note] InnoDB: Using Linux native AIO
2021-07-23T03:24:17.305587Z 0 [Note] InnoDB: Number of pools: 1
2021-07-23T03:24:17.305782Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-07-23T03:24:17.308853Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-23T03:24:17.324341Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-23T03:24:17.331436Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-23T03:24:17.344274Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-23T03:24:17.394227Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-23T03:24:17.394407Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-23T03:24:17.912833Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-23T03:24:17.917692Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-07-23T03:24:17.917760Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-07-23T03:24:17.925980Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 96865747
2021-07-23T03:24:17.926549Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:24:17.927319Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-07-23T03:24:17.933060Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210723 11:24:17
2021-07-23T03:24:17.973637Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2021-07-23T03:24:17.973698Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-23T03:24:17.973788Z 0 [Note] IPv6 is available.
2021-07-23T03:24:17.973807Z 0 [Note] - '::' resolves to '::';
2021-07-23T03:24:17.973854Z 0 [Note] Server socket created on IP: '::'.
2021-07-23T03:24:17.974068Z 0 [ERROR] Could not write unix socket lock file /tmp/mysql-5.7.sock.lock errno 28.
2021-07-23T03:24:17.974086Z 0 [ERROR] Unable to setup unix socket lock file.
2021-07-23T03:24:17.974133Z 0 [ERROR] Aborting

2021-07-23T03:24:17.974160Z 0 [Note] Binlog end
2021-07-23T03:24:17.979069Z 0 [Note] Shutting down plugin 'ngram'
2021-07-23T03:24:17.979147Z 0 [Note] Shutting down plugin 'partition'
2021-07-23T03:24:17.979168Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-07-23T03:24:17.979194Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-07-23T03:24:17.979208Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-07-23T03:24:17.979327Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-07-23T03:24:17.979357Z 0 [Note] Shutting down plugin 'MyISAM'
2021-07-23T03:24:17.979414Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-07-23T03:24:17.979443Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-07-23T03:24:17.979458Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-07-23T03:24:17.979472Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-07-23T03:24:17.979487Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-07-23T03:24:17.979502Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-07-23T03:24:17.979517Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-07-23T03:24:17.979533Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-07-23T03:24:17.979551Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-07-23T03:24:17.979566Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-07-23T03:24:17.979590Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-07-23T03:24:17.979606Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-07-23T03:24:17.979624Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-07-23T03:24:17.979673Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-07-23T03:24:17.979692Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-07-23T03:24:17.979710Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-07-23T03:24:17.979728Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-07-23T03:24:17.979743Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-07-23T03:24:17.979760Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-07-23T03:24:17.979776Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-07-23T03:24:17.979793Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-07-23T03:24:17.979811Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-07-23T03:24:17.979827Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-07-23T03:24:17.979844Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-07-23T03:24:17.979861Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-07-23T03:24:17.979877Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-07-23T03:24:17.979893Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-07-23T03:24:17.979910Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-07-23T03:24:17.979927Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-07-23T03:24:17.979944Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-07-23T03:24:17.979961Z 0 [Note] Shutting down plugin 'InnoDB'
2021-07-23T03:24:17.980293Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-07-23T03:24:17.980704Z 0 [Note] InnoDB: Starting shutdown...
2021-07-23T03:24:18.081184Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:24:18.081832Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210723 11:24:18
2021-07-23T03:24:19.599321Z 0 [Note] InnoDB: Shutdown completed; log sequence number 96865766
2021-07-23T03:24:19.601816Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-23T03:24:19.601843Z 0 [Note] Shutting down plugin 'MEMORY'
2021-07-23T03:24:19.601858Z 0 [Note] Shutting down plugin 'CSV'
2021-07-23T03:24:19.601869Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-23T03:24:19.601877Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-23T03:24:19.602084Z 0 [Note] Shutting down plugin 'binlog'
2021-07-23T03:24:19.602493Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete

2021-07-23T03:24:34.211047Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-23T03:24:34.211189Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-07-23T03:24:34.211273Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-07-23T03:24:34.211356Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.27-log) starting as process 24181 ...
2021-07-23T03:24:34.224759Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-07-23T03:24:34.224831Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-23T03:24:34.224844Z 0 [Note] InnoDB: Uses event mutexes
2021-07-23T03:24:34.224865Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-07-23T03:24:34.224887Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-23T03:24:34.224911Z 0 [Note] InnoDB: Using Linux native AIO
2021-07-23T03:24:34.226033Z 0 [Note] InnoDB: Number of pools: 1
2021-07-23T03:24:34.226301Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-07-23T03:24:34.229516Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-23T03:24:34.243759Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-23T03:24:34.247478Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-23T03:24:34.260548Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-23T03:24:34.293268Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-23T03:24:34.293477Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-23T03:24:34.661233Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-23T03:24:34.662908Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-07-23T03:24:34.662938Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-07-23T03:24:34.663988Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 96865766
2021-07-23T03:24:34.664317Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:24:34.664877Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-07-23T03:24:34.670065Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210723 11:24:34
2021-07-23T03:24:34.693983Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2021-07-23T03:24:34.694050Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-23T03:24:34.694228Z 0 [Note] IPv6 is available.
2021-07-23T03:24:34.694253Z 0 [Note] - '::' resolves to '::';
2021-07-23T03:24:34.694299Z 0 [Note] Server socket created on IP: '::'.
2021-07-23T03:24:34.694501Z 0 [ERROR] Could not write unix socket lock file /tmp/mysql-5.7.sock.lock errno 28.
2021-07-23T03:24:34.694516Z 0 [ERROR] Unable to setup unix socket lock file.
2021-07-23T03:24:34.694526Z 0 [ERROR] Aborting

2021-07-23T03:24:34.694545Z 0 [Note] Binlog end
2021-07-23T03:24:34.698591Z 0 [Note] Shutting down plugin 'ngram'
2021-07-23T03:24:34.698680Z 0 [Note] Shutting down plugin 'partition'
2021-07-23T03:24:34.698695Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-07-23T03:24:34.698705Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-07-23T03:24:34.698713Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-07-23T03:24:34.698786Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-07-23T03:24:34.698795Z 0 [Note] Shutting down plugin 'MyISAM'
2021-07-23T03:24:34.698821Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-07-23T03:24:34.698831Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-07-23T03:24:34.698839Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-07-23T03:24:34.698846Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-07-23T03:24:34.698853Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-07-23T03:24:34.698860Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-07-23T03:24:34.698867Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-07-23T03:24:34.698874Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-07-23T03:24:34.698881Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-07-23T03:24:34.698888Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-07-23T03:24:34.698895Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-07-23T03:24:34.698902Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-07-23T03:24:34.698909Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-07-23T03:24:34.698916Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-07-23T03:24:34.698923Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-07-23T03:24:34.698930Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-07-23T03:24:34.698936Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-07-23T03:24:34.698943Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-07-23T03:24:34.698950Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-07-23T03:24:34.698958Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-07-23T03:24:34.698977Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-07-23T03:24:34.698994Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-07-23T03:24:34.699008Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-07-23T03:24:34.699024Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-07-23T03:24:34.699040Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-07-23T03:24:34.699051Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-07-23T03:24:34.699087Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-07-23T03:24:34.699097Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-07-23T03:24:34.699105Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-07-23T03:24:34.699145Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-07-23T03:24:34.699157Z 0 [Note] Shutting down plugin 'InnoDB'
2021-07-23T03:24:34.699309Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-07-23T03:24:34.699542Z 0 [Note] InnoDB: Starting shutdown...
2021-07-23T03:24:34.800070Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool
2021-07-23T03:24:34.800790Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210723 11:24:34
2021-07-23T03:24:36.417518Z 0 [Note] InnoDB: Shutdown completed; log sequence number 96865785
2021-07-23T03:24:36.421809Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-23T03:24:36.421872Z 0 [Note] Shutting down plugin 'MEMORY'
2021-07-23T03:24:36.421889Z 0 [Note] Shutting down plugin 'CSV'
2021-07-23T03:24:36.421901Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-23T03:24:36.421915Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-23T03:24:36.422193Z 0 [Note] Shutting down plugin 'binlog'
2021-07-23T03:24:36.422578Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete

[Error] mysql-5.7 start failed.
  点赞，加油！ (0分)
2021-07-23 23:04:50 1

AMH铁粉，诸多面板转移过来的！

amysql
创始人
16530.81 价值分

执行：
rm -f /tmp/mysql-5.7.sock /tmp/mysql-5.7.sock.lock
amh mysql-5.7 start
启动看。

mysql-5.7意外停止的话，排查原因要看/var/log/messages
大多是服务器内存用满，系统kill掉了mysql进程。
  支持 (0分)  反对 (0分)
回复  2021-07-23 23:41:47 2

AMH面板 - 好用高效低占用、安全可靠极稳定

aduydgd
铝牌会员
217.19 价值分

发完帖子后过了不久，自己启动成功了，不知道什么原因引起的，现在没有问题了
  支持 (0分)  反对 (0分)
回复  2021-07-25 14:29:17 3

magento
铝牌会员
421.26 价值分

引用:
aduydgd 发表于 2021-07-25 14:29:17
发完帖子后过了不久，自己启动成功了，不知道什么原因引起的，现在没有问题了


病久成医的表示....80%是内存不足，19%是硬盘不够 ，1%其它
  支持 (0分)  反对 (0分)
回复  2021-07-25 23:39:47 4

AMH棒棒哒

aduydgd
铝牌会员
217.19 价值分

哈哈，，，内存还行，16G的，硬盘还有几百G，，，其他就不知道了，反正现在可以用了，不管了
  支持 (0分)  反对 (0分)
回复  2021-07-26 09:58:39 5
 1  (总1页)
AMH社区列表
用户服务中心