How to Optimize and Analyze a MySQL Database Tables using phpMyAdmin in Godaddy

If you have deleted a large amount of data from a table or if you have made so many changes to a table with variable length rows such as TEXT, VARCHAR, BLOB or VARBINARY columns.

When you delete the rows then they are maintained in the linked list and further insert operations reuse the old row positions of the table.  You can use “Optimize Table” option to reclaim un-used space and de-fragment the data file for optimal performance of your database.

If a lot of changes have been made to a table then optimizing the table can sometimes significantly improve dramatic performance of the database.

Just follow the process to optimize and analyze a MySql database tables.

Step-1: First log-in into your Godaddy account.

Step-2: Click on Launch button of web hosting.

230720131 Optimize and Analyze a MySQL Database

Step-3: Now click on MySQL under Databases drop down section.

230720132 Optimize and Analyze a MySQL Database

Step-4: Login into your phpMyAdmin account.

Step-5: Now select the database which you want to optimize from the list in the left column of phpMyAdmin.

Step-6: Select the tables which you want to optimize by checking the check box in front of each one or just clicking on Select All if you want to optimize all the tables.

Step-7: In the drop down box you will get “with selected:”, here you have to select “Optimize Table”. 

Step-8 :If you want to analyze the database then just select “Analyze table” instead of “Optimize Table”.

By this option you can optimize and analyze a mysql database.

Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Verma
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)