Hi Daniel! 2014-12-01 20:07 GMT-02:00 Daniel Black <[email protected]>:
> > > ----- Original Message ----- > > Hi Jocelyn! :) > > > > 2014-12-01 10:57 GMT-02:00 jocelyn fournier < [email protected] > > : > > > > > > 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. > ops! that's the myisam output of show index from table || *Table* || *Non_unique* || *Key_name* || *Seq_in_index* || *Column_name* || *Collation* || *Cardinality* || *Sub_part* || *Packed* || *Null* || *Index_type* || *Comment* || *Index_comment* || || est_mov_myisam || 1 || rendimento || 1 || rendimento || A || 3 || || || || BTREE || || || || est_mov_myisam || 1 || rendimento || 2 || lote_rendimento_data || A || 6078 || || || || BTREE || || || || est_mov_myisam || 1 || rendimento || 3 || item_id_red || A || 832974 || || || || BTREE || || || || est_mov_myisam || 1 || item || 1 || item_id || A || 10 || || || || BTREE || || || || est_mov_myisam || 1 || item || 2 || item_id_red || A || 8786 || || || || BTREE || || || || est_mov_myisam || 1 || item || 3 || data_estoque || A || 14577050 || || || || BTREE || || || > > > 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 it was 10.0.12 > > > -- > -- > Daniel Black, Engineer @ Open Query (http://openquery.com.au) > Remote expertise & maintenance for MySQL/MariaDB server environments. > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
