mysql

SQL queries for mysql RDS - CPU Usage, Locks, Waits and Kill | AWS

Updated on: April 11, 2023 Sarav AK

In this article let me share some SQL queries for RDS MYSQL troubleshooting It is true that when you are choosing RDS or any managed database, you cannot fully control or customize your database. There are few granular restrictions and constraints But AWS RDS is not a complete black box,[...]

How to handle InnoDB: Unable to lock ibdata1 error - MYSQL

Updated on: February 25, 2023 Sarav AK

I have recently migrated a self-hosted MySQL from an EC2 instance to another using AMI copy and restore. and I have seen this error on the newly launched EC2 instance. Coming from a no-DBA background, I spent a day finding the root cause of this I am putting it here[...]