MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: How do I know which transaction lock a table?
Posted by: Peter Brawley
Date: March 22, 2013 10:40AM

MyISAM doesn't support transactions.

Before 5.6, most ALTER TABLE commands copied the table, modified the copy, deleted the original, then renamed the copy; clients could read the original and updates were silently redirected to the new table. This could be slow and obviously, concurrency under this plan is chancy.

Transactions bring some order to this mess. Also, 5.6 has optimisations for altering InnoDB tables, see http://dev.mysql.com/doc/refman/5.6/en/innodb-online-ddl.html, so consider migrating your tables to InnoDB, and/or consider fixing the data design such that Alter Table is seldom needed.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How do I know which transaction lock a table?
1628
john walker
March 22, 2013 03:42AM
Re: How do I know which transaction lock a table?
694
Peter Brawley
March 22, 2013 10:40AM
Re: How do I know which transaction lock a table?
636
john walker
March 22, 2013 01:35PM
Re: How do I know which transaction lock a table?
613
Peter Brawley
March 22, 2013 09:10PM
Re: How do I know which transaction lock a table?
581
john walker
March 23, 2013 12:01AM
Re: How do I know which transaction lock a table?
791
Rick James
March 23, 2013 01:07PM
Re: How do I know which transaction lock a table?
861
john walker
March 23, 2013 06:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.