Tag Archives: how to optimize mysql innodb database
Here at RackNerd, we're on a mission to introduce infrastructure stability on a global scale - one server at a time. Learn more about our story and why you should choose RackNerd for your infrastructure as a service (IaaS) needs!
In this tutorial, we will go over how to optimize MySQL InnoDB tables. The first step is to determine if your database is fragmented, and then connect to the MySQL database and run the following query mentioned below, which tells you how much free space each table has. Log into MySQL command prompt: mysql [(none)] […]