Hi Steven, Shame on me, but I have no idea what the output of iostat tells me -- though I know I should. Can you point me to a good reference to flesh out the man page?
I have 2 18GB Seagate drives -- from dmesg: Vendor: SEAGATE Model: ST318406LC (scsi0:A:0): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit) (scsi0:A:1): 160.000MB/s transfers (80.000MHz DT, offset 63, 16bit) No raid. I have the system on disk1 and MySQL data directory on disk2. I'm not running the update or binary logs. The table is fixed with 12 fields -- 2 chars, 8 int/smallint/tinyint, 1 date, 1 timestamp. Here's the info from show table status: | list | MyISAM | Fixed | 3786043 | 137 | 518687891 | 588410519551 | 161528832 | 0 | 3787110 | 2002-12-20 13:32:41 | 2003-01-15 19:57:16 | 2003-01-14 13:39:39 | | | Thanks, --jeff ----- Original Message ----- From: "Steven Roussey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Jeff Kilbride'" <[EMAIL PROTECTED]> Sent: Wednesday, January 15, 2003 4:04 PM Subject: Re: Optimizing Ext3 for MySQL > I use ext3 and have a qps of anywhere from 2800-8000 and use the > defaults with no problems. Have you tried: > > iostat -k 1 > > to look at your disk access? What kind of disks are they anyhow? IDE or > SCSI? RAIDed? In what fashion? > > Lastly, you said that this is a script that is running, right? The table > that gets updated, is it fixed or dynamic? Using blobs? > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php