我在哪里可以获得用于练习 MySQL 查询优化的大型示例数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12180902/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Where can I get a large sample database for practising MySQL query optimization
提问by SexyBeast
Can anyone give a reference to a substantially large sample database which I can import into MySQL to test and learn optimization and benchmarking?
The database should have at least 6-8 tables with lots of foreign keys in between them, i.e a complete database. The MySQLemployeesdatabase looked promising, but the download page has 3 download links, clicking on any of which opens a page in a browser with a god-awful amount of binary data, dont know what to do with that.
任何人都可以参考一个相当大的示例数据库，我可以将其导入 MySQL 以测试和学习优化和基准测试吗？
数据库应该至少有 6-8 个表，它们之间有很多外键，即一个完整的数据库。该MySQLemployees数据库看起来前途无量，但下载页面有3个下载链接，点击其中的任何一个与二进制数据的神可怕的量浏览器中打开一个页面，不知道该怎么做这一点。
采纳答案by tadman
回答by amitchhajer
there is large dataset on mysql website
mysql 网站上有大数据集
回答by s1lntz
Checkout https://launchpad.net/test-db/+download
结帐https://launchpad.net/test-db/+download
it has about 6 tables i believe, suggest downloading the full archive.
我相信它有大约 6 个表，建议下载完整的存档。
The export data is around 167 MB.
导出数据约为 167 MB。
