|
本帖最后由 wrh 于 2025-8-13 09:05 编辑 数据库版本：Server version: 8.0.32-26 GreatSQL (GPL), Release 26 我这边查询Innodb_buffer_pool_wait_free和Innodb_log_waits 参数信息如下： mysql> SELECT * FROM performance_schema.global_status WHERE variable_name = 'Innodb_buffer_pool_wait_free'; +------------------------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +------------------------------+----------------+ | Innodb_buffer_pool_wait_free | 7560827 | +------------------------------+----------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM performance_schema.global_status WHERE variable_name = 'Innodb_log_waits'; +------------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +------------------+----------------+ | Innodb_log_waits | 39 | +------------------+----------------+ 1 row in set (0.00 sec) 我的现有数据库参数中的值如下： mysql> show variables like 'innodb_buffer_pool_size'; +-------------------------+-------------+ | Variable_name | Value | +-------------------------+-------------+ | innodb_buffer_pool_size | 21474836480 | +-------------------------+-------------+ 1 row in set (0.00 sec) mysql> show variables like 'innodb_log_buffer_size'; +------------------------+----------+ | Variable_name | Value | +------------------------+----------+ | innodb_log_buffer_size | 16777216 | +------------------------+----------+ 1 row in set (0.00 sec) 内存如下： total used free shared buff/cache available Mem: 125Gi 76Gi 822Mi 35Gi 48Gi 11Gi Swap: 4.0Gi 4.0Gi 0B 发现这2个参数有值，按照文档监控中说的，这几个有值，需要增加InnoDB Buffer Pool和InnoDB Log Buffer。 1、有没有一个标准，说多少值需要加多少的Buffer?这个能计算的出来吗？ 2、然后mysql.log日志中有这些告警： 2025-08-11T19:27:55.652390Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. 2025-08-11T21:58:19.061530Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. 2025-08-11T22:31:13.634393Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. 是因为上面的Innodb_log_waits 这个有值的原因吗？ |
|
|
yejr
2025-8-13 11:09:25
| |
|
|
wrh
2025-8-13 11:21:20
| |
|
|
wrh
2025-8-13 11:29:34
| |
|
|
yejr
2025-8-13 12:12:03
| |
|
|
wrh
2025-8-13 12:31:27
| |
|
|
yejr
2025-8-13 12:36:35
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
