vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   OptimizeDB (https://vborg.vbsupport.ru/showthread.php?t=37273)

Scheccia 04-10-2002 10:00 PM
OptimizeDB
 
delete the space in excess in your database whit a click.
Optimize Table's space.

Dade 04-10-2002 11:41 PM
I'll try this out, thanks!

Kumaro 04-10-2002 11:53 PM
i dont' understand what this does? does it speed up your board or something? minimize the size of your DB?

Freddie Bingham 04-11-2002 12:18 AM
repair.php will do the same thing.

Dade 04-11-2002 12:20 AM
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 04-11-2002 12:23 AM
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 04-11-2002 01:04 AM
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 04-11-2002 01:06 AM
I wrote repair.php and it has the same OPTIMIZE table commands that this script has in addition to CHECK and REPAIR.

hypedave 04-11-2002 01:07 AM
hey thats cool :cool:

diettalk 04-11-2002 01:34 AM
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 04-11-2002 11:07 AM
meh...i'd rather just use repair.php
thanks.

Webmasta XT 04-11-2002 07:35 PM
where can I get repair.php ?? whatever file freddie is talking about.. where can I get that?

GuruXL 04-12-2002 12:45 AM
the repair.php is in the zip, under the 'extras' folder

Floris 04-12-2002 05:41 AM
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$ 04-13-2002 04:57 AM
Quote:
Originally posted by Scheccia
delete the space in excess in your database whit a click.
Optimize Table's space.
spaces??????

Jawelin 04-13-2002 07:31 AM
phpMyAdmin v2.2.4 + does the job, even.
:)

Webmasta XT 04-13-2002 12:37 PM
thnx GuruXL and xiphoid, time to optimize my database, lol

Wolf42 04-13-2002 08:23 PM
I installed it couse I like the integration to the AdminCP.

Scott MacVicar 04-13-2002 10:59 PM
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 04-14-2002 09:20 AM
Quote:
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 04-14-2002 09:51 AM
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 04-14-2002 02:20 PM
When I use repair.php, I get this error..

PHP Code:
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: [url]http://www.xtreme-forumz.cc/repair.php?check=1&iterations=4&forum=xtreme-forumz_cc[/url]
Referer: 

GuruXL 04-14-2002 05:48 PM
it's probably because it doesn't support the '-' in "xtreme-forumz_cc"

Wolf42 04-15-2002 07:33 AM
Quote:
Originally posted by Webmasta XT
When I use repair.php, I get this error..

PHP Code:
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: [url]http://www.xtreme-forumz.cc/repair.php?check=1&iterations=4&forum=xtreme-forumz_cc[/url]
Referer: 
As far as I know you has to run the script from the admin-folder and not from the forums-root.

DiSS Troya 04-15-2002 08:37 AM
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 04-19-2002 06:37 AM
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 05-01-2002 09:22 AM
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 05-01-2002 12:10 PM
Work great! Thanks for this hack!!!


All times are GMT. The time now is 03:36 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03375 seconds
  • Memory Usage 1,772KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (28)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete