Tags » Innodb

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. 350 more words


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. 1,151 more words


Galera Cluster a Walk through ( Presentation)

This presentation is about Galera. Galera is a synchronous high availability clustering solution designed for MySQL. At MyDBOPS we have customers on Galera. They depend on the Galera for their business high availability and read scaling. 23 more words


MySQL table type and its peculiarities

Until recently, I did not really care what the ‘type’ the tables in my mysql db were – they could be InnoDB or MyISAM. But recently, I came across situations where I had to understand what the ‘type’ of the table is, to move forward. 223 more words