Monthly Archives: May 2008
paramy – import dumps in a flash
Basically it’s a multithreaded client. Most servers these days have, or certainly should have, multiple disks and multiple CPU cores and reasonably fast storage. So using a single threaded client to insert those hundreds of thousands or millions of records doesn’t make that much sense today. There’s quite a lot of time to save. I’ve ran some tests on MySQL 5.1.24 and compared the results with those from the stock mysql client.
InnoDB plugin compression with benchmarks
InnoDB Plugin compression levels and their performance examined. Continue reading
The cost of table locking and index flushing in MySQL
This post may not apply to the large majority of applications out there, but I think it’s interesting enough. When doing sequential bulk inserts into MyISAM tables, you may think you’re getting rather good performance number wise. On low end … Continue reading