New answers tagged

1

Please be careful If you want to delete from only one table don't include all alias in the first line, only yhte table alias that is included will get deletions. DELETE t, p FROM topics AS t JOIN posts AS p ON t.id = p.topic_id WHERE t.id = 5599 ; instead use DELETE t FROM topics AS t JOIN posts AS p ON t.id = p.topic_id WHERE t.id = ...


0

If you have enabled innodb_file_per_table, the only way in Operative System can recover and demand to MySQL the used space is through OPTIMIZE TABLE command, you should run that command for you could see equally the data in both ways through .ibd file and using query.


1

MATCH is not the primary villain in the sluggishness; these are: OR Using LIKE / RLIKE pagination via OFFSET Most of the above prevent the use of any INDEX, hence the query must scan the entire table, thereby being slow for lots of reasons. Some can be solved in SQL; most require changes to the specifications for the query. Since the first thing the ...


Top 50 recent answers are included