PROTECTED]
Sent: Monday, March 29, 2004 12:24 PM
To: Jack Coxen
Cc: '[EMAIL PROTECTED]'; MySQL List (E-mail)
Subject: RE: Index not functioning - update
just out of curiousity,
have you tried the 4.1.1 version?
there may (or may not) be something from 4.1.0 to 4.1.1
could be a total wa
x27;ll do that if I
> have to but I'd prefer to fix the existing setup of a single index on dtime.
>
> Jack
>
> -Original Message-
> From: Jack Coxen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 24, 2004 1:51 PM
> To: '[EMAIL PROTECTED]'; MySQ
7;ll do that if I
have to but I'd prefer to fix the existing setup of a single index on dtime.
Jack
-Original Message-
From: Jack Coxen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:51 PM
To: '[EMAIL PROTECTED]'; MySQL List (E-mail)
Subject: RE: Index not fun
; From: Jack Coxen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 24, 2004 11:51 AM
> To: '[EMAIL PROTECTED]'; MySQL List (E-mail)
> Subject: RE: Index not functioning
>
>
> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
, 2004 2:01 PM
To: [EMAIL PROTECTED]
Subject: Re[2]: Index not functioning
Hello Jack,
Wednesday, March 24, 2004, 6:50:45 PM, you wrote:
JC> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
JC> EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime)
Hello Jack,
Wednesday, March 24, 2004, 6:50:45 PM, you wrote:
JC> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
JC> EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime) FROM ifInOctets_137
JC> USE INDEX (dtime) WHERE id=2809 AND dtime BETWEEN FROM_UNIXTIME(107397)
JC> A
sec)
Is my syntax wrong?
The resultset size should be around 8640 rows - 5 minute interval data for
30 days - 12 X 24 X 30 = 8640
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:22 PM
To: Jack Coxen; MySQL List (E-mail)
Subject:
gt; Jack
>
> -Original Message-
> From: Victor Pendleton [ mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Sent: Wednesday, March 24, 2004 12:24 PM
> To: Jack Coxen; MySQL List (E-mail)
> Subject: Re: Index not functioning
>
>
> The optimiz
, 2004 12:24 PM
To: Jack Coxen; MySQL List (E-mail)
Subject: Re: Index not functioning
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote: >
> I have a series of tables tha
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote: >
> I have a series of tables that were created by:
>
> CREATE TABLE ifInOctets (
> id int(11) NOT NULL default '0
I have a series of tables that were created by:
CREATE TABLE ifInOctets (
id int(11) NOT NULL default '0',
dtime datetime NOT NULL default '-00-00 00:00:00',
counter bigint(20) NOT NULL default '0',
KEY ifInOctets_idx (dtime)
);
When I r
11 matches
Mail list logo