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.

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.


there is large dataset on mysql website


Checkout https://launchpad.net/test-db/+download

it has about 6 tables i believe, suggest downloading the full archive.

The export data is around 167 MB.


Need Your Help

adding column to all tables in a mysql database (unknown table names)

mysql database primary-key

I need to add a primary key to a set of tables in a given database. I do not know how many tables there will be or what their specific names are. They will all be of the for datatable_##, where ## ...

Windows 10 Universal App File/Directory Access

c# wpf win-universal-app

I´m developing an app that is reading jpeg and pdf files from a configurable location on the filesystem.