MySQL Shell DBA Toolkit
This is toolkit with several Python module for MySQL Shell to make MySQL DBA's life easier ;)
How to use it:
mysqlsh --py root@localhost
import sys
sys.path.append('/home/fred/workspace/mysql-shell-mydba')
import mydba
innotop.session_processlist.run()
It's also possible to add some steps in ~/.mysqlsh/mysqlshrc.py:
import sys
sys.path.append('/home/fred/workspace/mysql-shell-mydba')
import mydba
and then in the Shell, just call mydba.()
Current Functionalities:
- getProcedures() : list all routines (functions and/or procedures) for a specified schema
- deleteProcedures() : delete all routines for a specified schema
- getPasswordExpiration() : list the account that have a password that will expire (and expired)
- getFragmentedTables() : list the tables that are potentially fragmented (more than <10%> free)
- getDefaults() : list all fields (column) for a table and evaluate and example for default value
Example:
MySQL 127.0.0.1:33060+ Py mydba.getProcedures('test')
PROCEDURE `test`.`helloworld`
Total: 1
MySQL 127.0.0.1:33060+ Py mydba.deleteProcedures('test')
DROP PROCEDURE `test`.`helloworld`
Total dropped: 1