How to optimize MySQL database using phpMyAdmin
July 31, 2011 · Filed Under Web Hosting
Whenever you delete large number of records from your MySQL database, it is recommend to optimize your MySQL database for the best performance. In this article, we will show you how to optimize MySQL database using phpMyAdmin.
- Open your phpMyAdmin tool.
- Select the database you want to optimize on the upper left.
- Select the tables you want to optimize (usually checkmark all tables)
- Using the selection box at the bottom, select “Optimize Table”
This will execute the OPTIMIZE TABLE SQL query on the selected tables.
Related Posts
- How to repair a corrupted MySQL database from cPanel and phpMyAdmin
- How to change MySQL database collation from phpMyAdmin in cPanel
- How to change the database storage engine of a MySQL database table
- How to create a MySQL database from cPanel
- Reset MySQL root password WITHOUT existing root password
Comments
Leave a Reply
You must be logged in to post a comment.
-
Recommended Host
-
