Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I get a large sample database for practising MySQL query optimization [closed]

Tags:

sql

mysql

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 MySQL employees database 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.

like image 960
SexyBeast Avatar asked Aug 29 '12 14:08

SexyBeast


2 Answers

StackOverflow itself publishes a database that could be used for this kind of testing. It's a fast download using BitTorrent since there's a lot of seeders.

like image 177
tadman Avatar answered Oct 22 '22 16:10

tadman


there is large dataset on mysql website

like image 16
amitchhajer Avatar answered Oct 22 '22 14:10

amitchhajer