39

记录一次MySQL两千万数据的大表优化解决过程，提供三种解决方案

 5 years ago
source link: http://database.51cto.com/art/201902/592522.htm
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
使用阿里云rds for MySQL数据库(就是MySQL5.6版本)，有个用户上网记录表6个月的数据量近2000万，保留最近一年的数据量达到4000万，查询速度极慢，日常卡死。严重影响业务。我尝试解决该问题，so，有个这个日志。

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK