29
MySql 日常指导，及大表优化思路
source link: https://juejin.im/post/5b7d52afe51d453885030b91
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.
当MySQL单表记录数过大时，增删改查性能都会急剧下降 单表优化 除非单表数据未来会一直不断上涨，否则不要一开始就考虑拆分，拆分会带来逻辑、部署、运维的各种复杂度，一般以整型值为主的表在千万级以下，字符串为主的表在五百万以下是没有太大问题的。 而事实上很多时
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK