-
1 votesanswersviews
MySQL:使用IN和ORDER BY时避免使用filesort
让's suppose I have the following table (let' s称之为 my_table ): CREATE TABLE `my_table` ( `table_id` int(10) unsigned NOT NULL auto_increment, `my_field` int(10) unsigned NOT NULL default '0' PRI... -
3 votesanswersviews
消除更新查询中的mysql文件排序
我有这样的表用于在mysql中实现队列: CREATE TABLE `queue` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `queue_name` varchar(255) NOT NULL, `inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE C... -
9 votesanswersviews
Mysql慢查询:INNER JOIN ORDER BY导致filesort
我正在尝试优化此查询: SELECT `posts`.* FROM `posts` INNER JOIN `posts_tags` ON `posts`.id = `posts_tags`.post_id WHERE (((`posts_tags`.tag_id = 1))) ORDER BY posts.created_at DESC; 表的大小是38k行... -
2 votesanswersviews
Mysql:按两列排序,使用filesort
订购两列时遇到问题 . EXPLAIN SELECT * FROM articles WHERE option <>0 AND deleted=0 ORDER BY date_added DESC, category_id DESC LIMIT 25 OFFSET 500 id select_type表类型possible_keys key key_len ref rows...