本文内容来自YashanDB官网,原文内容请见https://yashandb.com/newsinfo/7863040.html?templateId=1718516
问题现象
YashanDB run.log中有slow log queue is full信息,类似如下:
2024-12-12 16:35:56.019 348759 INFO: slow log queue is full
2024-12-12 16:35:56.019 348762 INFO: slow log queue is full
2024-12-12 16:35:56.019 348760 INFO: slow log queue is full
2024-12-12 16:35:56.019 348749 INFO: slow log queue is full
2024-12-12 16:35:56.020 348755 INFO: slow log queue is full
2024-12-12 16:35:56.020 348761 INFO: slow log queue is full
问题的风险及影响
对业务无影响,可以忽略
问题发生原因
慢SQL在产生时会由YashanDB内部队列缓存,这个队列满的时候就会报slow log queue is full异常。
此队列的大小由参数_SLOW_LOG_QUEUE_SIZE控制,默认值为256。