Hi, I have a problem importing data from Flat Files into either MySQL or PostgreSQL databases. Importing some 6 million lines takes as few as 60 seconds on a fast Opteron server, and will not finished overnight on my 1.5Ghz Centrino Laptop. Top shows the Laptop is stuck in 9x% Wait. I am using the bulk load mechanism of both RDBMS (load data or copy from file). I tried disabling the db logfiles, used ext2 instead of ext3 for their data, to no avail. System is sarge, Kernel is a 2.6.8.1, PostgreSQL 7.4.5 and MySQL 4.0.12, noflushd is disabled, DMA is on for hda. Is there any laptop-specific setting done in debian which could cause the slowdown ? Yours, Steffen dev/hda: multcount = 0 (off) IO_support = 0 (default 16-bit) unmaskirq = 0 (off) using_dma = 1 (on) keepsettings = 0 (off) readonly = 0 (off) readahead = 256 (on) geometry = 65535/16/63, sectors = 117210240, start = 0 -- Dr. Steffen Neumann Phone: +49(0)39482 5 736 http://pdw.bic-gh.de/ Fax: +49(0)39482 5 xxx IPK Gatersleben - Correnstr. 3 - 06466 Gatersleben
Attachment:
signature.asc
Description: This is a digitally signed message part