OptimizeDB

[Scheccia]

delete the space in excess in your database whit a click.
Optimize Table's space.

[Dade]

I'll try this out, thanks!

[Kumaro]

i dont' understand what this does? does it speed up your board or something? minimize the size of your DB?

[Freddie Bingham]

repair.php will do the same thing.

[Dade]

Yeah I saw that after I ran it freddie, oh well, this is built into the admin cp, more easy to do it. And who made repair.php freddie? Was it the dev team? I thought I read somewhere it wasn't supported and was given as an extra script.

[Scheccia]

when you modify something on the forum in the database remains space that not used... this hack detele this space...

if you go in your phpadmin and go in Session table for example ... you see in red (under table space) "in excess". This is the space that delete.

[hypedave]

if you run the repair.php file that come with vb it gives you this message

repair.php for mysql 3.23 or greater

This script will attempt to repair corrupted databases. While it can repair most common errors, it can not repair everything. As a side benefit it will also optimize your tables. This script is unsupported by jelsoft

[Freddie Bingham]

I wrote repair.php and it has the same OPTIMIZE table commands that this script has in addition to CHECK and REPAIR.

[hypedave]

hey thats cool :cool:

[diettalk]

I get an error when I try to load it....

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/httpd/htdocs/diettalk.com/forums/admin/optidb.php on line 10

--------------------------------------------------------------------------------
You have run this script: 0

--------------------------------------------------------------------------------
You have saved in your database: Kb
--------------------------------------------------------------------------------

[ Optimize DataBase ]

[ Delete Statistic ]

[Kumaro]

meh...i'd rather just use repair.php
thanks.

[Webmasta XT]

where can I get repair.php ?? whatever file freddie is talking about.. where can I get that?

[GuruXL]

the repair.php is in the zip, under the 'extras' folder

[Floris]

When you download vbulletin.zip from the members area on vbulletin.com you will have 2 folders, upload/ and extra/ The repair.php is in the extras/ folder.

[ZiRu$]

Originally posted by Scheccia
delete the space in excess in your database whit a click.
Optimize Table's space.

spaces??????

[Jawelin]

phpMyAdmin v2.2.4 + does the job, even.
:)

[Webmasta XT]

thnx GuruXL and xiphoid, time to optimize my database, lol

[Wolf42]

I installed it couse I like the integration to the AdminCP.

[Scott MacVicar]

I have to say this is a pretty pointless hack, what is this optimization going to get you? a couple of kb shaved off your board size is not really worth it for the amount of cpu time and memory that will get devoted to it.

Though i optimize all my tables every 24 hours before they get backed up.

[Jawelin]

Originally posted by PPN
[...]
Though i optimize all my tables every 24 hours before they get backed up.

Please, excuse the o-t.

Uh, PPN ? I'm not good at MySql properly, but know DBs enough.
Just a tip: DON'T make such a mass operation BEFORE a backup, do it just after.... :nervous:
Such an operation is very inensive to the DBMS engine and if something goes wrong (i.e. db goes down) during that, I'll lose any rollback feature as the engine loose the control.
Your side, you'll loose last 24h activity of your board...

Unrequested tip: make each all-table intensive operation after a backup... You said, with the optimization you'd recover only few bytes for your backed-up gzip file... with very high risk.

Bye

[Scott MacVicar]

I know but I'd rather optimize it before I back it up, saves me doing it if i have to use a backup.

[Webmasta XT]

When I use repair.php, I get this error..


Database error in vBulletin 2.2.4:

Invalid SQL: USE xtreme-forumz_cc
mysql error: You have an error in your SQL syntax near '-forumz_cc' at line 1

mysql error number: 1064

Date: Sunday 14th of April 2002 10:17:33 AM
Script: http://www.xtreme-forumz.cc/repair.php?check=1&iterations=4&forum=xtreme-forumz_cc
Referer:

[GuruXL]

it's probably because it doesn't support the '-' in "xtreme-forumz_cc"

[Wolf42]

Originally posted by Webmasta XT
When I use repair.php, I get this error..


Database error in vBulletin 2.2.4:

Invalid SQL: USE xtreme-forumz_cc
mysql error: You have an error in your SQL syntax near '-forumz_cc' at line 1

mysql error number: 1064

Date: Sunday 14th of April 2002 10:17:33 AM
Script: http://www.xtreme-forumz.cc/repair.php?check=1&iterations=4&forum=xtreme-forumz_cc
Referer:


As far as I know you has to run the script from the admin-folder and not from the forums-root.

[DiSS Troya]

Scheccia, how do i solve this:

Warning: Supplied argument is not a valid MySQL result resource in /home/remin/www/board/admin/optidb.php on line 10

Someone else asked the same thing too. Help.

[v0nreagan]

The error's there only when you run it for the first time, then it creates table optimize_gain and it's all ok...

I think there is something wrong with count tho':
"You have saved in your database: 128946.435 Kb"
That's 129Mb in like 5 seconds? Impossible.

[KISS]

DiSS Troya,

I had the same error the first time I ran it. After I ran it the error went away so I think its cool to run.

Nice hack and Thanks!!

[proton242]

Work great! Thanks for this hack!!!