Based on our experience you have to consider the following: - too many volumes will create concurring I/O on the same disk (you'll get a lot of I/O-waits) - each volume needs system ressources (descriptors, threads, memory) - too less volumes will not parallelize
We normally create one volume for one disk doing hardware RAID-5, p. ex. if the RAID-5 consists of 10 disks we create 10 volumes. That will make sure that - the I/O is optimally distributed accross the disks - there are enough server tasks to write the data during savepoint So for your installation I'd create an instance with - 3 volumes for data each on separate disk - 1 volume for log area separate from data - 4 - 5 GB each Just my EUR 0.02 Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
