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@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
