How to optimize MySQL database using phpMyAdmin

  • Post last modified:March 3, 2014
  • Post category:Web Hosting
  • Post comments:0 Comments
  • Reading time:1 mins read

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.

Leave a Reply