Yuri, ADD COLUMN should not affect a SELECT concurrently running on the table. I tested this with a 3 million row InnoDB table.
Can you repeat that unexpected behavior? Regards, Heikki Innobase Oy Copied message: ........... Subject: Schema changes affect regular select? From: Yuri Date: Tue, 10 Sep 2002 15:54:45 -0400 (EDT) Do schema operations affect regular statements? I've run "alter table add column ..." on the large table and it coinsided with "select fld from same_table limit 0,1". And this select returned as if no records were available though there were plenty. Is this normal? Should schema changes run independantly if they _really_ don't affect regular statements (if fields not involved in select modified) ? I think schema changes should follow transactional paradigm. But that's tough to do, I understand. At least they have to wait on each other. Yuri. sql,query ---------------------------------------------------------------------------- ---- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
