How to resize InnoDB logs ?
This post is about a very simple approach / step-by-step InnoDB log (aka transaction logs)resize, We don’t do this activity regularly but when we have to resize InnoDB log files, there will be a MySQL […]
MySQL Performance
Purging binary logs from MySQL Master safely
In this post we will discus about the different ways we can purge binary logs safely in MySQL, We recommend you to confirm before purging the binary logs from the master, all logs were applied […]
MySQL 8 invisible indexes
MySQL 8 supports invisible indexes, This allows you to on-demand enable/disable indexes from being used by MySQL optimizer. Now please don’t get confused with “disabled indexes“, “invisible indexes are not disabled indexes, MYISAM supports disabled indexes, […]
How to change the number or size of InnoDB Redo Log Files ?
To change the number or the size of your InnoDB redo log files, please follow the steps below: Step 1: Stop the MySQL server and confirm that it has shutdown without any errors Step 2: […]
InnoDB Disk I/O Performance
You have developed an optimal database design (logical & physical), indexing methods and SQL(s), but still your database performance is slow due to disk I/O, The following below are few direct methods of tuning MySQL […]
MySQL 5.7 Performance Tuning Immediately After Installation
What we do immediately after successful installation of MySQL 5.7 for performance and reliability ? We follow a very minimalistic approach for configuring my.cnf / MySQL system variables to optimally provision the available system resources […]
Percona Server for MySQL 5.7 new features
Percona Server for MySQL 5.7.21-20 GA is released on February 19, 2018. You can download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images […]
InnoDB Transaction Isolation Levels
InnoDB Transaction Isolation Levels To maintain transactional consistency in the database systems, It follows ACID properties. ACID stands for Atomicity, Consistency, Isolation and Durability, The isolation levels determines how transaction must be isolated from the […]
How InnoDB handles locks ?
The database locks exist to protect shared resources or objects, This could be Tables, Data Rows, Data Blocks, Cached Items, Connections or even the Entire Database Systems . The locks ensure reliable transaction that adhere […]
MySQL Performance Audit, Health Check, Diagnostics and Forensics By MinervaDB
We almost daily do MySQL Performance Audit, Health Check, Diagnostics and Forensics for some customer, We are pioneers in architecting and build optimal and scalable MySQL infrastructure operations. To know more about MinervaDB MySQL high performance […]