openark kit- MySQL维护小工具包

openark kit- MySQL维护小工具包

openark kit 提供一组小程序，用来帮助日常的 MySQL 维护任务，可代替繁杂的手工操作。

包括：

oak-apply-ri: apply referential integrity on two columns with parent-child relationship. oak-block-account: block or release MySQL users accounts, disabling them or enabling them to login. oak-chunk-update: Perform long, non-blocking UPDATE/DELETE operation in auto managed small chunks. oak-kill-slow-queries: terminate long running queries. oak-modify-charset: change the character set (and collation) of a textual column. oak-online-alter-table: Perform a non-blocking ALTER TABLE operation. oak-purge-master-logs: purge master logs, depending on the state of replicating slaves. oak-security-audit: audit accounts, passwords, privileges and other security settings. oak-show-limits: show AUTO_INCREMENT “free space”. oak-show-replication-status: show how far behind are replicating slaves on a given master.

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。