vb.org Archive - mysql table called 'post' vbulletin

Page 1 of 2

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

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

- General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)

- - mysql table called 'post' vbulletin (https://vborg.vbsupport.ru/showthread.php?t=159332)

briank

10-02-2007 11:22 PM

mysql table called 'post' vbulletin

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!

armatik

10-03-2007 01:36 AM

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.

briank

10-03-2007 01:37 AM

I don't really run any hacks/mods. :/

armatik

10-03-2007 01:46 AM

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.

Dismounted

10-03-2007 05:46 AM

What's your site running on? A VPS? Dedicated?

briank

10-03-2007 01:37 PM

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

Madspot

10-03-2007 02:01 PM

get a better server either canaca.net or sumthing

Marco van Herwaarden

10-03-2007 06:52 PM

Funny to see some people recommending switching hosts, before it is even clear what the problem is.

Eikinskjaldi

10-04-2007 11:32 AM

Are you running a memory cache?

briank

10-14-2007 03:43 AM

Quote:

Originally Posted by Eikinskjaldi (Post 1352740)

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.

All times are GMT. The time now is 11:48 PM.

Page 1 of 2

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01092 seconds Memory Usage 1,728KB 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 (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)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: