User Login

Help Community Login:

How much database overhead should I allow before I optimize?

1 reply [Last post]
gec721's picture
Welcome, Unverified New GeekDropper!I use Internet ExplorerWindows User
Relationship Status:
Single & Looking
Joined: 09/30/2010
Posts: 4
Drops: 12
Mood: Accomplished

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!

I Averaged: 0 | 0 votes

Read More ...

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
STaRDoGG's picture
Head Mucky MuckJoined the Dark SidePremium Member (Gold)I'm a Code Monkey!The Steel CurtainI use FirefoxI use Google ChromeI use Internet ExplorerI use SafariLinux UserMac UserWindows UserI donated to GeekDrop simply because I love it!Booga Booga BoogaI took a bite of the AppleFormer Phrozen Crew MemberI'm MagicMember of VileThe Dr. put the stem on the apple!The JokerSomeone thinks you're udderly delightful!
Relationship Status:
Single & Not Looking
Joined: 01/14/2009
Posts: 2604
Drops: 3076
Mood: Energetic
Re: How much database overhead should I allow before I ...

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

  1. First off, in MyPHPAdmin, select your database so that you can see all of it's tables

  2. Scroll to the bottom, and click the "Check All" link

  3. In the dropdown menu to the right, select "Repair table"

  4. 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.

  5. Scroll to the top, select your database again

  6. Repeat the steps above, only this time instead of selecting Repair table, select "Optimize table"

  7. Rejoice Thumbs Up

how to repair optimize database phpmyadmin
how to repair optimize database phpmyadmin

Shhh.. dont tell anyone, but we also have a private forum area with the really good stuff, see?

Who's New

Redneck's picture
juanpabarri's picture
henta2002's picture
Vanillachinchilla's picture
versioniii's picture
xgensolutions's picture
OkwuteAgu's picture
CB_Latin's picture
GrimRapper's picture
glrobins's picture
hady's picture
Jessica Davis's picture
CRowmAN's picture
redd993's picture
Austeen Legitt's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2020
TOS | Privacy Policy