openark kit Common utilities for MySQL
Download

openark kit Ranking & Summary

openark kit Tags

administer diagnose audit mysql administration database audit diagnose MySQL

openark kit Description

Common utilities for MySQL openark kit is an open source toolkit which provides common utilities to administer, diagnose and audit MySQL databases. The available tools in the openark kit toolset are:· 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. Installation: To install openark kit on your Mac you will have to open a Terminal window, browse to openark kit 's folder and run the following command from inside that directory (you will need administrator privileges to be able to run it):sudo python setup.py install Requirements: · MySQL

openark kit Related Software