Optimize Tables

[PitchouneN64ngc]

Description

With this mod, you can optimize all tables with data free automatically.

This is configured in a daily task by default, you can change this if you want :)

Enjoy ;)

grey
Installation

Time: 1 minute
vB version: 3.6.0 to 3.6.x.

grey
Instructions

Import the product and uplaod the given file.

grey
FAQ

No FAQ for now :p

grey
Copyright

All code present is this mod can't be redistributed or anything else without my consentement.

grey
Changelog

- 1.0.0 : Intial release. (October 24 2007)

grey
If you like it...

-> Mark as Installed (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=161028) <-
and/or
-> Nominate for MOTM (https://vborg.vbsupport.ru/vborg_miscactions.php?do=nominate&threadid=161028&type=1) <-

First package downloaded 260 times.

[elmati]

wow! nice one :D

EDIT: my mistake... :)

[COBRAws]

wow! nice one :)
do u have a demo to inspect the code?

ty for this
There is no demo of this, as it's just a background process. Download the zipped file to check it out ;)

[kaptanblack]

Thanks...

[PoetJA-1975]

hmmm - sounds interesting -but I'm not quite sure what this modification does... Can you explain the process in detail please? And what exactly do you mean by "optimize tables"?

Thanx,

Jacquii.

[pspmaster93]

cool! nice but can you make one for update counters that will allow you to choose some counters that are automatically updated daily.

[ChurchMedia]

I've been waiting for a hack like this. Thanks!

[ssslippy]

What exactly does this do?

[SuperTaz]

What exactly does this do?

I think it is kind of like defragging your PC to make it run faster. Same principle. You would be, in this case, optimizing the tables so that your database, and maybe your site, will run more smoothly. That is what I am getting out of the authors description. I could be wrong though.

[PitchouneN64ngc]

I think it is kind of like defragging your PC to make it run faster. Same principle. You would be, in this case, optimizing the tables so that your database, and maybe your site, will run more smoothly. That is what I am getting out of the authors description. I could be wrong though.
It's that :)

Non-optimized tables can have some space which can be released for any other data, and MySQL didn't have this type of process by default.

[johnrizz]

I'll give it a try...

[OnyxChase]

seems to have speed up my forum - thanks!

[Kaleem]

Great

/me Clicks Install

[aycan555]

woow thanx mate ;)

[SuperTaz]

Installed. Seems to work. My site does seem a bit faster. I will update is something happens.

[lolo?]

merci super utile :)

[TTG]

Useful time saving addition.
Thanks PitchouneN64ngc

[Cyburbia]

How is this different than the optimize tables function that is in the vBulletin Maintenance > Repair/Optimize Tables admin menu?

[momo2]

Sounds like a great idea, so this will work on it's own ? or can it work as manual ?

[AzzidReign]

How is this different than the optimize tables function that is in the vBulletin Maintenance > Repair/Optimize Tables admin menu?
From the sounds of it, it makes what you are talking about run on a cron schedule...that's what I'm getting out of this. So you don't have to continually go in and optimize tables...it does it automatically. Which...when I'm away from my site for a few days, this is something that is really nice to have. Or for those that didn't realize that was there or are just very forgetful like I get to run optimize tables :P

[Snake]

I've been looking for something like this. You just made my life easier. Thanks!

[PJAmerica]

Installed and clicked. Thanks.

[Karline]

Merci Pitchoune

[yoyoyoyo]

nice mod - thanks

[howiulf]

It's nice, tiny and sooooooooooooo useful.


thx a lot :)

[maxicep]

this mod is looking good but i think, it is not useful on big forums.

example:
my post table is 400mb also user table is 40mb.

if i optimize this tables manually in admincp, system crashes 1-2min, and sometimes site down, cause optimize doesnt complete

[PitchouneN64ngc]

You're right, if your tables crashed when you optimize them manually, my mod can't do that better :)

[bollie]

Work for 3.7 ????

[Marco van Herwaarden]

I must post a small warning here:

- Optimising/Repairing tables is not something that should be done on a daily/weekly basis. It has not much use and it might even cause table corruption.
- If your tables crash regulary then you should try to find the cause of this and prevent it from happening, not disguish the symptoms by repairing often.

PS Also please remove the Jelsoft copyright and your license-id from the header of the PHP-file.

[1230]

Thanks

[BigDog56]

Marks installed. Thank you very much!

[PitchouneN64ngc]

I must post a small warning here:

- Optimising/Repairing tables is not something that should be done on a daily/weekly basis. It has not much use and it might even cause table corruption.
- If your tables crash regulary then you should try to find the cause of this and prevent it from happening, not disguish the symptoms by repairing often.

PS Also please remove the Jelsoft copyright and your license-id from the header of the PHP-file.
I'll remove mentionned text from here and posting it in 3.7 Modifications ;)

[RaceJunkie]

I must post a small warning here:

- Optimising/Repairing tables is not something that should be done on a daily/weekly basis. It has not much use and it might even cause table corruption.
- If your tables crash regulary then you should try to find the cause of this and prevent it from happening, not disguish the symptoms by repairing often.

PS Also please remove the Jelsoft copyright and your license-id from the header of the PHP-file.

Thanks for the heads up, Just un installed.

[Daky]

Is there anything like this for vbulletin 3.7.2?

[PitchouneN64ngc]

I'll post an update for 3.7 quickly ;)

[Daky]

Thank you :)

[bollie]

I'll post an update for 3.7 quickly ;)


when ?

[adam75south]

i could really use this in my 3.7, if you have a paypal donate i'll gladly donate to this one.

[PitchouneN64ngc]

My mods (including this one) will have updates very soon (testing them for allowing them to work for 3.6 - 3.8 in a package) :)

[bollie]

My mods (including this one) will have updates very soon (testing them for allowing them to work for 3.6 - 3.8 in a package) :)

Nice ;)