Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > General Hosting/Server Discussions
Reload this Page mysql table called 'post' vbulletin
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
mysql table called 'post' vbulletin Details »»
mysql table called 'post' vbulletin
Version: , by briank briank is offline
Developer Last Online: Feb 2009 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 10-02-2007 Last Update: Never Installs: 0
 
No support by the author.

Hi everyone,

The mysql table called 'post' vbulletin is ~250MB on my server. Is it supposed to be this large? I have 23,000 members, and 744,074 posts.

My forums are loading extremely slow. Could this be the cause of it?

Thanks in advance, everyone!

Show Your Support

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

Comments
  #2  
Old 10-03-2007, 01:36 AM
armatik armatik is offline
 
Join Date: Aug 2007
Location: Atlanta, GA
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
If you have 744,074 posts, that seems about right. Atleast, it would seem that it'd be pretty big, if you have that many posts.

Do you run any hacks/plugins? Those could be the reasons for your slow boards.
Reply With Quote
  #3  
Old 10-03-2007, 01:37 AM
briank briank is offline
 
Join Date: Nov 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I don't really run any hacks/mods. :/
Reply With Quote
  #4  
Old 10-03-2007, 01:46 AM
armatik armatik is offline
 
Join Date: Aug 2007
Location: Atlanta, GA
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I can't imagine this being the reason why your forums run slow. I mean, I'm not an expert on how this caching stuff works, but I think that takes quite a bit of pressure off the database, and the post table size really shouldn't be affecting your forum all that much.

Alternatively, you could simply backup that table alone, prune around half your topics, and see if you notice any difference.
Reply With Quote
  #5  
Old 10-03-2007, 05:46 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
What's your site running on? A VPS? Dedicated?
Reply With Quote
  #6  
Old 10-03-2007, 01:37 PM
briank briank is offline
 
Join Date: Nov 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Servint.net - Signature VPS - 500 GB Monthly Transfer - 20 GB Storage - 2GB* Ram

2 GB Burst RAM
512 MB Guaranteed RAM
4 IP Addresses
Unlimited Domains
Unlimited User Accounts
CentOS 4 Operating System
cPanel and Plesk 8 Available
+more info
Reply With Quote
  #7  
Old 10-03-2007, 02:01 PM
Madspot Madspot is offline
 
Join Date: Aug 2007
Location: Columbus,Ohio
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
get a better server either canaca.net or sumthing
Reply With Quote
  #8  
Old 10-03-2007, 06:52 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Funny to see some people recommending switching hosts, before it is even clear what the problem is.
Reply With Quote
  #9  
Old 10-04-2007, 11:32 AM
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Are you running a memory cache?
Reply With Quote
  #10  
Old 10-14-2007, 03:43 AM
briank briank is offline
 
Join Date: Nov 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Eikinskjaldi View Post
Are you running a memory cache?
Not totally sure. We upgraded the server again and now we can hold 200 users online at once and its just a little bit slow when that happens.
Reply With Quote
Reply
Page 1 of 2 1 2

« 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 05:42 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.06901 seconds
  • Memory Usage 2,285KB
  • 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
  • (1)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
  • (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
  • (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_postinfo_query
  • fetch_postinfo
  • 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