MySQL is Dum

Eric Hodel | Sun, 26 Feb 2006 00:39:00 GMT

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?

UPDATE: Seriously! 

<samp>mysql&gt; delete from [...] where timestamp < [...];
Query OK, 35759328 rows affected (57 min 13.77 sec)</samp>

Posted in