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

[23 Oct 2009 13:03] Andrew Hutchings 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.