Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
Reload this Page Browsing is fast; posting slow - what size does replicatin make sense?
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
Browsing is fast; posting slow - what size does replicatin make sense? Details »»
Browsing is fast; posting slow - what size does replicatin make sense?
Version: , by moondragon13 moondragon13 is offline
Developer Last Online: Oct 2012 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 07-05-2007 Last Update: Never Installs: 0
 
No support by the author.

Hello,

I am starting to experience a lag (10 seconds or more) in posting on my forum and I believe it could be due to the amount of traffic at a given time that is on the server trying to post messages. Browsing the forum is quick and most pages load in the time it takes to verbally say "1 - 1,000" so about a second to 2 seconds top.

In your experience at what level do you start to see a need to have two databases? One for inserts and the other for the select queries?

I am running MySQL 4.1.20 and will be upgrading to MySQL 5 soon. Will this help?

Show Your Support

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

Comments
  #2  
Old 07-05-2007, 11:30 AM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Request server optimization over at vb.com in the server forum before you do anything at all.
Reply With Quote
  #3  
Old 07-05-2007, 01:39 PM
moondragon13 moondragon13 is offline
 
Join Date: Dec 2005
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
orban,

Thanks for the reply. I will look into that. I can say that my Hardware should more than handle it. A Dell 6650 with 6GB ram and 4 multi-threaded CPUs with multi-threaded apache installed. I am going to move the db to its own machine this week too.

I had vB 3.0 two weeks ago with no problem. Upgraded to 3.6 and the problems started. Is there more overhead now in 3.6?
Reply With Quote
  #4  
Old 07-05-2007, 01:44 PM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Oh wow?!

How many users online and how many posts do you have? That's a crazy machine
Reply With Quote
  #5  
Old 07-06-2007, 06:41 AM
moondragon13 moondragon13 is offline
 
Join Date: Dec 2005
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
orban,

Not enough to make this machine sweat but all my users are complaining and I agree with them. It can take 30 seconds to post a message and it has to be MySQL related.

I have about 1.8 million post. On a peak 300 - 400 users.

I have requested support at vB.com and no answers yet.
Reply With Quote
  #6  
Old 07-06-2007, 11:23 AM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
moondragon, you can run 300-400 users on a much much much smaller machine. Also how large is your db?

There is absolutely no need to move to a two machine setup for these numbers.
Reply With Quote
  #7  
Old 07-06-2007, 05:59 PM
moondragon13 moondragon13 is offline
 
Join Date: Dec 2005
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
orban,

I agree 100%, you wouldn't believe the complaints I am getting now though. I will PM you the URL to see if you see the same "slowness" they are talking about.

My db is about 750MB.
Reply With Quote
  #8  
Old 07-06-2007, 06:14 PM
Yellow Slider Yellow Slider is offline
 
Join Date: Aug 2006
Posts: 249
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I'm experiencing slowness too, my DB is 920 MB and the DB collection is UTF8,
i've installed xcache+xcache modofication and it helped a little, also the template cache plugin, try those..

which plugins do you have installed?
Reply With Quote
  #9  
Old 07-06-2007, 06:18 PM
moondragon13 moondragon13 is offline
 
Join Date: Dec 2005
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Yellow Slider View Post
I'm experiencing slowness too, my DB is 920 MB and the DB collection is UTF8,
i've installed xcache+xcache modofication and it helped a little, also the template cache plugin, try those..

which plugins do you have installed?
Zero, I stripped them all to send vB a support ticket. Things seem to be running better now that I have MySQL 5
Reply With Quote
  #10  
Old 07-06-2007, 06:38 PM
mtlcore mtlcore is offline
 
Join Date: Jul 2005
Posts: 265
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I would love to browse your site sicne you mentioned it is running on a beast-like machine.
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 11:12 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.04589 seconds
  • Memory Usage 2,284KB
  • 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_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