May 24, 2012

Post: How to load large files safely into InnoDB with LOAD DATA INFILE

found a way to load the single file in chunks as though it were many small files, which avoided splitting the file and let us load with… file mentioned in LOAD DATA INFILE is /tmp/my-fifo, not infile.txt! After I was done, I ran a quick Perl script on the vmstat and mysqladmin log files

Post: Quick comparison of MyISAM, Infobright, and MonetDB

and told me the number of columns mismatched. I found reference to this on the mailing list, and skipped that. I used LOAD DATA INFILE…example, it seems quite nicely put together, and it’s not at all hard to learn. It … files to hold the data in-memory. If this is true, it explains why I couldn’t load

Post: MySQL Users Conference - Innodb

…them done by Innodb users. I found these items forth interest Innodb … pages were compressed to for data and for various indexes. How many “fragmented… I do not yet know answer for – for example will LOAD DATA INFILE be …also rather interesting how is sort file structured for building the indexes – …