OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
how disable engine=memory

From: Marten Lehmann (lehmanncnm.de)
Date: Mon Mar 03 2008 - 19:05:20 CST

Hello,

when we create user accounts on our mysql server, then we strictly
disallow "CREATE TEMPORARY TABLE".

This said, I was a bit shocked that mysql doesn't really care and allows
this command without a problem:

create table x engine = memory;

What is the use to deny users to create a temporary table (which is kept
in memory only), when each user is free to consume all memory using the
memory-engine for a table?

Regards
Marten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql