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

Reply
 
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
  #2  
Old 04-10-2002, 11:41 PM
Dade's Avatar
Dade Dade is offline
 
Join Date: Jan 2002
Location: California
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'll try this out, thanks!
Reply With Quote
  #3  
Old 04-10-2002, 11:53 PM
Kumaro's Avatar
Kumaro Kumaro is offline
 
Join Date: Oct 2001
Location: T.O
Posts: 122
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i dont' understand what this does? does it speed up your board or something? minimize the size of your DB?
Reply With Quote
  #4  
Old 04-11-2002, 12:18 AM
Freddie Bingham's Avatar
Freddie Bingham Freddie Bingham is offline
 
Join Date: Oct 2001
Posts: 506
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

repair.php will do the same thing.
Reply With Quote
  #5  
Old 04-11-2002, 12:20 AM
Dade's Avatar
Dade Dade is offline
 
Join Date: Jan 2002
Location: California
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 04-11-2002, 12:23 AM
Scheccia Scheccia is offline
 
Join Date: Jan 2002
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 04-11-2002, 01:04 AM
hypedave's Avatar
hypedave hypedave is offline
 
Join Date: Nov 2001
Location: Dallas, Tx
Posts: 320
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #8  
Old 04-11-2002, 01:06 AM
Freddie Bingham's Avatar
Freddie Bingham Freddie Bingham is offline
 
Join Date: Oct 2001
Posts: 506
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I wrote repair.php and it has the same OPTIMIZE table commands that this script has in addition to CHECK and REPAIR.
Reply With Quote
  #9  
Old 04-11-2002, 01:07 AM
hypedave's Avatar
hypedave hypedave is offline
 
Join Date: Nov 2001
Location: Dallas, Tx
Posts: 320
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hey thats cool
Reply With Quote
  #10  
Old 04-11-2002, 01:34 AM
diettalk's Avatar
diettalk diettalk is offline
 
Join Date: Jan 2002
Location: Maryland
Posts: 109
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ]
Reply With Quote
Reply


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 12:35 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05894 seconds
  • Memory Usage 2,287KB
  • Queries Executed 23 (?)
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
  • (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
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)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