MySQL is a multithreaded, multi-user, SQL Database Management System (DBMS). MySQL is popular for web applications and acts as the database component of the LAMP, MAMP, and WAMP platforms and for open-source bug tracking tools like Bugzilla. Its popularity as a web application is closely tied to the popularity of PHP, which is often combined with MySQL and nicknamed the Dynamic Duo. MySQL is also an essential component of the WordPress blogging platform, which also utilizes PHP.
After a long, hard day of fetching and editing tables, MySQL can become overburdened and create overhead, which can be almost directly compared to how defragmentation occurs on a hard drive. This how to ensures you with a healthy database.
1. Locate and login to your phpMyAdmin client.
2. Select the database and click on the name of the database.
3. You should see all of the tables for your database.
4. Select the checkboxes for each table that has an overhead value. Tables with an overhead value under a kilobyte aren’t really anything to worry about.
5. Go to the drop-down menu with selected on the bottom and select repair.
6. If everything works out, you will see the something like the image below.
7. Clicking on the database name again should show the screenshot below, with no overhead for any of the tables.
That’s it!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment