select count(*) as repetitions,file_key,tag from tags group by file_key,tag having repetitions >1;
这个sql语句执行报错
ERROR 2013 (HY000): Lost connection to MySQL server during query
select count(*) as repetitions,file_key,tag from tags group by file_key,tag having repetitions >1;
这个sql语句执行报错
ERROR 2013 (HY000): Lost connection to MySQL server during query
你这是数据量太大超时了吧
[27535.232ms] [rows:2] DELETE FROM tags
WHERE tag = ‘Sunny’ AND file_key = ‘aaa’
单条数据删除也很慢
where条件上有索引么,没有索引也会很慢吧
有tag的索引,没有联合索引
嗯嗯,看到官方回复的了。
目前问题有解决吗?
建议在插入时就去重,因为删除的代价比插入时查询的代价要大
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。