optimizes - Related information

• Mysql 1.5 times the amount of data leads to more than 20 times execution time?

  the following code implements tagging the data. After a carPlate appears (set to 2 for the first time), the mark is invalid within 1 hour (set to 1), the first one for more than 1 hour is set to 2, and so on. the main problem is that I have several ta...

  Mysql optimizes big-data

  Jun.21,2022
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-1b3854a-2b46b.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-1b3854a-2b46b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?