On Thursday, 20 October 2005 at 16:57:36 +0800, Hiu Yen Onn wrote:
> hi all,
>
> currently, i have a machine with raid 1 and raid 5 (backplane). in order
> to boost up the mysql performance, does it advise install /var/ (mysql
> data directory) into raid 1 or raid 5? please advise. thanks
RAID-5 optimizes storage space, not performance. If you're looking
for performance, RAID-1 is a better choice, though obviously there are
lots of things to consider. In particular, if you're striping
("RAID-10"), choose as large a stripe size as possible. And of course
it can use nearly twice as much disk space.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
