msyql-order - Related information

• Mysql query performance problem, the speed of adding order by is almost 50 times slower.

  basic information: The datasheet has almost 10 million pieces of data, using the mycat sublibrary. the indexes in the data table are PRIMARY id AppName (AppName, custidStatus, channel) the table creation statement is as follows CREATE TABLE...

  Mysql mysql-optimized msyql-order

  Apr.13,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-1e4c5fb-44e9f.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-1e4c5fb-44e9f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?