Pro MySQL NDB Cluster

© Jesper Wisborg Krogh and Mikiya Okuno 2017

Jesper Wisborg Krogh and Mikiya OkunoPro MySQL NDB Clusterhttps://doi.org/10.1007/978-1-4842-2982-8_9

9. Table Maintenance

Jesper Wisborg Krogh¹  and Mikiya Okuno²

(1)

Sydney, New South Wales, Australia

(2)

Tochigi, Japan

 

Part II covered the tasks needed to install and configure a cluster, and this part has been focusing on tools and procedures that are used on a day-to-day basis in order to maintain the cluster. An important task for the database administrator is table maintenance. This includes relatively infrequent tasks, such as adding new columns to existing tables over maintaining a good set of indexes, to more frequent tasks like defragmenting tables and updating index statistics. All of these tasks ...