Hi all, We have a database instance that has recently grown to around 9GB in size. I have some questions wrt performance regarding hardware and db software.
-At the moment I have about 45 data volumes on 1 disk (all together have 3-4 disks available), each data volume being around 200MB. This configuration will be adjusted and tweaked according to your feedback. In my mind one must find a balance between having as small data volumes as possible (easier on maxdb/memory?) and having as few data volumes as possible (fewer file references?). *what is the drawback/benefit of having large data volumes, each being for instance 1 GB as opposed to small data volumes? Would for instance using all 3 disks, and placing 3 data volumes on each disk, each volume being 1GB big be a good solution? *our db instance is about 80% full. What would the drawback be of creating MANY more data volumes, such that the db is only 30% full? Would this overkill have a detrimental effect, and if so, how big? The benefit is of course that the database manager does not have to be so vigilant in terms of not filling the db. Many thanks for your help! Regards Jon Loken -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
