Apache Drill is a revolutionary product that identifies itself as a Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage - While it was often represented or perceived as a tool for Data Engineers or Analysts. It is not just for Data Engineers In this article, we are going[...]
Read moreCategory: mysql
How to Find and Convert Latin1 encoded rows to UTF8 - MySQL
In this brief article, I want to share a few tricks and lessons I have learnt on Converting Latin1 Encoded rows to UTF8 I had a table with a field named username with millions of records and we recently converted that table from latin1 charset to UTF8 First, let's start[...]
Read moreSQL queries for mysql RDS - CPU Usage, Locks, Waits and Kill | AWS
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,[...]
Read moreHow to handle InnoDB: Unable to lock ibdata1 error - MYSQL
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[...]
Read more