Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
Reload this Page OptimizeDB
FAQ Community Calendar Today's Posts Search

Reply
Page 2 of 3 1 2 3
 
Thread Tools
OptimizeDB Details »»
OptimizeDB
Version: 1.00, by Scheccia Scheccia is offline
Developer Last Online: May 2003 Show Printable Version Email this Page
Version: 2.2.x Rating:
Released: 04-10-2002 Last Update: Never Installs: 5
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 04-11-2002, 11:07 AM
Kumaro's Avatar
Kumaro Kumaro is offline
 
Join Date: Oct 2001
Location: T.O
Posts: 122
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
meh...i'd rather just use repair.php
thanks.
Reply With Quote
  #13  
Old 04-11-2002, 07:35 PM
Webmasta XT's Avatar
Webmasta XT Webmasta XT is offline
 
Join Date: Mar 2002
Posts: 359
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
where can I get repair.php ?? whatever file freddie is talking about.. where can I get that?
Reply With Quote
  #14  
Old 04-12-2002, 12:45 AM
GuruXL's Avatar
GuruXL GuruXL is offline
 
Join Date: Feb 2002
Location: Queens, NY
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
the repair.php is in the zip, under the 'extras' folder
Reply With Quote
  #15  
Old 04-12-2002, 05:41 AM
Floris Floris is offline
 
Join Date: Jan 2002
Posts: 1,898
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #16  
Old 04-13-2002, 04:57 AM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by Scheccia
delete the space in excess in your database whit a click.
Optimize Table's space.
spaces??????
Reply With Quote
  #17  
Old 04-13-2002, 07:31 AM
Jawelin Jawelin is offline
 
Join Date: Nov 2001
Posts: 557
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
phpMyAdmin v2.2.4 + does the job, even.
Reply With Quote
  #18  
Old 04-13-2002, 12:37 PM
Webmasta XT's Avatar
Webmasta XT Webmasta XT is offline
 
Join Date: Mar 2002
Posts: 359
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
thnx GuruXL and xiphoid, time to optimize my database, lol
Reply With Quote
  #19  
Old 04-13-2002, 08:23 PM
Wolf42's Avatar
Wolf42 Wolf42 is offline
 
Join Date: Nov 2001
Location: Vienna, Austria, Europe
Posts: 150
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I installed it couse I like the integration to the AdminCP.
Reply With Quote
  #20  
Old 04-13-2002, 10:59 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #21  
Old 04-14-2002, 09:20 AM
Jawelin Jawelin is offline
 
Join Date: Nov 2001
Posts: 557
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
Reply
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 10:38 PM.

Contact Us - Archive - Top

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.09081 seconds
  • Memory Usage 2,297KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete