How hard is it to write data until the disk fills up? Creating more than 4GB of data isn’t that difficult, so shouldn’t the database be able to work with that much data out of the box?
How hard is it to write data to a table in-order when using
INSERT INTO SELECT?
mysql> delete from […] where timestamp < […];
Query OK, 35759328 rows affected (57 min 13.77 sec)