テスト用のでかいDBを作成【ラージサイズ】

5GBのデータベースが数秒で作れます

CREATE TABLE IF NOT EXISTS large_text_table ( large_text LONGTEXT );
START TRANSACTION;
INSERT INTO large_text_table (large_text) VALUES (REPEAT('A', @@max_allowed_packet));
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
INSERT INTO large_text_table(large_text) SELECT large_text FROM large_text_table;
COMMIT;

削除

DROP TABLE large_text_table;