2004 8:01 AM
> To: Dathan Vance Pattishall
> Subject: RE: InnoDB Load Problem
>
> I've been keeping tabs on this thread and would just
> like to know how to tell what the buffer pool ratio
> is. What is it a ratio of? What command do I run to
> take a look at it?
>
&
ll;
> [EMAIL PROTECTED]
> Subject: RE: InnoDB Load Problem
>
> Hi,
>
> To put the unique index on like you suggest is fine for this table but
> this
> table is just the top level of a hierarchy.
>
> table a has 1 record
> table b has 100's of records linked to 1 ta
t; Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: InnoDB Load Problem
> This query is to see if there are duplicate records, I'm not sure how else
I
could do this and it only runs once every 10 minutes.
Why don't you put a unique index on locale,ggd,from,to,supplier,date so you
won
Marvin Wright [mailto:[EMAIL PROTECTED]
Envoyé : mardi 20 avril 2004 12:45
À : Dathan Vance Pattishall; Marvin Wright; [EMAIL PROTECTED]
Objet : RE: InnoDB Load Problem
Hi,
Thanks Dathan for your response.
So far I have upgraded the mysql to 4.0.18, this supports O_DIRECT as my
4.0.13 did not.
T
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: 19 April 2004 23:35
To: 'Marvin Wright'; [EMAIL PROTECTED]
Subject: RE: InnoDB Load Problem
> -Original Message-
> From: Marvin Wright [mailto
> -Original Message-
> From: Marvin Wright [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 8:55 AM
> To: [EMAIL PROTECTED]
> Subject: InnoDB Load Problem
>
> Hi,
>
> Apologies in advance for the large post but I've tried to explain my
> problem
> as much as I can.
>
>
>
> I'
