Hi, In my experience (assuming that you are using mysql for all of these operations) the best way is to separate your tables into read-heavy and write heavy and put each into separate databases. Put the write-heavy logs database onto a separate disk/spindle and use delayed inserts (so that the apps can carry on regardless). With the read-heavy tables, use raid and/or use heap tables and serve as much from memory as possible to get max performance.
Hardcore Option: If you have heavy logging to a few tables & lots of reads (but not many updates to those tables you're reading from) from lots of other tables (as I do..) use replication over a few machines for the read-heavy tables, do the all selects from there and also write the logs to those machines (but don't replicate the logs) then each day/month (do this at a quiet time...whenever/whatever suits you) dump all the logs to another machine for analysing purposes. This effects a "rollover" of logs and can be quite useful if you're writing lot's of logtables each day. Hope this helped, Andrew Sql,query -----Original Message----- From: Gary Traffanstedt [mailto:[EMAIL PROTECTED]] Sent: Thursday, 03 October 2002 21:27 To: [EMAIL PROTECTED] Subject: raid vs splitting the database sql, query I have a dilemma and maybe you can help. I'm wanting to improve my disk performance and I'm wondering if I should go with Raid 10 or if I should simply mirror the drives so that I have redundancy and then put some of my tables on one drive and some on the other. Or the third option is to put the tables on one drive and the logs on another drive. Ultimately, what is going to give me the best performance? Should I use 3 drives (mirrored so 6 actual drives) and put half of the tables on drive 1, half on drive 2, and logs on drive 3? TIA, Gary --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
