Si Chen wrote:
Hello.
Are there any guidelines for recommended data and log volume sizes?
Specifically, do you recommend many data volumes of a modest size (say
20 - 50 MB each) for a database, or do you recommend a larger volume
chunks (of say 500 MB or 1 GB)?
As a rule of thumb, use exactly one volume per physical disk.
Multiple volumes per disk will add extra overhead, increase
fragmentation and are a challenge for disk caches.
But as always, database performance tuning is not easy. So you should run
your own application benchmarks with different I/O configurations. This is
especially true for RAID and network attached storage solutions.
Henrik
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
