Re: System Wait kill MySQL/PostgreSQL performance ?
Steffen Neumann <[EMAIL PROTECTED]> - Fri, Sep 10, 2004: > 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. You might want to benchmark your disks (Opteron server & laptop) with hdparm -t and -T. Regards, -- Loïc Minier <[EMAIL PROTECTED]>
System Wait kill MySQL/PostgreSQL performance ?
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 signature.asc Description: This is a digitally signed message part
Re: System Wait kill MySQL/PostgreSQL performance ?
Steffen Neumann <[EMAIL PROTECTED]> - Fri, Sep 10, 2004: > 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. You might want to benchmark your disks (Opteron server & laptop) with hdparm -t and -T. Regards, -- Loïc Minier <[EMAIL PROTECTED]> -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
System Wait kill MySQL/PostgreSQL performance ?
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 signature.asc Description: This is a digitally signed message part
