List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 15 1999 10:22pm
Subject:indexing problem
View as plain text  
>>>>> "Arun" == Arun Bhalla <abhalla@stripped> writes:

Arun> Hi, I'm using MySQL 3.23.2-alpha for sun-solaris2.6-sparc.
Arun> My database consists of two tables, one being 350MB, the other being
Arun> 4GB.  I've indexed it pretty well; the indexes generally perform pretty
Arun> well.  However, for some reason, a small set of cases don't perform well.

Arun> Observe:

mysql> select sample_id from QW_SAMPLE where site_no = '293348094482800' ;
Arun> ...
Arun> 47 rows in set (29.97 sec)

mysql> select sample_id from QW_SAMPLE where site_no = '293348' ;
Arun> Empty set (30.55 sec)

mysql> select sample_id from QW_SAMPLE where site_no = '293347' \g
Arun> Empty set (0.00 sec)

mysql> select sample_id from QW_SAMPLE where site_no = '29334' ;
Arun> Empty set (0.00 sec)

<cut>

Hi!

The fix in this case is to upgrade to 3.23.3;  This fixes a bug in the 
range optimizer for MyISAM which made MySQL ignore keys in some context.

Regards,
Monty
Thread
indexing problemArun Bhalla12 Sep
  • indexing problemJani Tolonen13 Sep
    • Re: indexing problemArun Bhalla13 Sep
      • Re: indexing problemJani Tolonen13 Sep
        • Re: indexing problemArun Bhalla14 Sep
        • Re: indexing problem (another)Arun Bhalla14 Sep
  • indexing problemMichael Widenius16 Sep
    • newbie questionIsfarazi16 Sep
      • Re: newbie questionThimble Smith16 Sep
      • Re: newbie questionJoshua Chamas16 Sep