Information schema tables are materialized as temporary tables. Not a bug, just a side effect of the way how they are implemented. On Wednesday, May 05, 2010, at 11:41AM, "Alexandre Almeida" <alexan...@hti.com.br> wrote: >Guys, > > everytime I run the following command: > > show global status like 'created%tmp%tables' > > the created_tmp_tables is incremented by 1. > > Is that right? I mean, which relationship between a show global (that >will perform a minimum select at information_schema) and a new >temporary table? > > I would appreciate your comments. > >Alex > > > > > > >_______________________________________________ >Mailing list: https://launchpad.net/~maria-discuss >Post to : maria-discuss@lists.launchpad.net >Unsubscribe : https://launchpad.net/~maria-discuss >More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
