MySQL Clone Plugin Speed Test

In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of  Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools. Below tools are used for speed comparison of Backup and Recovery, Clone-Plugin Xtrabackup mysqldump … Continue reading MySQL Clone Plugin Speed Test

Save Space on MySQL data with Column Compression

                                   Recently, One of our client reached our Remote DBA team with a requirement to reduce the size of the table as it is having many text columns with huge number of records. At preliminary check , I have … Continue reading Save Space on MySQL data with Column Compression

S-E-P-S as a STRUCTURAL FRAMEWORK FOR DATABASE SUPPORT & SERVICE

Created & Conceptualized by Mydbops Database Learning Centre (MDLC) Mydbops has positioned itself as a specialist service provider over the years, in garnering the repository of solutions for multiple problems that has served as the quick fix and also as a progressive elucidation in the area of Remote Database Administration Support and Service. This has … Continue reading S-E-P-S as a STRUCTURAL FRAMEWORK FOR DATABASE SUPPORT & SERVICE

4th Mydbops Database Meetup

Partnering to participate knowledge sharing for the community of Database Administrators. In continuation to the community contribution with knowledge gained out of experience and networking, Mydbops IT Solutions, conducted its 4th Database Meetup on Saturday, 3rd of August, 2019. Here was the first time, that we had changed our venue. With the like-minded sponsor in … Continue reading 4th Mydbops Database Meetup

Innotop – A Monitoring tool for MySQL

Monitoring MySQL server has never been an easy task. Monitoring also needs to go through many Complex and difficult queries to get the details. All these problems can be overcome by an excellent command line monitoring tool  called “Innotop”. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects … Continue reading Innotop – A Monitoring tool for MySQL

MySQL Partition pruning Explained

Partitioning is a process in which a single larger table is split into several smaller tables (physically) and still considered as a single table.It is generally a good idea for the tables whose size is in a few 100 GB's. While performing select,update,delete operations in a partitioned tables, we can notice a better performance in … Continue reading MySQL Partition pruning Explained

Will IO Size Affect your RDS Performance?​

During our recent consulting with one of our client, We came across an interesting issue on RDS. The baseline is that "Low IO size on your RDS instance can affect your DB performance".  Yes, It’s IO size, Not IOPS. We had our production systems running on RDS MySQL with a single master, 3 replicas. All … Continue reading Will IO Size Affect your RDS Performance?​

MySQL Partition Manager (Yahoo!) in a nutshell

Partitioning is a way of splitting the actual data down into separate .ibd files (data compartments) in the file system based on the defined ranges using the partitioning key. It can help us with maintaining the enormous amount of data in different partitions without much hassle. In this blog post, we are going to see how … Continue reading MySQL Partition Manager (Yahoo!) in a nutshell

InnoDB physical files on MySQL 8.0

Introduction -               MySQL 8.0.10 GPL came out with more changes and advanced features. We have changes on InnoDB physical file layout ( MySQL data directory ) too. This blog will provide the information about the MySQL 8 InnoDB physical files. MySQL system tables are completely InnoDB now ?               Yes, Previously, we don't have too many … Continue reading InnoDB physical files on MySQL 8.0

Descending index in MySQL 8.0

MySQL 8.0 has come with a list of new features for DBA's ,we will discuss the new feature in MySQL 8.0 which supports Descending index.Prior to MySQL 8.0 (i.e MySQL 5.6 and 5.7) creating desc index syntax was supported but desc keyword was ignored, Now in MySQL 8.0 release descending index is extended are supported. … Continue reading Descending index in MySQL 8.0