Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 07-10-2011, 06:44 AM
Nocturnal222 Nocturnal222 is offline
 
Join Date: Dec 2006
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Overhead; Double Posts

Please see attached.

Can anyone explain to me or tell me what should I do? (I always do Repair/Optimize Table)
The forum gets lag nowadays, i only installed a very few mods, but still it lags like hell.

Should a reboot be done?

Help pls :/

=maldita
Attached Images
File Type: png overhead.png (21.3 KB, 0 views)
Reply With Quote
  #2  
Old 07-10-2011, 06:51 AM
Disasterpiece's Avatar
Disasterpiece Disasterpiece is offline
 
Join Date: Apr 2007
Location: GER
Posts: 765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That doesn't look like these are the correct values... Does phpmyadmin also show this amount of overhead?

How big is your forum? posts/members?
Reply With Quote
  #3  
Old 07-10-2011, 07:00 AM
Nocturnal222 Nocturnal222 is offline
 
Join Date: Dec 2006
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

we have 3 forums

www.muonline.biz/fortress
www.muonline.biz/grudge
www.muonline.biz/zhyper

--------------- Added [DATE]1310285070[/DATE] at [TIME]1310285070[/TIME] ---------------

after I do repair/optimize

these are the results

Quote:
avatar Check Status: OK
avatar Optimize Note: Table does not support optimize, doing recreate + analyze instead
avatar Optimize Status: OK
bbcode Check Status: OK
bbcode Optimize Note: Table does not support optimize, doing recreate + analyze instead
bbcode Optimize Status: OK
bbcode_video Check Status: OK
bbcode_video Optimize Note: Table does not support optimize, doing recreate + analyze instead
bbcode_video Optimize Status: OK
block Check Status: OK
block Optimize Note: Table does not support optimize, doing recreate + analyze instead
block Optimize Status: OK
blockconfig Check Status: OK
blockconfig Optimize Note: Table does not support optimize, doing recreate + analyze instead
Reply With Quote
  #4  
Old 07-10-2011, 07:05 AM
Disasterpiece's Avatar
Disasterpiece Disasterpiece is offline
 
Join Date: Apr 2007
Location: GER
Posts: 765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can't believe 127mb overhead for EVERY(?) table is possible... Something goes terribly wrong there.
If phpmyadmin reports sane values, it might just be a minor issue causing the script to get wrong values.
Reply With Quote
  #5  
Old 07-10-2011, 07:27 AM
Nocturnal222 Nocturnal222 is offline
 
Join Date: Dec 2006
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Disasterpiece View Post
I can't believe 127mb overhead for EVERY(?) table is possible... Something goes terribly wrong there.
If phpmyadmin reports sane values, it might just be a minor issue causing the script to get wrong values.
what should i do?
Reply With Quote
  #6  
Old 07-10-2011, 07:38 AM
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Posts: 1,987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Look up the values in phpMyAdmin.
Reply With Quote
  #7  
Old 07-10-2011, 07:43 AM
Nocturnal222 Nocturnal222 is offline
 
Join Date: Dec 2006
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cellarius View Post
Look up the values in phpMyAdmin.
hello sir, i quite cant get it.. since i do not have access on that.. what should i tell my admin?

"Look up the values in phpMyAdmin".. errr.. then?
Reply With Quote
  #8  
Old 07-10-2011, 07:45 AM
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Posts: 1,987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Look up the Overheads in phpMyAdmin and compare them to the values you posted here. Just as you've been told. Further proceedeings depend on the result.
Reply With Quote
  #9  
Old 07-10-2011, 07:47 AM
Nocturnal222 Nocturnal222 is offline
 
Join Date: Dec 2006
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cellarius View Post
Look up the Overheads in phpMyAdmin and compare them to the values you posted here. Just as you've been told. Further proceedeings depend on the result.
sir, as what was told to me. We do not use phpMyAdmin.

--------------- Added [DATE]1310290215[/DATE] at [TIME]1310290215[/TIME] ---------------

this also shows

C:\xampp\htdocs\xxxxxxxxxx\xxxxxxx\class_core.php on line 414


xxxx - just hiding it

-maldita
Reply With Quote
  #10  
Old 07-10-2011, 09:07 AM
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Posts: 1,987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Nocturnal222 View Post
sir, as what was told to me. We do not use phpMyAdmin.
Then install it. It's a php script. If you can run vB, you can run phpMyadmin. If not, your admin will have other ways to find out about table overheads.
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 05: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.15353 seconds
  • Memory Usage 2,269KB
  • 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
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)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
  • (10)postbit
  • (1)postbit_attachment
  • (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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete