Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
Steptoe
Involved
Involved


Joined: Oct 09, 2004
Posts: 293

PostPosted: Thu Jan 12, 2006 1:41 pm Reply with quote

This is one of those so called 'dumb' questions.

I have been doing this in the Admin CP most days now on our site for over 15 months. This morning total optimisation just went over the 10 meg mark

I do not really know
what this actually does
or why
or what effect it has
or if it is worth doing each day,
or should it be done in phpmysql.
With out getting too techy could someone please explain?

_________________
My Spelling is NOT incorrect, it's Creative 
View user's profile Send private message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Thu Jan 12, 2006 2:29 pm Reply with quote

Hi, Steptoe

I ´m often hanging around in my database and optimize the tables several times with phpMyAdmin. But it can be done through NukeSentinel depends on the version or just through the administration. One reason why I do this is the overflow in different tables e.g. table nuke_session. I have some blocks like who is online and who is where and the display sometimes not the correct number thats the other reason why I optimize and repair often.If there are a lot of mods in the forums it´s also helpful, but if you have a small website and only some members and a few visitors daily I quess it´s not necessary to optimize so often. In the database you can also check only for tables having overhead and optimize this tables.
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Thu Jan 12, 2006 5:46 pm Reply with quote

It's really not worth doing every day, unless you are really cramming for space. Mostly its to store the temporary overhead data that MySQL generates.
I really only optimize it as part of a routine backup.. that's it

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Thu Jan 12, 2006 7:06 pm Reply with quote

Just my 2 cents but I do mine about once per month.
 
View user's profile Send private message Send e-mail
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Thu Jan 12, 2006 11:07 pm Reply with quote

Keep in mind that NukeSentinel only optimizes NukeSentinel tables. Ther is really little use in optimizing more than once a week at most. Unless you have a super active forum.
 
View user's profile Send private message
Steptoe
PostPosted: Thu Jan 12, 2006 11:08 pm Reply with quote

Quote:

or what effect it has?

So what does it do load site faster? anything like that?
I go into admin each morning the opt db icon is there, so I hit it lol
10 meg is not much in about 460 days so I assumed each day was over kill lol
Space is not a problem...the progs dbs files etc are only about 650 meg on a partition is 15 gig....
Its the backups I make each day (auto) of that partition to another machine that generally take up space even at approx 50% compression.
 
Raven
PostPosted: Thu Jan 12, 2006 11:14 pm Reply with quote

It reorganizes the index for added records, deleted records, changed records alter the index structure. This reorgs it and also compresses unused space.

Check out Only registered users can see links on this board! Get registered or login!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©