Ben Escoto writes:
>
> message, but everything is the same as before (query still takes a
> long time and explain says it is still using filesort).
>
>
>
> --
> Ben Escoto
>
>
> -
> Before posting, please check:
>http://
> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Mon, 4 Jun 2001 13:41:08 +0300 (EEST)
SM> One more thing.
SM> Can you try to run ANALYZE TABLE on sequence_data and see if
SM> that changes anything ...
I got the
+--+-+
Ben Escoto writes:
>
> For the first:
>
>
>+---+--+---+---+-+---++-+
> | table | type | possible_keys | key | key_len | ref | rows | Extra
> |
>
>+---
On Sun, Jun 03, 2001 at 12:37:50PM -0700, Ben Escoto wrote:
>
> JDZ> Did you try (sid > 15 and sid < 17), or something that means
> JDZ> the same thing as (sid = 16) if sid is an int?
>
> JDZ> Don't know if it'll help, but you never know...
>
> Yep, I thought that was worth a try and atte
> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Sun, 3 Jun 2001 21:31:48 +0300 (EEST)
>> Thank you for the response. In which cases does DESC disable
>> indexed sorting? Perhaps there is a a way around this for the
>> time being? For instance, I noticed
On Sun, Jun 03, 2001 at 11:01:50AM -0700, Ben Escoto wrote:
> > "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> > wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)
>
> >> Hi, I think I found a bug in mysql. I tried the mysqlbug thing
> >> but it didn't work right away. I
> does not and is quite fast. Somehow the optimizer is getting confused
> by the "sid = 16". I was thinking that perhaps there is some magic
> way of rephrasing the problem that MySQL would understand better.
> Failing that, what is the recommended way of making this query
> quicker? Should I i
Ben Escoto writes:
> Thank you for the response. In which cases does DESC disable indexed
> sorting? Perhaps there is a a way around this for the time being?
> For instance, I noticed that although:
>
> SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid DESC,id
> DESC LIMIT 10
>
>
> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)
>> Hi, I think I found a bug in mysql. I tried the mysqlbug thing
>> but it didn't work right away. I hope this message will be
>> detailed enough. I am not subscribed
Ben Escoto writes:
> Hi, I think I found a bug in mysql. I tried the mysqlbug thing but it
> didn't work right away. I hope this message will be detailed enough.
> I am not subscribed to the mailing list.
>
> In the following sections are the output of, respectively:
>
> mysql -e "SHOW VAR
10 matches
Mail list logo
