ࡱ> sur @ cbjbj00 .RbRb[DDDDDDDX//// /lXi;$0$0$0$0$0$0$0$0:::::::$<Rq>h;D$0$0$0$0$0;DD$0$0#;<:<:<:$0 D$0D$0:<:$0:<:<:DD<:$00 PSM\/9L<::9;0i;<:>9><:XXDDDD>D<:$0$0<:$0$0$0$0$0;;XXd-.:.XX.I have install MySQL V5.0.27 with federated engine support in both linux1 and linux2. This is federated table at linux1 : linux1@mysql>show create table tblfedpaistotal2005_22; +---------------------------+---------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------+ | Table | Create Table | +---------------------------+---------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------+ | tblfedpaistotal2005_22 | CREATE TABLE `tblfedpaistotal2005_22` ( `FLUJO` char(1) default NULL, `ANNO` int(2) default NULL, `MES` int(2) default NULL, `PROV_ADU` int(2) default NULL, `ADM_DOC` char(6) default NULL, `POS_ESTAD` char(12) default NULL, `ID` char(1) default NULL, `COD_ADIC` char(8) default NULL, `ZONA_INTER` int(1) default NULL, `PAIS_ORIG_DEST` char(3) default NULL, `PAIS_PROC_EXPED` char(3) default NULL, `PAIS` char(3) default NULL, `PROV_ORIG_DEST` int(2) default NULL, `PROV` int(2) default NULL, `TIPO_DECL` char(3) default NULL, `REG_ADUA_SOLIC` int(2) default NULL, `REG_ADUA_PRECED` int(2) default NULL, `PESO` int(15) default NULL, `UNIDADES` int(15) default NULL, `VALOR_ESTAD` int(12) default NULL, `VALOR_FACT` int(12) default NULL, `PAIS_DIVISA` char(3) default NULL, `CONTENEDOR` int(1) default NULL, `REG_TRANSPORT` int(5) default NULL, `MODO_TRANSPORT` int(2) default NULL, `NAC_TRANSPORT` char(3) default NULL, `TIPO_DEC_INTR` int(1) default NULL, `NATURALEZA` int(2) default NULL, `COND_ENTR` char(3) default NULL, `CONTINGENTE` int(6) default NULL, `PREF_ARANC` int(6) default NULL, `FLETE` int(12) default NULL, `PROV_DOMIC_FIS` int(2) default NULL, `POS_ESTAD_TITULO` char(4) default NULL, `POS_ESTAD_CAPITULO` char(2) default NULL, KEY `indxPaisTotal2005_22_MES` (`MES`), KEY `indxPaisTotal2005_22_PROV_ADU` (`PROV_ADU`), KEY `indxPaisTotal2005_22_POS_ESTAD_TITULO` (`POS_ESTAD_TITULO`), KEY `indxPaisTotal2005_22_PAIS_ORIG_DEST` (`PAIS_ORIG_DEST`), KEY `indxPaisTotal2005_22_PAIS_PROC_EXPED` (`PAIS_PROC_EXPED`), KEY `indxPaisTotal2005_22_PAIS` (`PAIS`), KEY `indxPaisTotal2005_22_PROV_ORIG_DEST` (`PROV_ORIG_DEST`), KEY `indxPaisTotal2005_22_PROV` (`PROV`), KEY `indxPaisTotal2005_22_MODO_TRANSPORT` (`MODO_TRANSPORT`), KEY `indxPaisTotal2005_22_PROV_DOMIC_FIS` (`PROV_DOMIC_FIS`) ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root:password@linux2/olappais/tblpaistotal2005_22' | +---------------------------+---------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------+ 1 row in set (0,00 sec) and these are three queries to federated table: linux1@mysql>select count(*) from tblfedpaistotal2005_22; +----------+ | count(*) | +----------+ | 2145119 | +----------+ 1 row in set (35,48 sec) linux1@mysql>explain select count(*) from tblfedpaistotal2005_22\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: tblfedpaistotal2005_22 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 2145119 Extra: 1 row in set (0,00 sec) linux1@mysql>select count(*) from tblfedpaistotal2005_22 where MES=1; +----------+ | count(*) | +----------+ | 155709 | +----------+ 1 row in set (3,13 sec) linux1@mysql>explain select count(*) from tblfedpaistotal2005_22 where MES=1\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: tblfedpaistotal2005_22 type: ref possible_keys: indxPaisTotal2005_22_MES key: indxPaisTotal2005_22_MES key_len: 5 ref: const rows: 2 Extra: Using where 1 row in set (0,00 sec) linux1@mysql>select distinct FLUJO,ANNO,MES from tblfedpaistotal2005_22 where MES=1; +-------+------+------+ | FLUJO | ANNO | MES | +-------+------+------+ | E | 5 | 1 | | I | 5 | 1 | +-------+------+------+ 2 rows in set (3,20 sec) linux1@mysql>explain select distinct FLUJO,ANNO,MES from tblfedpaistotal2005_22 where MES=1\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: tblfedpaistotal2005_22 type: ref possible_keys: indxPaisTotal2005_22_MES key: indxPaisTotal2005_22_MES key_len: 5 ref: const rows: 2 Extra: Using where; Using temporary 1 row in set (0,01 sec) This is target MyISAM table at linux2: linux2@mysql> show create table tblpaistotal2005_22; +------------------------+------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------------------+------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------+ | tblpaistotal2005_22 | CREATE TABLE `tblpaistotal2005_22` ( `FLUJO` char(1) default NULL, `ANNO` int(2) default NULL, `MES` int(2) default NULL, `PROV_ADU` int(2) default NULL, `ADM_DOC` char(6) default NULL, `POS_ESTAD` char(12) default NULL, `ID` char(1) default NULL, `COD_ADIC` char(8) default NULL, `ZONA_INTER` int(1) default NULL, `PAIS_ORIG_DEST` char(3) default NULL, `PAIS_PROC_EXPED` char(3) default NULL, `PAIS` char(3) default NULL, `PROV_ORIG_DEST` int(2) default NULL, `PROV` int(2) default NULL, `TIPO_DECL` char(3) default NULL, `REG_ADUA_SOLIC` int(2) default NULL, `REG_ADUA_PRECED` int(2) default NULL, `PESO` int(15) default NULL, `UNIDADES` int(15) default NULL, `VALOR_ESTAD` int(12) default NULL, `VALOR_FACT` int(12) default NULL, `PAIS_DIVISA` char(3) default NULL, `CONTENEDOR` int(1) default NULL, `REG_TRANSPORT` int(5) default NULL, `MODO_TRANSPORT` int(2) default NULL, `NAC_TRANSPORT` char(3) default NULL, `TIPO_DEC_INTR` int(1) default NULL, `NATURALEZA` int(2) default NULL, `COND_ENTR` char(3) default NULL, `CONTINGENTE` int(6) default NULL, `PREF_ARANC` int(6) default NULL, `FLETE` int(12) default NULL, `PROV_DOMIC_FIS` int(2) default NULL, `POS_ESTAD_TITULO` char(4) default NULL, `POS_ESTAD_CAPITULO` char(2) default NULL, KEY `indxPaisTotal2005_22_MES` (`MES`), KEY `indxPaisTotal2005_22_PROV_ADU` (`PROV_ADU`), KEY `indxPaisTotal2005_22_POS_ESTAD_TITULO` (`POS_ESTAD_TITULO`), KEY `indxPaisTotal2005_22_PAIS_ORIG_DEST` (`PAIS_ORIG_DEST`), KEY `indxPaisTotal2005_22_PAIS_PROC_EXPED` (`PAIS_PROC_EXPED`), KEY `indxPaisTotal2005_22_PAIS` (`PAIS`), KEY `indxPaisTotal2005_22_PROV_ORIG_DEST` (`PROV_ORIG_DEST`), KEY `indxPaisTotal2005_22_PROV` (`PROV`), KEY `indxPaisTotal2005_22_MODO_TRANSPORT` (`MODO_TRANSPORT`), KEY `indxPaisTotal2005_22_PROV_DOMIC_FIS` (`PROV_DOMIC_FIS`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +------------------------+------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------+ 1 row in set (0,00 sec) and this is the content of linux2 log file related with the three above queries : Time Id Command Argument ------------------------------------------------------------------ 070301 16:22:55 1 Connect root@linux1.site on olappais 1 Query SELECT * FROM `tblpaistotal2005_22` WHERE 1=0 1 Quit 070301 16:23:14 2 Connect root@linux1.site on olappais 070301 16:24:19 2 Query SHOW TABLE STATUS LIKE 'tblpaistotal2005_22' 2 Query SELECT `FLUJO`, `ANNO`, `MES`, `PROV_ADU`, `ADM_DOC`, `POS_ESTAD`, `ID`, `COD_ADIC`, `ZONA_INTER`, `PAIS_ORIG_DEST`, `PAIS_PROC_EXPED`, `PAIS`, `PROV_ORIG_DEST`, `PROV`, `TIPO_DECL`, `REG_ADUA_SOLIC`, `REG_ADUA_PRECED`, `PESO`, `UNIDADES`, `VALOR_ESTAD`, `VALOR_FACT`, `PAIS_DIVISA`, `CONTENEDOR`, `REG_TRANSPORT`, `MODO_TRANSPORT`, `NAC_TRANSPORT`, `TIPO_DEC_INTR`, `NATURALEZA`, `COND_ENTR`, `CONTINGENTE`, `PREF_ARANC`, `FLETE`, `PROV_DOMIC_FIS`, `POS_ESTAD_TITULO`, `POS_ESTAD_CAPITULO` FROM `tblpaistotal2005_22` ---------------------------------------------------------------------- 2 Query SELECT `FLUJO`, `ANNO`, `MES`, `PROV_ADU`, `ADM_DOC`, `POS_ESTAD`, `ID`, `COD_ADIC`, `ZONA_INTER`, `PAIS_ORIG_DEST`, `PAIS_PROC_EXPED`, `PAIS`, `PROV_ORIG_DEST`, `PROV`, `TIPO_DECL`, `REG_ADUA_SOLIC`, `REG_ADUA_PRECED`, `PESO`, `UNIDADES`, `VALOR_ESTAD`, `VALOR_FACT`, `PAIS_DIVISA`, `CONTENEDOR`, `REG_TRANSPORT`, `MODO_TRANSPORT`, `NAC_TRANSPORT`, `TIPO_DEC_INTR`, `NATURALEZA`, `COND_ENTR`, `CONTINGENTE`, `PREF_ARANC`, `FLETE`, `PROV_DOMIC_FIS`, `POS_ESTAD_TITULO`, `POS_ESTAD_CAPITULO` FROM `tblpaistotal2005_22` WHERE (`MES` = '1') ---------------------------------------------------------------------- 070301 16:37:17 2 Query SHOW TABLE STATUS LIKE 'tblpaistotal2005_22' 2 Query SELECT `FLUJO`, `ANNO`, `MES`, `PROV_ADU`, `ADM_DOC`, `POS_ESTAD`, `ID`, `COD_ADIC`, `ZONA_INTER`, `PAIS_ORIG_DEST`, `PAIS_PROC_EXPED`, `PAIS`, `PROV_ORIG_DEST`, `PROV`, `TIPO_DECL`, `REG_ADUA_SOLIC`, `REG_ADUA_PRECED`, `PESO`, `UNIDADES`, `VALOR_ESTAD`, `VALOR_FACT`, `PAIS_DIVISA`, `CONTENEDOR`, `REG_TRANSPORT`, `MODO_TRANSPORT`, `NAC_TRANSPORT`, `TIPO_DEC_INTR`, `NATURALEZA`, `COND_ENTR`, `CONTINGENTE`, `PREF_ARANC`, `FLETE`, `PROV_DOMIC_FIS`, `POS_ESTAD_TITULO`, `POS_ESTAD_CAPITULO` FROM `tblpaistotal2005_22` WHERE (`MES` = '1') Thats right, as you have said, linux2 not always does a full scan, but it looks like if always needs all fields of MyISAM table. Why it is not passed the same query done at linux1 to linux2? Furthermore, it looks as, in the first query, linux2 returns all rows to linux1 instead of return only the result of the query. Thanks for your quick support! 6[. T !ccchhqmH sH hhhmH sH VW{|*   } k Y G5#bRBgdc2 n\J8&R4Yvgdv/Wu , R w !8!_!!!!!"8"c"""gd""2#r### $L$$$$@%%.&&'' (((o))]**K++9,,'-w-gdw-------- ..$.1.>.W.X.Y.Z..../)/> ???r@gdr@@XAAFBB4CC"DDEEEuFFcGGQHH8IuIIIIIJ9JVJyJJgdJJJK7KUKyKKKK L2LWL}LLLLM?McMMMMMNCNpNNNOgdOROOOP,PlPPPKQQ9RR'SSTTUzUUhVVVWWDXXXXX!Ygd!Y"Y#YOYPYYY(ZEZZZF[[+\\ ] ] ]R]S]].^^______`gd```saaYbhbibjbbb+cccccgd,1h. A!"#$% @@@ NormalCJ_HaJmH sH tH NA@N Fuente de prrafo predeter.Vi@V  Tabla normal :V 44 la ,k@, Sin lista [VW{|*}kYG5#b R B 2  n\J8&R4Yv/Wu ,Rw8_8c2r L@. o!!]""K##9$$'%w%%%%%%%% &&$&1&>&W&X&Y&Z&&&&')'<'P'd'x''''''''''("(/(<(I(V(n(o(p((())')M)`))))))****f*s******+++++ +[+++++ ,,G,o,,,,,,,,,--J--8..&//001y11g22U33C44*5566 777r88X99F::4;;"<<===u>>c??Q@@8AuAAAAAB9BVByBBBBC7CUCyCCCC D2DWD}DDDDE?EcEEEEEFCFpFFFGRGGGH,HlHHHKII9JJ'KKLLMzMMhNNVOODPPPPP!Q"Q#QOQPQQQ(RERRRFSS+TT U U URUSUU.VVWWWWWWXXXsYYYZhZiZjZZZ+[[[[[@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0000000000000000000000000ZZ+[[[[[@0 L@0@0k@0@0@0c2v"w-/24r@JO!Y`c356789:;<=>?@c4|67@BFKR[./:<?DKT !#&*1;KMQU\fxz~ .9JN\`ny '8Sdhvzy%|%%%%%%%%%%%%%%%%%%%%%%%%%%% &&@&C&G&J&R&U&`&f&g&n&o&u&v&{&&&&&&&&&&& ''2'6'<'I'Z']'j'q'''''''''''''''''''( ((($()(X([(_(b(i(l(v(|(}(((((((((((((( ) )))/)4)V)Z)\)_)`)m)o)))))))))))))))))*** ****"*(*)*/*0*8*9*G*H*L*f*k*l*q*+ + ++++&+,+-+4+5+;+<+D+E+S+T+X+r+w+x+}+++++++++,,,,,,,.,?,Q,T,V,g,u,|,,,,,,,,,,,,,,,,,,,,,,,,,,,,--- - --!-(-.-/-4-,515E5K5L5Q5AAAAAAAAAAAAAAAAAAAAABB BB B"B&B+B2B@BDBHBOBYBaBcBgBkBrB|BBBBBBBB[[[[[rz6[.T[[33[[6[.T[%$:"$Q"3h F4!T!K/GG2k8n8%:tOb]@f_fekHu+xi} *Bc) E[ 4gq& 0V@R/|'@[[pbk[[[P@UnknownGz Times New Roman5Symbol3& z Arial"1 M.M.!4[[3H ?*I have install MySQL V5JLPCJLPCOh+'0|  8 D P\dltI have install MySQL V5JLPC Normal.dotJLPC1Microsoft Word 10.0@F#@HM\@M\M՜.+,0 hp  Home.[ I have install MySQL V5 Ttulo  !"#$%&'()*+,-./0123456789:;<=>?@ACDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghiklmnopqtRoot Entry F0_M\v1TableB>WordDocument.SummaryInformation(bDocumentSummaryInformation8jCompObjk  FDocumento Microsoft Word MSWordDocWord.Document.89q