Where can I get a large sample database for practising MySQL query optimization
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.
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.
there is large dataset on mysql website
it has about 6 tables i believe, suggest downloading the full archive.
The export data is around 167 MB.