User Login

Help Community Login:

How much database overhead should I allow before I optimize?

1 reply [Last post]
gec721's picture
gec721
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
From:
Olympus
STaRDoGG
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: 2593
Drops: 3064
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

glrobins's picture
hady's picture
Jessica Davis's picture
Marcus A Willis's picture
Zeniff Hofman's picture
nithya's picture
CRowmAN's picture
redd993's picture
lacostefredritz's picture
jeremyhunmelton's picture
rolandonoblezayacat's picture
maymay2001's picture
Austeen Legitt's picture
JimGuth's picture
mmpaprocki's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2019
TOS | Privacy Policy