OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Another Performance query

From: A Z (xtcsukyahoo.co.uk)
Date: Mon Mar 22 2004 - 08:39:33 CST

here we go:

explain select * from properties where reference like
'%2332'
+-----------------------------------------------------+
Table ¦ type ¦ possible keys ¦ key ¦ key_len ¦ ref ¦
rows ¦ Extra
+-----------------------------------------------------+
Properties ¦ All ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦
2923 ¦ Using Where

describe properties;
+-----------------------------------------------------+
Field ¦ Type ¦ Null ¦ Key ¦ Default ¦ Extra
+-----------------------------------------------------+
Reference ¦ VarChar(7) ¦ ¦ PRI ¦ ¦

show index from properties;
+-----------------------------------------------------+
Table ¦ Non_unique ¦ Key_name ¦ Seq_in_index ¦
Column_name ¦ Collation ¦ Cardinality ¦ Sub_part ¦
Pakced ¦ Null ¦ Index_type ¦ Comment
+-----------------------------------------------------+
properties ¦ 0 ¦ PRIMARY ¦ 1 ¦ Reference ¦ A ¦ 2923 ¦
NULL ¦ NULL ¦ ¦ BTREE

regards

 --- Benoit St-Jean <lamnethsympatico.ca> wrote: > A
Z wrote:
>
> >Thanks for your replies regarding to my previous
> >query.
> >
> >We have encountered another problem:
> >MySQL 4.0.14, INNODB.
> >A table does have an Index on Field1, this field
> >(Field1) is also the Primary Key. Querying on this
> >field takes a long time, running along with Explain
> >command it displays that it does not use the index.
>
> >Prior converting to INNODB it had been working fine
> in
> >MYISAM.
> >
> >What could cause this problem?
> >
>
> Can you provide us with the EXPLAIN of the query, a
> DESCRIBE TABLE and a
> SHOW INDEX to help us pinpoint what the problem is?
>

        
        
                
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

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