Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 12-17-2015, 01:43 PM
MyMee MyMee is offline
 
Join Date: Dec 2015
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Is That Possible to separate forum category database ?

now i have 3GB Size on my table " post "
and MySQL become crash and need repair every weekend
is that possible or anyone can recode the vbulletin for make different table of database for each category ?.

Example :

table : post_categorycar
table : post_categorylounge
table : post_categorymobile
table : post_categoryjokes

i hope you understand what i mean
Reply With Quote
  #2  
Old 12-17-2015, 02:09 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If your server can't handle 3GB then there's another problem going on here. 3GB is not mind blowing high for the post table. Are you on shared hosting? VPS? Dedicated server?

Making a new table for each category is very wrong, vBulletin normalized the database for a reason.
And such modification is pretty much impossible, requires a lot of work.
Reply With Quote
  #3  
Old 12-17-2015, 02:15 PM
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Posts: 969
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave View Post
Making a new table for each category is very wrong, vBulletin normalized the database for a reason.
The vb database is not normalized, you don't need to look beyond the user table to see that.
Reply With Quote
  #4  
Old 12-17-2015, 02:19 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes I agree that they didn't normalize it to perfection, but I'm sure you know what I meant by that in this context.

Bit off-topic but a while ago I saw someone with a custom site that created a table for each customer with 30+ columns in each table.
Reply With Quote
  #5  
Old 12-17-2015, 02:23 PM
MyMee MyMee is offline
 
Join Date: Dec 2015
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave View Post
If your server can't handle 3GB then there's another problem going on here. 3GB is not mind blowing high for the post table. Are you on shared hosting? VPS? Dedicated server?

Making a new table for each category is very wrong, vBulletin normalized the database for a reason.
And such modification is pretty much impossible, requires a lot of work.
Quote:
Originally Posted by squidsk View Post
The vb database is not normalized, you don't need to look beyond the user table to see that.
Quote:
Originally Posted by Dave View Post
Yes I agree that they didn't normalize it to perfection, but I'm sure you know what I meant by that in this context.

Bit off-topic but a while ago I saw someone with a custom site that created a table for each customer with 30+ columns in each table.

because i have dream
possible make specific category of forum maintenance the database table
example : category JOKES have 2GB Size, and we close this this category, then we do the maintenance example analyze, repair etc. But other category still running smoothly.
Reply With Quote
  #6  
Old 12-17-2015, 02:25 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Unfortunately it's not an option to make a table for each category. You'll have to upgrade your current server situation and/or tune/optimize your (My)SQL server.
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 08:10 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.03965 seconds
  • Memory Usage 2,201KB
  • 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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete