GreatSQL社区

搜索

[已解决] 如何判断mysql的innodb buffer pool内存不够用,需要扩大这个?

560 5 2023-12-11 12:09
最近碰到数据库性能问题,去看日志提示:


[Warning] InnoDB: Difficult to find free blocks in the buffer pool (339 search iterations)! 0 failed attempts to flush a page! Consider increasing the buffer pool size. It is also possible that in your Unix version fsync is very slow, or completely frozen inside the OS kernel. Then upgrading to a newer version of your operating system may help. Look at the number of fsyncs in diagnostic info below. Pending flushes (fsync) log: 0; buffer pool: 0. 257160371 OS file reads, 26498491 OS file writes, 2094366 OS fsyncs. Starting InnoDB Monitor to print further diagnostics to the standard output.

发现 buffer pool内存不够用 了,调大了内存问题解决,但是如何通过监控或者什么参数可以判断buffer pool内存不够用,需要调大呢 ?


全部回复(5)
fengzhencai

4

主题

0

博客

10

贡献

新手上路

Rank: 1

积分
16

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-5-20 03:53 , Processed in 0.020397 second(s), 14 queries , Redis On.
快速回复 返回顶部 返回列表