openarkkit提供一组小程序，用来帮助日常的MySQL维护任务，可代替繁杂的手工操作。
包括：
oak-apply-ri:applyreferentialintegrityontwocolumnswithparent-childrelationship.oak-block-account:blockorreleaseMySQLusersaccounts,disablingthemorenablingthemtologin.oak-chunk-update:Performlong,non-blockingUPDATE/DELETEoperationinautomanagedsmallchunks.oak-kill-slow-queries:terminatelongrunningqueries.oak-modify-charset:changethecharacterset(andcollation)ofatextualcolumn.oak-online-alter-table:Performanon-blockingALTERTABLEoperation.oak-purge-master-logs:purgemasterlogs,dependingonthestateofreplicatingslaves.oak-security-audit:auditaccounts,passwords,privilegesandothersecuritysettings.oak-show-limits:showAUTO_INCREMENT“freespace”.oak-show-replication-status:showhowfarbehindarereplicatingslavesonagivenmaster.
评论