by Bhuvanes Waran | Sep 29, 2023 | Insight for DBAs, MySQL
As a DBA, one of the very frequent tasks is to stop/start MySQL service for batching or some other activities. Before stopping MySQL, we may need to check if there are any active connections; if there are, we may need to kill all those. Generally, we use pt-kill to... by Bhuvanes Waran | Jun 27, 2023 | Insight for DBAs, MySQL, Percona Software
MySQL Shell is an advanced client and code editor for MySQL. In addition to the provided SQL functionality, similar to MySQL, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. The X DevAPI enables you to... by Bhuvanes Waran | Jan 3, 2023 | Insight for DBAs, MySQL
In Managed Services, we have many customers, and as each has a different kind of config and environment, working on their environment is always fun and interesting. In this blog post, I will showcase an issue we faced when dropping a table and how it was...