I'm running my first website on my own server and I was wondering how much database overhead I should allow before I should Optimize it so that there isn't any speed loss on my site? And can you tell me how to clear the overhead? I use MySQL and PHPMyAdmin to administer my site database. TIA!
Olympus
Single & Not Looking
I think it's more a matter of preference, but I don't like to let my database overhead get over ~10mb. As a rule of thumb, I just try to clear it once a week, but it also depends on how much traffic your website gets. GeekDrop gets an enormous amount of visitors everyday so I need to sort of stay on top of it. In PHPMyAdmin, here's how to do it (with screenshots further below):
Repairing / Optimizing / Clearing Overhead on your Database
First off, in MyPHPAdmin, select your database so that you can see all of it's tables
Scroll to the bottom, and click the "Check All" link
In the dropdown menu to the right, select "Repair table"
Let it do it's thing. Once it's done, look in the Msg_text column just to be sure everything says "OK". At this point, your overhead has been cleared.
Scroll to the top, select your database again
Repeat the steps above, only this time instead of selecting Repair table, select "Optimize table"
Rejoice