Hi, I'll just address the things others didn't answer.
On Thu, Apr 3, 2008 at 2:28 PM, Dre <[EMAIL PROTECTED]> wrote: > 1) Several sources seem to suggest MyISAM is a good choice for data > warehousing, but due to my lack of experience in a transaction-less world, One approach you might consider is using MyISAM tables and MERGE tables together. This makes it much easier to remove old data, if that is a concern, and keeps each table a manageable size. For example, put each day's data in a new MyISAM table and then create a MERGE over them. You might also look into MySQL 5.1's partitioning, too. Brian Miezejevski gave a great session on this at last year's MySQL Conference. The slides don't seem to be available online, but I wrote up my notes on the session: http://www.xaprb.com/blog/2007/04/27/mysql-conference-and-expo-2007-day-4/ You can probably email him and get the slides as well. Regards Baron -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
