This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.From the drop-down menu choose Optimize table. ![]() Tick the tables you wish to optimize, or simply click to select all tables. A list with all the database tables will appear.To perform the optimization, log in to your phpMyAdmin and select the database whose tables you wish to optimize. If you don’t have a password set, simply press enter when prompted.There is no danger in using this tool and you should consider running it occasionally, especially if your database content changes frequently.įortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel. ![]() This could help to shrink a database’s size and remove unused elements that are left behind from frequent changes and for better functionality of the website/application where the database is associated. It is always a good idea to keep your databases’ tables optimized. ![]() Over time, MySQL databases may become less efficient and run slower.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |