Bug #7761 Alter table does not autocommit
Submitted: 10 Jan 2005 10:08 Modified: 12 Jan 2005 17:53
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version: OS:
Assigned to: Jonas Oreland CPU Architecture:Any

[10 Jan 2005 10:08] Jonas Oreland
Description:
alter table does not autocommit rows.
This as ha_enable_transactions(FALSE) is called _after_ external_lock.

This make ndb fail big alter table's as MaxNoOfConcurrentOperations becomes a bottleneck.

How to repeat:
alter table
[10 Jan 2005 10:09] Jonas Oreland
As a workaround one might:

set ndb_use_transactions=off;
alter ;
set ndb_use_transactions=on;
[12 Jan 2005 17:53] Jonas Oreland
Fixed in 4.1.9