Hey all,

 

Does anyone know of any software or script that can assist in generating lots of rows for MySQL tables ?

Could use it to do a couple of tests.

 

Thanks.

 

Update 1: I've found this one (EMS Data Generator for MySQL), could use a free utility though.

Update 2: I've found a free (beta) utility called spawner. Not too fancy but generates useful sqls ... I'm happy now . I'll test it these days and maybe come back with an update.

A quick review:

 

- utility does the job ... usually you don't get it from the first attempt;

- could use some polishing (for example there's no way you can define a field as NULL or '');

- has a limited number of words (around 200) in it's dictionary (some sort of lorem ipsum) so the word generator is not appropriate to generate user names;

- has ability to save table schemas (list of field definitions);

- it's very fast (can generate 10.000 rows in 2-3 seconds);

are you talking about a MySQL administrator? like Navicat and SQLyog?

are you talking about a MySQL administrator? like Navicat and SQLyog?

 

Not an administrator, a random data generator needed to test possible query performance issues.

 

The idea is pretty simple ... when you create a website you insert some test data.

Everything may seem ok with those 10-20 rows ... but there's a different story when you have 2 million rows. In order to optimize possible slow queries you need to have that data.

 

That utility generates SQL insert statements (or CSV or inserts data directly into a database) based on rules that you define.