How to generate random data to test database performance?

Question

I created a test table in MySQL and would like to insert 10 million rows with randomly generated data. How to make this random generation process? Is there any predefined method in MySQL or is there a quick query we can build to do this job?

Thanks for any help.

Answer 1

In MySQL forge: RandomDataGenerator :

The random data generator allows you to create harsh size tables containing a harsh combination of columns filled with random data.

Answer 2

(ldg) script Tungsten, .

: http://code.google.com/p/tungsten-toolbox/downloads/list

: http://code.google.com/p/tungsten-toolbox/wiki/Large_Data_generator

Answer 3

:

call procedurename('DATABASE','TABLE',1000,'');  

1000 .

.

Answer 4

generatedata.com, . -, , GitHub .

databasetestdata.com. customizable generatedata.com, . ( ).

I would recommend downloading the data in CSV format and using it MySQL LOAD DATA INFILEto import data into your database.