sample database for mysql fulltext

Question

I need a sample database dump for testing the performance of mysql fulltext search feature. I need around 1-10 million rows.

Would this be available anywhere? If not, what is the simplest way of generating this database.

Answer 1

I also tested various full text solutions. See Full Text Search Throwdown.

I used the StackOverflow data dump to test. https://blog.stackoverflow.com/2014/01/stack-exchange-cc-data-now-hosted-by-the-internet-archive/

It's in XML format, but it wasn't too difficult to write a script to turn the XML into SQL to load it into a database for testing.

Answer 2

You can download some StackOverflow real data. Check the following link for more details.

You can check the following link for more details about how to restore it.