InnoDB ‘Linux aio’ returned OS error 0. Cannot continue operation.

We had faced a weird error for one of our client under Emergency MySQL Support, it was a slave server. Client stated that whenever he tries to Start the replication it goes of loop of restarts. We had a sharing session with the client, At first we intended to rebuild the slave with a fresh … More InnoDB ‘Linux aio’ returned OS error 0. Cannot continue operation.

Estimating records in index range and CPU Spike (MariaDB)

Recently we got paged by CPU spikes on one of our clients slave MySQL ( MariaDB ) server under MyDBOPS Remote DBA Team¬†Support. Our MySQL Engineers started analysing the root cause of the issues and resolved it. This blog provides an overview of the troubleshooting and fix proposed. System Summary : Database server : 10.1.10-MariaDB-log … More Estimating records in index range and CPU Spike (MariaDB)