最近将一MySQL数据库的系统变量log_output从file调整为table后,偶尔会收到告警邮件,告警邮件内容为:
Failed to write to mysql.slow_log 。
Fixed in 8.0.17.
Logging to the mysql.slow_log system table could fail when values
were to large for table columns. Now logging proceeds on a
best-effort basis, writing what information can be provided.
Otherwise, the row is discarded and a message is written to the error log.
这个Bug直到MySQL 8.0.17才被Fix掉,在这之前从未碰到过,第一次遇到也颇感意外,遇到了就记录一下!
参考资料:
https://bugs.mysql.com/bug.php?id=37132
Original: https://www.cnblogs.com/kerrycode/p/15664958.html
Author: 潇湘隐者
Title: Failed to write to mysql.slow_log
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/507970/
转载文章受原作者版权保护。转载请注明原作者出处!