← Back to team overview

maria-discuss team mailing list archive

Re: new mdev about better explain

 


----- Original Message -----
> Hi Jocelyn! :)
> 
> 2014-12-01 10:57 GMT-02:00 jocelyn fournier < jocelyn.fournier@xxxxxxxxx > :
> 
> 
> Hi Roberto,
> 
> What are the cardinalities of the index in this table ? (SHOW INDEXES FROM
> est_mov).
> well i executed optimize and analyze before select...

> i will explain more about the problem...

How novel. Except you didn't provided the asked for information.

> i was using mariadb 10.0.5 (or 10.0.12 i don't remember now), and optimizer
> was using the right index ("rendimento"), after upgrading to 10.0.14 and
> 10.0.15, optimizer is using "item" index, the result is a slower query (it's
> a problem, but it's not related with my doubt...)

Could also be related to https://mariadb.atlassian.net/browse/MDEV-7084

-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.


Follow ups

References