54

MySQL 快速创建千万级测试数据

 5 years ago
source link: https://juejin.im/post/5ce372c36fb9a07ef63fb191
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.
neoserver,ios ssh client
备注： 此文章的数据量在100W，如果想要千万级，调大数量即可,但是不要大量使用rand() 或者uuid() 会导致性能下降 背景 在进行查询操作的性能测试或者sql优化时，我们经常需要在线下环境构建大量的基础数据供我们测试，模拟线上的真实环境。 废话，总不

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK