Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 03-28-2005, 08:45 AM
duskette duskette is offline
 
Join Date: Oct 2004
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default mysql clogging up after mig from ipb1.31final to vb3.0.7

My phpinfo: refer to attached doc.

My server specs:

P4 3.0GHZ 'E' HT
2 x 160 SATA 7200rpm 8MB Cache/ RAID 1
3ware Escalade 2 port hardware raid 1 controller.
2 x 1GB PC400 DDR RAM.
RHEL3 ES V.3


Using it as dedicated server for my site. www.singaporebikes.com
there are a small handful of sites residing in it but relatively small in size and doesn't cost much load.

Currently running IPB1.31final and my database is 1.6GB with 3344517 records. Post table is 1.4GB with 1569256 records.

After i import everything except attachments over to vb3, my database is 0.9GB with 4664609 records. Post table is 642.8MB with 1533447 records.

Please refer to the attached my_cnf.doc for my mysql configuration.

Only installed vbadvanced CMPS portal.
No hacks done.
Template using power blue template.
done some modifications to place banners using phpadsnew via javascript remote invocation.
view it here at http://www.singaporebikes.com/forum_vb3/index.php (ignore the images not loading as i merely renamed the folder)

Once the site goes live, concurrent users around 150+ members and via SSH, mysqladmin status showed the queries clogging to 50+ queries and flunctuating to 100+queries and back & fro. Site is extremely slow at this stage.

A view of the TOP command via ssh showed a healthy load and mem is adequate, no swap used yet. Static pages load up fairly quick. Only SQL dependant pages are clogging up.

Any help on this please? Thanks in advance.
Attached Files
File Type: doc my_cnf.doc (4.3 KB, 2 views)
File Type: doc phpinfo.doc (52.3 KB, 2 views)
Reply With Quote
  #2  
Old 03-28-2005, 08:53 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run your site in debug mode ($debug = 1; in your config.php) and check the query stats on each page.
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 01:27 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.03873 seconds
  • Memory Usage 2,182KB
  • Queries Executed 14 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_attachment
  • (2)postbit_onlinestatus
  • (2)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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete