高手帮忙分析下MYSQL日志,经常宕机重启服务器就好了
有个网站 隔个两三天MYSQL就出错 访问不了。我每次都要盯着重启服务器才能恢复,但是过两天又出错了,本人菜鸟,我把日志错误给大神看下,看看是哪里的问题呀?
2023-01-01 22:02:29 31897 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 3145818592
2023-01-01 22:02:30 31897 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 78445, file name mysql-bin.000154
2023-01-01 22:02:31 31897 [Note] InnoDB: 128 rollback segment(s) are active.
2023-01-01 22:02:31 31897 [Note] InnoDB: Waiting for purge to start
2023-01-01 22:02:31 31897 [Note] InnoDB: 5.6.50 started; log sequence number 3145818592
2023-01-01 22:02:31 31897 [Note] Recovering after a crash using mysql-bin
2023-01-01 22:02:31 31897 [Note] Starting crash recovery...
2023-01-01 22:02:31 31897 [Note] Crash recovery finished.
2023-01-01 22:02:31 31897 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2023-01-01 22:02:31 31897 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2023-01-01 22:02:31 31897 [Note] Server hostname (bind-address): '*'; port: 3306
2023-01-01 22:02:31 31897 [Note] IPv6 is available.
2023-01-01 22:02:31 31897 [Note] - '::' resolves to '::';
2023-01-01 22:02:31 31897 [Note] Server socket created on IP: '::'.
2023-01-01 22:02:32 31897 [Note] Event Scheduler: Loaded 0 events
2023-01-01 22:02:32 31897 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.50-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-01 22:04:07 32313 [Note] Plugin 'FEDERATED' is disabled.
2023-01-01 22:04:07 32313 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-01-01 22:04:07 32313 [Note] InnoDB: The InnoDB memory heap is disabled
2023-01-01 22:04:07 32313 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-01-01 22:04:07 32313 [Note] InnoDB: Memory barrier is not used
2023-01-01 22:04:07 32313 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-01 22:04:07 32313 [Note] InnoDB: Using Linux native AIO
2023-01-01 22:04:07 32313 [Note] InnoDB: Using CPU crc32 instructions
2023-01-01 22:04:07 32313 [Note] InnoDB: Initializing buffer pool, size = 384.0M
InnoDB: mmap(412090368 bytes) failed; errno 12
2023-01-01 22:04:07 32313 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2023-01-01 22:04:07 32313 [ERROR] Plugin 'InnoDB' init function returned error.
2023-01-01 22:04:07 32313 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-01-01 22:04:07 32313 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-01-01 22:04:07 32313 [ERROR] Aborting
2023-01-01 22:04:07 32313 [Note] Binlog end
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'partition'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_METRICS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_TRX'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'BLACKHOLE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'ARCHIVE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'MRG_MYISAM'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'MyISAM'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'MEMORY'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'CSV'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'sha256_password'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'mysql_old_password'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'mysql_native_password'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'binlog'
2023-01-01 22:04:07 32313 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
昨天就是晚上10.04分停止的,我早上七点才看到重启服务器。 WP程序
2023-01-01 22:02:29 31897 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 3145818592
2023-01-01 22:02:30 31897 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 78445, file name mysql-bin.000154
2023-01-01 22:02:31 31897 [Note] InnoDB: 128 rollback segment(s) are active.
2023-01-01 22:02:31 31897 [Note] InnoDB: Waiting for purge to start
2023-01-01 22:02:31 31897 [Note] InnoDB: 5.6.50 started; log sequence number 3145818592
2023-01-01 22:02:31 31897 [Note] Recovering after a crash using mysql-bin
2023-01-01 22:02:31 31897 [Note] Starting crash recovery...
2023-01-01 22:02:31 31897 [Note] Crash recovery finished.
2023-01-01 22:02:31 31897 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2023-01-01 22:02:31 31897 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2023-01-01 22:02:31 31897 [Note] Server hostname (bind-address): '*'; port: 3306
2023-01-01 22:02:31 31897 [Note] IPv6 is available.
2023-01-01 22:02:31 31897 [Note] - '::' resolves to '::';
2023-01-01 22:02:31 31897 [Note] Server socket created on IP: '::'.
2023-01-01 22:02:32 31897 [Note] Event Scheduler: Loaded 0 events
2023-01-01 22:02:32 31897 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.50-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-01 22:04:07 32313 [Note] Plugin 'FEDERATED' is disabled.
2023-01-01 22:04:07 32313 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-01-01 22:04:07 32313 [Note] InnoDB: The InnoDB memory heap is disabled
2023-01-01 22:04:07 32313 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-01-01 22:04:07 32313 [Note] InnoDB: Memory barrier is not used
2023-01-01 22:04:07 32313 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-01 22:04:07 32313 [Note] InnoDB: Using Linux native AIO
2023-01-01 22:04:07 32313 [Note] InnoDB: Using CPU crc32 instructions
2023-01-01 22:04:07 32313 [Note] InnoDB: Initializing buffer pool, size = 384.0M
InnoDB: mmap(412090368 bytes) failed; errno 12
2023-01-01 22:04:07 32313 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2023-01-01 22:04:07 32313 [ERROR] Plugin 'InnoDB' init function returned error.
2023-01-01 22:04:07 32313 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-01-01 22:04:07 32313 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-01-01 22:04:07 32313 [ERROR] Aborting
2023-01-01 22:04:07 32313 [Note] Binlog end
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'partition'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_METRICS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_CMP'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'INNODB_TRX'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'BLACKHOLE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'ARCHIVE'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'MRG_MYISAM'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'MyISAM'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'MEMORY'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'CSV'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'sha256_password'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'mysql_old_password'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'mysql_native_password'
2023-01-01 22:04:07 32313 [Note] Shutting down plugin 'binlog'
2023-01-01 22:04:07 32313 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
昨天就是晚上10.04分停止的,我早上七点才看到重启服务器。 WP程序