From: Dre (abyfieldgmail.com)
Date: Mon Apr 07 2008 - 15:10:56 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hey Baron,

Your blog post was quite informative; your suggestion to use a
combination of merged MyISAM tables and InnoDB for the live partition
made a lot of sense, and it sounds like the path I'll need to follow.

I appreciate the information!

Baron Schwartz wrote:
> Hi,
>
> I'll just address the things others didn't answer.
>
> On Thu, Apr 3, 2008 at 2:28 PM, Dre <abyfieldgmail.com> 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
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]