>>>>> "Jon" == Jon Drukman <jsd@stripped> writes:
Jon> I've read everything I can about speeding up data insertion, but I still
Jon> can't get it to an acceptable speed.
Jon> My table is simple:
Jon> CREATE TABLE pageview (
Jon> url char(128) DEFAULT '' NOT NULL,
Jon> count mediumint(9) DEFAULT '0' NOT NULL,
Jon> date date DEFAULT '0000-00-00' NOT NULL,
Jon> site char(32) DEFAULT '' NOT NULL,
Jon> KEY urlidx (url),
Jon> KEY dateidx (date)
Jon> I'm using it store web traffic, of course. For each day, I store every URL
Jon> requested and the number of requests. Importing 30k rows when the table
Jon> already has somewhere around 500k rows is incredibly slow - 40 minutes! I
Jon> load the data using the LOAD DATA INFILE command as recommended in the manual.
Jon> Dropping the indexes and recreating them after import is not a good
Jon> solution as it takes about an hour to rebuild each index.
Jon> Selects are actually quite quick - it's just importing. Is there any way
Jon> to speed it up?
Try increasing the size of the key_buffer variable in mysqld.