MySQL most popular tool and it has many tools for DBA. As per my knowledge, I have listed the most popular tools for MySQL DBA & support engineers.
MySQL Debugging Tools at Production Issues
The following tools are highly useful for monitoring the overall performance of MySQL on the live environment. These are designed for help to support production issues time.
Innotop:
The innotop is a free, a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL. It doesn’t need difficult queries to get those details manually. It is useful to detect the following MySQL production problems.
- DeadLock
- DB Load
- Running Queries
- Replication lagging
- DB connection analysis
- Open files and tables analysis
You can get how to use it in this post written by Percona.
It is useful for DBA who has Good experience. Also, it can allow monitoring many hosts at once. If you are new to MySQL or you are not specialized in MySQL DBA then it is not useful much.
SmartWorkbench:
All MySQL GUI monitoring tools such as PMM(Percona Monitoring Manager),monyog & VividCortex are not always suitable for all MySQL DBA needs or situations at production support. These all are designed to provide historical views into what happens to our database over time rather than real-time insight into current MySQL server status.
SmartWorkbench is an excellent MySQL GUI tool designed to support when you faced MySQL production problems. It can automatically detect all types of MySQL production issues in a minute. It is easy to use with automation, and no need any special skills to save them
I like this tool because it is super fast to detect & slave problems when you faced DB issues. Most importantly, It saves crucial MySQL Outage time while finding the root cause of the problem and solution for it. It can detect and solve the following issues
- Dead-Lock
- Query locking
- Long-running Queries
- Long-running Transactions
- Replication lagging
- High CPU utilization
- High RAM utilization
- High DISK IO utilization
- DB connection analysis
- Foreign key error
- Storage and space issues
- Table fragmentation issues
- Slow Query Log Analysis
- MySQL Error log analysis
- DB load analysis
- Unused Indexes
- Duplicate Indexes
- InnoDB engine analysis
- MyIAM engine analysis
- Open files and tables analysis
Please watch the following demo video [from 2nd minute]
MySQL Tools for Table Alter:
In RDBMS, table alter is become complex on a huge size table. In some cases, MySQL recreates the table results to block all requests and resources. It causes a DB service outage. The following tools can help to alter a table with out service outage ON MySQL DB.
- Percona pt online schema change
- Github gh-osc
- Facebook OnlineSchemaChange
MySQL Tools for Deployment
The following tools help to speed up and make easily your MySQL deployments. DBdeployer is a tool that deploys MySQL database servers easily.
- DBDeployer Download Demo
- Several Nines clusterControl
MySQL Monitoring tools
MySQL Monitoring Tools:
Thee are three good MySQL monitoring tools available
- PMM (Percona Monitoring Manager ) Free and open source tool
- monyog
- VividCortex expensive 299$ per server per monthn
Please comment below if there are any other tools available for MySQL DBA needs
