vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Overhead; Double Posts (https://vborg.vbsupport.ru/showthread.php?t=266562)

Nocturnal222 07-10-2011 06:44 AM
Overhead; Double Posts
 
1 Attachment(s)
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

Disasterpiece 07-10-2011 06:51 AM
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?

Nocturnal222 07-10-2011 07:00 AM
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

Disasterpiece 07-10-2011 07:05 AM
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.

Nocturnal222 07-10-2011 07:27 AM
Quote:
Originally Posted by Disasterpiece (Post 2218822)
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?

cellarius 07-10-2011 07:38 AM
Look up the values in phpMyAdmin.

Nocturnal222 07-10-2011 07:43 AM
Quote:
Originally Posted by cellarius (Post 2218835)
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? :D

cellarius 07-10-2011 07:45 AM
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.

Nocturnal222 07-10-2011 07:47 AM
Quote:
Originally Posted by cellarius (Post 2218838)
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

cellarius 07-10-2011 09:07 AM
Quote:
Originally Posted by Nocturnal222 (Post 2218839)
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.


All times are GMT. The time now is 03:54 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01228 seconds
  • Memory Usage 1,737KB
  • 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
  • (5)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