mysql fun

gistfile1.txt

17:52 <@jhannah> gak. load ground to a halt at 15.8M rows
17:53 <@jhannah> index size is twice the data size, so i'm thinking load then create indexes as next 
                 attempt
17:54 <@jhannah> apparently load velocity is some sort of reverse exponential curve
17:54 <@jhannah> over a few millions rows
17:55 <@jhannah> | table_name                 | table_rows | data_length | index_length | Size(MB) |
17:55 <@jhannah> +----------------------------+------------+-------------+--------------+----------+
17:55 <@jhannah> | video_stats                |   15822097 |  1758461952 |   3214934016 |  4743.00 | 
17:57 <@jhannah> oh shit -- amor disk is full
17:58 <@jhannah> Filesystem            Size  Used Avail Use% Mounted on
17:58 <@jhannah> /dev/xvda              47G   46G     0 100% /