InnoDB depends on operating system threads to process the requests from user transactions, These transactions include requests to InnoDB before commit or rollback. The modern operating systems and servers with multi-core processors, where context switching […]
Recently one of our customers wanted us to benchmark InnoDB, TokuDB and RocksDB on Intel(R) Xeon(R) Gold 6140 CPU (with 72 CPUs), nvme SSD (7 TB) and 530 GB RAM for performance. We have used Ubuntu […]
Occasionally we have customers with MyISAM storage engine approaching us to migrate their database to InnoDB, MyISAM is great if you are just an application like web content management system with no multi-user concurrency challenges […]
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: […]
I personally don’t encourage my readers to follow this post in production without clearly understanding about InnoDB page corruption error troubleshooting, Setting innodb_force_recovery is done only when there is innodb page corruption emergency. By default […]
A deadlock happens when transaction holds lock that the another one needs, This usually happens when multiple transactions are waiting for a resource to become available, neither ever release the locks it holds. A deadlock […]
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 […]
InnoDB is a open source and default general purpose MySQL storage engine built for high performance and reliability , Antelope is the original InnoDB file format which supports both COMPACT and REDUNDANT row formats for […]
Can we run InnoDB from read only media like DVD/CD ? Yes, it’s possible from MySQL-5.6.7 release candidate. This makes users to explicitly setup the instance on read-only mode, It makes entire server instance as […]
MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB is a trademark of Monty Program AB. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner. Copyrights © 2010-2022 All Rights Reserved by MinervaDB®.