> I suggest setting record_buffer to 1 MB. Disk reads in blocks of 1 MB are
> probably as fast as in blocks of 10 MB.
I agree
A typical modern disk has an average access time of 5.5 msec and a transfer
rate of 40 Mbyte/sec.
This means that the two are the same for a disk transfer of about 200kbyte.
Therefore,
tranfers significantly smaller than 200kb will be wasteful because of too
many seeks, whereas
transfers more than a few times this will be wasteful (unless all the data
is used) because of
time spent getting data which is never used. For a disk of this type (good
scsi 10,000 rpm), I
would have thoght a transfer size of 0.5-1.0 megabyte would be a good
target. If the disk
has lower acces tume (e.g. 15,000 rpm) reduce the transfer size. If the
disk is externally
raid-ed, probably increase the transfer size.
Alec Cawley (who uses disks for video servers)
SQL database
---------------------------------------------------------------------
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
