Insert into database

CREATE TABLE v (v INT);

INSERT INTO v VALUES (1);

INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;
INSERT INTO v SELECT (SELECT MAX(v) FROM V) + v FROM v;

DELETE FROM v WHERE v > 300;

CREATE TABLE myProb (x INT, y INT, z INT);

INSERT INTO myProb (x, y, z) SELECT v1.v, v2.v, v3.v FROM v v1, v v2, v v3;

The idea is to create all variables possible. Although it seems to work and inserts 27000000 records the acuall datafile is only 3Kb, however I have a ibdata1 file which is 2Gb, how can I commit the data?