At 19:41 +0300 9/13/04, Egor Egorov wrote:
"Dan Cumpian" <[EMAIL PROTECTED]> wrote:
According to the documentation, when delay_key_write is active the index
keys aren=92t written to disk until the table(s) are closed. When is a =
table
closed? Is it only when a connection is closed?
When connection is closed, when FLUSH TABLES requested and probablt on COMMIT.
I suspect COMMIT makes no difference, because delay_key_write applies only
to MyISAM tables, which are non-transactional.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
