Date: Mon, 02 Oct 2006 13:22:37 -0400
To: mysql@lists.mysql.com
From: Michael Gargiullo <[EMAIL PROTECTED]>
Subject: RE: Partition Help
Message-id: <[EMAIL PROTECTED]>
Daily partitions are created then sub partitioned across 6 data disks
and 6 index disks.
We attempted to
>
>
>Thanks for the advice.
>
>We've got 12GB of RAM, I'll increase the key_buffer_size.
Unfortunately
>I can't turn off indexes, then index after. At these rates, I'd never
>catch up.
I don't agree. It takes longer to build the index than to load the data
if
you have indexes active when loadi
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 5:27 PM
To: mysql@lists.mysql.com
Subject: RE: Partition Help
At 03:37 PM 9/26/2006, you wrote:
> >
> >Mike
> >
> >
> >We're using the Load infile function to lo
At 03:37 PM 9/26/2006, you wrote:
>
>Mike
>
>
>We're using the Load infile function to load the data generated by
>another process. We do not do updates, but occasionally need to either
>walk the table or run a query against it. On Oracle, we currently need
3
>hour partitions to keep the 5 indexe
>
>Mike
>
>
>We're using the Load infile function to load the data generated by
>another process. We do not do updates, but occasionally need to either
>walk the table or run a query against it. On Oracle, we currently need
3
>hour partitions to keep the 5 indexes timely.
>
>This system handles 450
At 02:53 PM 9/26/2006, Michael Gargiullo wrote:
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 3:40 PM
To: mysql@lists.mysql.com
Subject: Re: Partition Help
At 02:03 PM 9/26/2006, you wrote:
>I'm working on a project in which we&#
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 3:40 PM
To: mysql@lists.mysql.com
Subject: Re: Partition Help
At 02:03 PM 9/26/2006, you wrote:
>I'm working on a project in which we'd like to convert from Oracle to
>MySQL. We n
At 02:03 PM 9/26/2006, you wrote:
I'm working on a project in which we'd like to convert from Oracle to
MySQL. We need to partition our data for speed concerns. Currently in
Oracle I create 8, 3 hour partitions for each day (Currently running
450M -750M rec inserts/day). I was looking for matchi
