Troubleshooting XA transactions in MySQL

This is one of the exciting troubleshooting related to XA transactions let’s dive in. Let me provide a few backgrounds. For one of our clients, when we try to drop a table, it is waiting for metadata lock. On debugging it is one of the XA transactions is holding the shared write lock and causing … Continue reading Troubleshooting XA transactions in MySQL

Online InnoDB Redo log Resize MySQL 8.0.30

  Tired of downtimes and planning to resize your redo log files in MySQL ( InnoDB)? Here we can find a smile on our faces! The latest release of MySQL 8.0.30 ( 2022-07-26 ) has added the Online resize of the InnoDB Redo log. Summary Need for Redo Log InnoDB Redo log Before 8.0.30InnoDB Redo … Continue reading Online InnoDB Redo log Resize MySQL 8.0.30

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