opearkkit提供一组小程序，用来帮助日常的MySQL维护任务，可代替繁杂的手工操作。
包括：
oak-apply-ri:applyreferetialitegrityotwocolumswithparet-childrelatioship.oak-block-accout:blockorreleaseMySQLusersaccouts,disabligthemoreabligthemtologi.oak-chuk-update:Performlog,o-blockigUPDATE/DELETEoperatioiautomaagedsmallchuks.oak-kill-slow-queries:termiatelogruigqueries.oak-modify-charset:chagethecharacterset(adcollatio)ofatextualcolum.oak-olie-alter-table:Performao-blockigALTERTABLEoperatio.oak-purge-master-logs:purgemasterlogs,depedigothestateofreplicatigslaves.oak-security-audit:auditaccouts,passwords,privilegesadothersecuritysettigs.oak-show-limits:showAUTO_INCREMENT“freespace”.oak-show-replicatio-status:showhowfarbehidarereplicatigslavesoagivemaster.
评论