--+--+---+
+
| albaranes | range | PRIMARY | PRIMARY | 8 | NULL | 44491 |
where u
sed |
+---+---+---+-+-+--+---+
+
1 row in set (0.00 sec)
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 09, 2002 1
t;[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 12:56 PM
Subject: optimizer bug in selecting fields that don´t belong to the index
used by mysql/Innodb
Description:
Hello,
We reported a problem about selecting fields that some of them didn´t
belong to
the used index on September.
We
Description:
Hello,
We reported a problem about selecting fields that some of them didn´t belong to
the used index on September.
We have already installed MySql 4.0.4 and we have a similar problem
(and also we are still having the original problem) when we select fields which some
Rafa,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 23, 2002 10:54 AM
Subject: optimizer bug in selecting fields that don´t belong to the index
used by mysql/innodb
> Description:
> Hello,
>
> I wrote the
Description:
Hello,
I wrote the following text in my last message (It was an answer to Monty):
>Hello,
> Monty
> I have already sent to pub/mysql/secret the table definition and data
(clientes.txt)
> and my.ini file in a compressed file named clientes.zip.
> You
Date: Wed, 18 Sep 2002 05:46:39 -0400
From: [EMAIL PROTECTED]
InnoDB table
Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And
Cod>'059336') Or Nom>'a2618' Order by Nom ASC, Cod ASC Limit 50;
Time:0.08 secs.
Ha
Hi!
> "rafarife" == rafarife <[EMAIL PROTECTED]> writes:
rafarife> Description:
rafarife> Hi Heikki,
rafarife> I'm Lourdes and I work with Rafa in the MySQL project.
rafarife> We have done what you have told us. We have run SHOW STATUS before
rafarife> the query and we have obtained the
Description:
Hello Monty,
I have already sent to pub/mysql/secret the table definition and data (clientes.txt)
and my.ini file in a compressed file named clientes.zip.
You can import clientes.txt and test it.
I have only then problem with InnoDb tables.
I tell you my test
Hi!
> "rafarife" == rafarife <[EMAIL PROTECTED]> writes:
rafarife> Description:
rafarife> Hello,
rafarife> I am working with mysqld-max-nt under windows 2000 and unsing InnoDb
rafarife> tables.
rafarife> I have the following table:
rafarife>I don´t understa
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Rafa,
Heikki> OR's are generally difficult to optimize.
Heikki, this is true if you are using OR on different keys.
MySQL can fully optimise the query when using OR on different key parts of the
same key (which is the case
Hi!
> "r" == rafarife <[EMAIL PROTECTED]> writes:
r>And now, the explain selects:
r> 1) Slow query
r> explain Select Cod,Nom,Nif,Nombre_comercial from Clientes
r> Where (Nom = 'GARCIA MANCILLA,S.L' And Cod>'061642')
r> Or Nom>'GARCIA MANCILLA,S.L' Order by Nom ASC, C
Description:
Heikki,
1) There is only one record with 'GARCIA MANCILLA,S.L'.
2) Mysql reported 53 scanned rows when I ran your mock-up query on your mock-up
table. This is ok.
3) I'm using mysql.exe client (sometimes I use front-end) and i don´t think it
removes the LIMIT 50
EMPORAL INNER JOIN CLIENTES ON TEMPORAL.COD=CLIENTES.COD;
(Inner join through the field cod, which is the primary index, so it's very fast).
Synopsis: optimizer bug in selecting fields that don´t belong to the index used by
mysql
Submitter-Id:
Originator: Rafa
Organization: Pecomark
My
13 matches
Mail list logo