List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:July 11 2010 1:09pm
Subject:Re: Innodb Choosing Random Index
View as plain text  
You you send us explain of that query.

On Sun, Jul 11, 2010 at 6:31 PM, arijit bhattacharyya
<new2mysql9@stripped>wrote:

> optimize / analyze table in each of the hosts is not a good option for me ,
> this is an in-production set-up with minimal number of boxes in rotation .
>
>
>
> On Sun, Jul 11, 2010 at 5:57 PM, arijit bhattacharyya
> <new2mysql9@stripped>wrote:
>
> >
> > Hi , i am running into trouble due to wrong index chosen by mysql in some
> > particular type of queries . This is happening in a critical production
> > environment where we have deployment in two different colocations . I am
> > seeing that a paticular query is using one index in one set of hosts &
> > another index in another set of hosts . We are not using 'use index'
> clause
> > to explicitly mention the index due to some limitations . But wondering
> > based on what mysql is using different indexes in different hosts . This
> is
> > really surprising , since dataset & table structures are exactly same in
> all
> > the hosts .
> >
> > Other than changing the code to force using 'use index' , is there any
> > other way to resolve it ? And what's the exact reason behind this ? Just
> to
> > have mysql choose the correct index always will simply solve my problem .
> >
> > Thanks .
> >
>



-- 
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile     : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

Thread
Innodb Choosing Random Indexarijit bhattacharyya11 Jul
  • Re: Innodb Choosing Random Indexarijit bhattacharyya11 Jul
    • Re: Innodb Choosing Random IndexPrabhat Kumar11 Jul
Re: Innodb Choosing Random IndexLeonardo Leonardo11 Jul
  • Re: Innodb Choosing Random IndexDan Nelson11 Jul