maria-discuss team mailing list archive

[Alexandre Almeida <alexandre@xxxxxxxxxx>]

yes, it makes sense.
Can I assume they are "created" at the time that my show (a select in  
fact) perform?

Em 05/05/2010, às 17:22, Antony Curtis escreveu:

> 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" <alexandre@xxxxxxxxxx 
> > 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@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~maria-discuss
> > More help   : https://help.launchpad.net/ListHelp