Marten Lehmann wrote:
that is the sort of thing that I expected and was afraid of. Also, I
think the mysql documentation doesn't really point out that temporary
tables are always kept in memory. Couldn't mysql create them in
/tmp/. instead?
Actually I was just reading through the docs about thi
Hello,
> If a person forgets to drop temp tables and stays within a connection
for hours or even days, memory resources can be overloaded a lot of temp tables.
Furthermore, loading temp tables with a GB of data is bad practice but is
possible
under such circumstances.
that is the sort of thin
Maybe it is because you can manually create temporary tables in Stored
Procedures.
Creating tables using 'create_priv' allows other users to view your table if
the other users have 'select_priv' for that same table.
Creating tables using 'create_tmp_table_priv' allows only the calling user
to vi
