Partial (Optimised) JSON updates and Replication in MySQL 8.0

           MySQL is the most widely used  Relational Database Management System in the open source world. MySQL stepped into the NoSQL world by introducing the JSON Data Type in MySQL 5.7 release. In this blog post I am going to explain one of the major advantage of optimisation made in JSON … Continue reading Partial (Optimised) JSON updates and Replication in MySQL 8.0

Advertisements

Invisible Indexes – MySQL 8.0

MySQL 8.0 has a rich set of features. One of the feature which interests DBA's more is invisible index What is an index in MySQL ? The indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table … Continue reading Invisible Indexes – MySQL 8.0

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. This blog is made to shed some lights on Cost based optimiser in MySQL 5.7. The cost or statistics are stored in the data dictionary … Continue reading Cost-based Optimization in MySQL 5.7