MySQL time_zone and CPU Spike another performance troubleshooting

It was a clear day and traffic started to increase as we are in the biggest sale event of the year for one of our Managed services clients. This is one of the interesting troubleshooting let's dive in. Let me provide some background. We were running the Percona version of MySQL (5.7.30), on a 96 … Continue reading MySQL time_zone and CPU Spike another performance troubleshooting

How to Estimate time for Rollback in a cancelled transaction MySQL ?

Rollback is an operation, which changes the current state of the transaction to the previous state. Undo logs are generally required if we want to roll back any of the uncommitted transactions and it plays a major role in Isolation. For any changes made during a transaction, it must be stored priorly, because they are … Continue reading How to Estimate time for Rollback in a cancelled transaction MySQL ?

MySQL “No space left on device from storage engine”

We have planned for archiving the data to improve the DB performance and to reclaim the space. We were evaluating Compression in InnoDB and TokuDB. To find out the best compression method. We started benchmarking the compression ratio between InnoDB and TokuDB. Everything goes well for some time, but after a few hours got an … Continue reading MySQL “No space left on device from storage engine”

Handling case sensitive column in pt-archiver

To copy the data of the particular column of the table to another table/server, We have an option to export the data as CSV and import the data back to a different table. But when the table size is large and we need to copy the data only for the required data to the target … Continue reading Handling case sensitive column in pt-archiver

Faster Load data outfile in MySQL

While exporting the table with MySQL native utility, we don't have any control on the process, and also there will be no progress update as well on the process completion. So when exporting the larger table will consume high resource utilization and also the disk space usage will also be high. MySQL shell utility will … Continue reading Faster Load data outfile in MySQL

Maintenance of MySQL Binary logs

In this blog, we are going to discuss the Maintenance of binary logs. Before going into our topic, let’s recall the basics of binary logs. Binary logs           Binary logs contain all the changes and records that take place in any database. It will log the statements like CREATE, ALTER, DELETE, INSERT and UPDATE. It will … Continue reading Maintenance of MySQL Binary logs

Synopsis of Mydbops 10th edition of opensource database meetup

We're ecstatic and energised at the prospect of sowing the seeds of knowledge in our opensource database community. Thank you to everyone who came out to our 10th opensource database meetup. Our meetup series began in 2018, and the 10th edition took nearly three years to complete. However, we prioritised quality above quantity when distilling. … Continue reading Synopsis of Mydbops 10th edition of opensource database meetup

Webinar Summary: Migrate your EOL MySQL Servers

This brief summarises the proceedings and outcomes of the 2nd MyWebinar which was held on 13th February 2021 at Online Webinar. As part of our thought leadership webinar series, our latest hosting webinar Migrate your EOL MySQL Servers (seamless migration to MySQL group replication / InnoDB cluster) We have conducted MyWebinar with a very positive … Continue reading Webinar Summary: Migrate your EOL MySQL Servers

MySQL Group Replication and its Memory consumption (troubleshooting).

This blog is about one of the issues encountered by our Remote DBA Team in one of the production servers. We have a setup of MySQL 5.7 Single Primary (Writer) GR with cluster size of  3 . Due to OOM, the MySQL process in the primary node got killed, this repeated over the course of … Continue reading MySQL Group Replication and its Memory consumption (troubleshooting).

Troubleshooting an OLAP system on InnoDB

As a part of Mydbops Consulting we have a below problem statement from one of our client. "We have a high powered server for reporting which in turn powers our internal dashboard for viewing the logistics status.Even with a high end hardware, we had a heavy CPU usage and which in turn triggers spikes in … Continue reading Troubleshooting an OLAP system on InnoDB