The problem of metadata lock caused by the number of database connections occupied by Discuz

  • there are always several times in 1-2 months on average, when the number of database connections soars instantly, and then it is described like this. I need to count the kill processes manually, and then I can keep it for another month or so. May I ask what exactly went wrong
  • Environment configuration: php 5.6mysql 5.6

clipboard.png

Php
Feb.26,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b22545-2b60f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b22545-2b60f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?