MySQL Bugs: #48267: NDB: During a large import or restore checkpointing should be disabled

Bug #48267	NDB: During a large import or restore checkpointing should be disabled
Submitted:	23 Oct 2009 13:03	Modified:	28 Oct 2009 18:01
Reporter:	Andrew Hutchings	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S4 (Feature request)
Version:	mysql-5.1-telco-7.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When restoring from a backup or importing a large dataset a GCP stop (and other disk-load related problems) is much easier to hit than normal operation of the cluster.

How to repeat:
Import a massive dataset onto a cluster with slow disks

Suggested fix:
Have an switch either in ndb_mgm or in the ndbapi so it can be done in SQL which can disable checkpointing (and re-enable it when finished).  The SQL side could be a var for use with the plugin, something like 'ndb_checkpointing' which is 1 by default.