The mysql service is good, why did it collapse?

Mar.07,2021

/ var/log/mysqld.log : Read-only file system, either the disk is full or the disk is dead


look at the log, there is this Error message: InnoDB: File (unknown): 'flush' returned OS error 105. Cannot continue operation
check the official website of mysql. There should be not enough memory: https://forums.mysql.com/read.

.
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-1b3059a-4d3a7.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-1b3059a-4d3a7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?