vb.org Archive

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.

Nocturnal222 07-10-2011 09:15 AM

Quote:

Originally Posted by cellarius (Post 2218852)
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.

if it has the same result / same overhead - what will i do?

cellarius 07-10-2011 10:21 AM

Then you need to sort it out with your host. It's likely not a vbulletin problem.

Disasterpiece 07-10-2011 10:56 AM

When you use xampp, there should be a phpmyadmin included. I'm not sure how to administer a xampp, until today I had the impression xampp was only usable for development environment, I've never seen live forums running on it...

The wrong values might come from this unusual productive environment. I can't help much with webservers running on a linux machine.
You or your admin will have to sort this out by yourselves. If you can't get phpmyadmin running from xampp control panel, try to download it from here, extract it somewhere and login with your database credentials: http://www.phpmyadmin.net/home_page/downloads.php

Nocturnal222 07-10-2011 03:35 PM

thank you very much sirs..
i will forward this to my admin.

miss lynne, any suggestion?

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

Another question,

if we manage to get phpmyadmin working we can repair and optimize table from there? is vbulletin repair and optimize not working properly?

Nocturnal222 07-12-2011 06:32 AM

bump???

cellarius 07-12-2011 08:04 AM

vB repair does the same as phpMyadmin repair. Checking with phpMyAdmin is to rule out its a vB problem. As I've told you before, you need to sort this out with whoever admins your server. And bumping threads is not going to help you...

Disasterpiece 07-12-2011 08:05 AM

vbulletin repair uses the same methods phpmyadmin is using.

However, I suspect that phpmyadmin will show the correct overhead values, since yours from the first post doesn't seem to be correct. It's just way too much.

Nocturnal222 07-14-2011 03:07 PM

Quote:

Originally Posted by cellarius (Post 2219564)
vB repair does the same as phpMyadmin repair. Checking with phpMyAdmin is to rule out its a vB problem. As I've told you before, you need to sort this out with whoever admins your server. And bumping threads is not going to help you...

you mean the server's host?
sorry a bit noob here :D

-maldita

cellarius 07-15-2011 03:26 AM

Yes.

Nocturnal222 07-21-2011 04:42 AM

thank you sirs


All times are GMT. The time now is 02:23 PM.

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.01198 seconds
  • Memory Usage 1,758KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (20)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete