It is always a good idea to keep your MySQL databases’ tables optimized. This can help with server load and website loading speed.

Thanks to phpMyAdmin (available with cPanel and other hosting control panels), optimizing your database tables if very easy!

To perform the optimization, log in to phpMyAdmin and select the database that contains the tables you want to optimize.

A list with all the database’s tables will appear. Tick the tables you want to optimize, or if you want to optimize them all, just click Check All.

Now click on the “With selected” dropdown menu and choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized. Click here to see a screenshot

It’s as easy as that!

Posted on 2nd January 2013 by in Tutorials, Website Management
database optimize, mysql, phpmyadmin
Related Posts from Tutorials, Website Management
HTML5/Javascript Scratchcard ScriptHTML5/Javascript Scratchcard Script
WordPress: Add Button to the Visual Editor (TinyMCE)WordPress: Add Button to the Visual Editor (TinyMCE)
Displaying PHP Array Results in a Loop
How to Change the URL/Link to Your Facebook PageHow to Change the URL/Link to Your Facebook Page
Related Posts ASCII Table – HTML CodesASCII Table – HTML CodesWordPress: Adding Default Custom Fields on New PostsWordPress: Adding Default Custom Fields on New PostsWordPress: Creating Breadcrumbs without a PluginWordPress: Creating Breadcrumbs without a PluginBlacklist words in PHP ArrayBlacklist words in PHP Array
Free Graphics, Icons, Tutorials
Free Graphics Free Christmas Vector Icon Graphics Pack 2017Free Fitness Vector Icons Graphics PackFree Camping Vector Graphics PackFree Summer Graphics PackFree File Icon PackFree Fast Food Vector Graphics
Recent Posts How to dynamically display content based on geo IP location using only JavaScriptHow to dynamically display content based on geo IP location using only JavaScriptWordPress: How to create a distance/radius search using Google Maps API and WordPress custom fields querying post meta by latitude and longitudeWordPress: How to create a distance/radius search using Google Maps API and WordPress custom fields querying post meta by latitude and longitudeMarketing Your Business in 2019Marketing Your Business in 2019Making Your Website Secure With SSL (HTTPS)Making Your Website Secure With SSL (HTTPS)JavaScript: How to Add A Parameter to the Current URL Without RefreshingJavaScript: How to Add A Parameter to the Current URL Without RefreshingWordPress: How to Change Read More Text on Category Buttons in WooCommerceWordPress: How to Change Read More Text on Category Buttons in WooCommerce
Categories
Sharing is caring...
More...
Like & Follow
Share the love, share this page! Facebook Twitter Digg Reddit LinkedIn Pinterest Email
Close [X]
The Web Taylor
1000 Lakeside North Harbour Portsmouth, Hampshire PO6 3EN
02392 123358