Tags » Innodb

Cost-based Optimization in MySQL 5.7

Optimiser is the brain of the RDBMS. Optimiser decides the right access method , algorithms , join order and right index to be used for better execution of the query. 962 more words

MySQL 5.7

InnoDB and Linux mount point.

In this blog we are going to share my recent experience with an issue which we faced during migration between two Ubuntu servers.

The activity was pretty simple, the client had bought a new machine with enhanced memory and faster disk, so the data has to be transferred to the new server and live MySQL replication has to be configured between the old and the new server. 345 more words

MySQL

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

InnoDB

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

InnoDB

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

InnoDB