…to show how to count the number of unique words, an how many times those words appear in…to over 3 million “words” by duplicating the entire set multiple times. mysql> load data infile…ON DUPLICATE KEY UPDATE `word`=VALUES(`word`), `md5… you to use data flow semantics on any cluster with respect to…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… to think about how to avoid enormous tables that are hard to maintain…use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL…to the master with LOAD DATA INFILE, which kind of emulates row-based replication in a way. When you’re updating…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…used LOAD DATA INFILE instead (MonetDB’s version of that is COPY INTO). This is the only way to get data…LOAD DATA INFILE in Infobright isn’t what it seems to be. Otherwise, Infobright behaved about as I expected it to; it seemed pretty normal to a MySQL…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… to for data and for various indexes. How many “fragmented” pages do we have in…know answer for – for example will LOAD DATA INFILE be optimized same way as for…used. There are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data…LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not for online transactions processing. Compression in…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…loaded with the data used in the previous Shard-Query blog post. The data in…data hand updated…data from 1988 to 2010′; mysql> use ontime1; Database changed mysql…use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…to know it had to be done fore replication to work right in MySQL before 5.1. In MySQL…using replication ? The most general one is to use: SELECT * FROM tbl1 INFO OUTFILE ‘/tmp/tbl1.txt’; LOAD DATA INFILE…
