Re: MyISAM web site logs 99% write

[DBA Lead]

Bulk inserts (using LOAD DATA INFILE) is probably the most efficient but you might end up hitting some issues since the table won't be empty to start with.

INSERT DELAYED is good if you are ready to loose some inserts in case of server restarts.

Here is what I'd recommend you to do (assuming you want to stick with MyISAM).
Use merge tables one per day and merge all these tables under a single merge table. Use LOAD DATA INFILE to load into the underlying (per day) tables and create a new one for the next day. This will save you a lot of administrative hassle in future.

If you are planning to read from the table then consider using concurrent_inserts=1 and also multi-value inserts by disabling key buffers before the operation and enabling them after the operation.

--------------------------------------------------------------------
Geeks Worldwide -- http://www.geeksww.com/keywords/tutorials/mysql/