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.
Step-3: Now click on MySQL under Databases drop down section.
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.
