最近碰到数据库性能问题,去看日志提示: [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内存不够用,需要调大呢 ? |
合作电话:010-64087828
社区邮箱:greatsql@greatdb.com