How to create a lot of data for testing?

Question

MySQL

Good evening, at
once about the main thing...
I have 3 connected tables where there are 30 lines of the valid data.
I need to multiply this related data to eg 500,000 rows for testing purposes.
I do a greedy load and then insert insert - it goes out for 17 hours) Tell me, maybe there is a faster way.
Thank you.

Answer 1

It's best to use branchInsert and populate the database in an instant)

Answer 2

https://dev.mysql.com/doc/refman/5.5/en/optimizing...

Answer 3

Disable keys before multiple inserts.
After you turn it on.
dev.mysql.com/doc/refman/5.7/en/alter-table.html
And for data generation I recommend Faker

Answer 4

use the points described in the article, the link to which was given by un1t,
but I would like to add that you can move the data generation outside of php to the database level, this will also save time due to the lack of data exchange between php and the database. For example, move the generation to a stored procedure:

CREATE PROCEDURE `make_data`()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i < 500000 DO
    <тут INSERT запрос>
    SET i = i + 1;
END WHILE;  
END

and, accordingly, call it in the same phpMyAdmin:
well, do not forget about the multiple insert, it will also give a gain in time
PS in my opinion it is better to use ready-made utilities for generating data