vb.org Archive - Nightly Database Optimizer

Page 3 of 5

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Nightly Database Optimizer (https://vborg.vbsupport.ru/showthread.php?t=67711)

Gamingforce

07-30-2004 04:12 AM

Okay I did a fun stress test earlier today running the Optimize command for 20,000 times on the heavily accessed/updated USER table with 200+ concurrent users on my board and no problems at all. :)

TCS: Repair is built into Optimize. No need to run both. :)

pixelpunk

07-31-2004 11:19 PM

what would it take for this script to turn the board off between time A and time B and possibly give the admin the choice to run it on certain days?

It'd be much like eBay (among other sites) closing for maintainence.

TheComputerGuy

08-01-2004 12:47 AM

Installed...but pixelpunk has a great idea!

Gamingforce

08-01-2004 01:27 AM

There is no need to close the board. It's just downtime for your users. vBulletin's CRON system doesn't allow you to select more than one day a week, but I can work around that by having the script run daily, but instead run the code within it only on certain days. I'll look into that.

TheComputerGuy

08-01-2004 01:29 AM

Quote:

Originally Posted by Gamingforce

There is no need to close the board. It's just downtime for your users.

True, I just thought since it would be a dead time on the board anyways...it would no matter

Gamingforce

08-01-2004 01:30 AM

If it's a dead time, then why close it?

TheComputerGuy

08-01-2004 02:53 AM

Quote:

Originally Posted by Gamingforce

If it's a dead time, then why close it?

exactly. great point sir!

pixelpunk

08-03-2004 08:07 AM

Statistics can't predict exactly when someone will post during your boards 'dead time.'

There is still that risk of the database becoming corrupt because someone's inserting data into it while it's optimizing so why not kill it 100% just to be safe.

Still a kickin-rad hack though! Thanks GamingForce.

Ghostsuit

08-03-2004 02:24 PM

Quote:

Originally Posted by Gamingforce

The optimization happens at off peak times and content is still accessible during the optimization process. I have a board with almost a million posts and it works fine.

Ahh cool sounds good then :)

Gamingforce

08-03-2004 09:37 PM

Quote:

Originally Posted by pixelpunk

I really do think it's 100% safe because MySQL locks the table from updates/inserts while it's optimizing it.

All times are GMT. The time now is 07:05 AM.

Page 3 of 5

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01135 seconds Memory Usage 1,733KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: