Does anyone have any experience splitting up index and data files across different RAID arrays? I'm looking at fast disks in RAID0 for the indexes.. and then some slighly slower (rotational speed) disks with some redundancy (RAID?5) for .MYD/.frm files. Has anyone had any experience or recommendations for a setup like this? My ultimate goal is very fast select performance. I'm not too worried about insert/update speed.
Is there an easy way to configure this for auto-setup when creating new tables? Or would I have to link index files from the data array to the index array each time I create a table? Will I acheive the best read performance with the faster disks on the indexes? Thanks --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
