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
Hello,
if there are not any security impacts, why does the
Create_tmp_table-privilege exist separately to the
create_table-privilege? Or if it has security impacts (maybe
automatically granting other rights), which ones?
The mysql documentation doesn't tell much about this.
Regards
Marten
EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Tuesday, November 14, 2006 10:49:57 AM GMT-0500 US/Eastern
Subject: question on create_tmp_table_priv
Hello,
if there are not any security impacts, why does the
Create_tmp_table-privilege exist separately to the
create_table-privilege? Or if it ha