InnoDB and separated disks
Posted by:
Ya Wi
Date: January 28, 2011 04:34AM
Hi all,
I currently use a server with 2 separated volumes (2 * 4 physical disks in RAID 10 mode).
I know I improved performances by using second volume to store InnoDB log files and binlog.
I could also move some big tables to second volume.
However, I am wondering if I couldn't obtain better results by using 8 physical disks in a single big volume. I suppose the 4 disks of first volume do 95% of workload.
One other question : I use innodb_file_per_table = 1. Should I move ibdata1 to second volume ? I don't know if ibdata1 is intensively used with per_table set to ON.
Many thanks,
Yawi
Subject
Views
Written By
Posted
InnoDB and separated disks
2423
January 28, 2011 04:34AM
937
January 29, 2011 06:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.