Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Roberto Spadim
hu nice =] thanks stewart, well i'm doing it right the information_schema engine is just to easly view what type the table is but we can see this using the schema thanks! ___ Mailing list: https://launchpad.net/~maria-developers Post to : ma

Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Stewart Smith
Roberto Spadim writes: > maybe just to informe it as information schema? > > how could i know if a I_S table will be memory or aria or myisam? does > mysqld 'parse' it at startup? It depends on the structure of the table and the size it is materialized as. If it's greater than max_heap_table_size

Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Roberto Spadim
maybe just to informe it as information schema? how could i know if a I_S table will be memory or aria or myisam? does mysqld 'parse' it at startup? ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.

Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Stewart Smith
Roberto Spadim writes: > Second doubt... > there's a ENGINE=INFORMATION_SCHEMA > that's more 'beautiful' than 'aria' or 'memory', since they aren't this > kind of engine > like the PERFORMACE_SCHEMA engine All INFORMATION_SCHEMA tables are first materialised into a MEMORY or MyISAM (or, with Mari

Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Roberto Spadim
Second doubt... there's a ENGINE=INFORMATION_SCHEMA that's more 'beautiful' than 'aria' or 'memory', since they aren't this kind of engine like the PERFORMACE_SCHEMA engine ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-deve

[Maria-developers] I_S plugin doubts

2013-06-12 Thread Roberto Spadim
Hi i was reading locale_info and qc_info source that i sent in jira changing the last parameter from 0 to SKIP_OPEN_TABLE, change the table from aria engine to memory engine, why? this change something internally in I_S table ? example: from static ST_FIELD_INFO qc_info_fields_queries[]= { {"E