Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2003, 10:55 AM
maoz440 maoz440 is offline
 
Join Date: Nov 2002
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Reducing huge mysql database size?

My forum's database (mysql) is almost 6 gigs - huge in my opinion. Is anyone else's this big? Any ideas on what the optimal database size is? We have 400,000+ posts. Any ideas on how to trim this down considerablely would be greatly appreciated!

maoz
Reply With Quote
  #2  
Old 03-05-2003, 11:00 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

1. well, adjusting the badwords.php can help

2. don't allow attachments.

3. increase the minimun letter count of words to search for...

after 1 and 3 you have to reindex the searchindex
Reply With Quote
  #3  
Old 03-05-2003, 11:03 AM
maoz440 maoz440 is offline
 
Join Date: Nov 2002
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the speedy response Xenon! How hard would it be to go into phpmyadmin and delete all attachments over 60 days old in certain forums? I am still learning phpmyadmin and am a little leary of it still.

maoz
Reply With Quote
  #4  
Old 03-05-2003, 11:15 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[sql]DELETE FROM attachment WHERE dateline<xxxx[/sql]

just replace the datline with the unixtimestamp of a day 60 days ago

this would delete all attachments older than that date, but if you want it just in a specific forum, it would be harder, you'd have to write a script which gets the postids of those forums and so on and so on, just with phpmyadmin i think it isn't possible
Reply With Quote
  #5  
Old 03-05-2003, 11:41 AM
Kars10's Avatar
Kars10 Kars10 is offline
 
Join Date: Jun 2002
Location: Germany/Franken
Posts: 748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Another small help for you: prune inactive users and delete old posts.
Reply With Quote
  #6  
Old 03-05-2003, 12:10 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

damn, old posts and i forgot to mention my archiv hack which compresses old threads in the db
Reply With Quote
  #7  
Old 03-05-2003, 03:31 PM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Cutting down on spammers can help too. And removing any unnecessary profile fields. Disabling the calendar in the ACP. The list goes on. Disabling Private Messages is the best way IMO

Xenon - how can adjusting badwords.php help ??

- miSt
Reply With Quote
  #8  
Old 03-05-2003, 04:15 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Mist, just edit the file, and you will see

there should be words in it, which are often on your forum, that's why it should be translated if you have a nonenglish board
Reply With Quote
  #9  
Old 03-05-2003, 06:19 PM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ahh i see now

- miSt
Reply With Quote
  #10  
Old 03-06-2003, 02:18 PM
maoz440 maoz440 is offline
 
Join Date: Nov 2002
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Xenon
[sql]DELETE FROM attachment WHERE dateline<xxxx[/sql]

just replace the datline with the unixtimestamp of a day 60 days ago

this would delete all attachments older than that date, but if you want it just in a specific forum, it would be harder, you'd have to write a script which gets the postids of those forums and so on and so on, just with phpmyadmin i think it isn't possible
Would running this query, and thus deleting all attachments older than 60 days screw up the database or the forums in any way or is this the only query/step I would need to perform?

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes

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 06:33 PM.


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.05172 seconds
  • Memory Usage 2,243KB
  • Queries Executed 11 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)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