Optimizing databases can be important for many reasons, most importantly to speed up the rate in which your database displays results. By optimizing the databases, you can dramatically affect how fast your website loads. Typically, optimization will only produce noticeable results if you have a large database. If your database has tables with over 10,000 rows or is over 500MB in size, it may be beneficial to optimize it. Databases smaller in size my not produce any noticeable results from optimization.
Step 1: Login to your Cpanel admin area
Step 2: Click on phpMyAdmin in Databases Section
Step 3: Click on the database name for your website database located on the left.
Step 4: On the right hand column your tables should be listed. Scroll down and you will see the “Check all” link.
Step 5: Click on that link, make sure all database tables are checked and then from the dropdown next to it, select “Optimize table”.
Finally Your Database was Optimize successfully, you will see after like the below picture.
Thank You.....
No comments:
Post a Comment