高手帮忙分析下MYSQL日志，经常宕机重启服务器就好了

哥斯拉 · 发表于 2023-1-2 09:52:39

马上注册，免费下载更多dz插件网资源。

您需要登录才可以下载或查看，没有账号？立即注册

×

有个网站隔个两三天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程序

©dz插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
本站信息来自网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
如有侵权请邮件与我们联系处理:discuz-x@qq.com（手机随时接收邮件）并出示相关证明以便删除。敬请谅解！

IT618发布 · 发表于 2023-1-2 09:53:01

内存太小了？

独家记忆 · 发表于 2023-1-2 09:53:19

不知道啊

独家记忆 · 发表于 2023-1-2 09:54:12

https://blog.csdn.net/xianglingchuan/article/details/72725346
这个跟你差不多的，参考一下

Crystαl · 发表于 2023-1-2 09:54:42

云服务器后台上有图表看啊

婷姐 · 发表于 2023-1-2 09:55:27

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

my.cnf文件修改：
[mysqld]
#innodb缓冲池大小
innodb_buffer_pool_size = 1024M