Overhead; Double Posts

[Nocturnal222]

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]

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]

we have 3 forums

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

--------------- Added 1310285070 at 1310285070 ---------------

after I do repair/optimize

these are the results

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]

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]

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]

Look up the values in phpMyAdmin.

[Nocturnal222]

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]

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]

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 1310290215 at 1310290215 ---------------

this also shows

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


xxxx - just hiding it

-maldita

[cellarius]

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]

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]

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

[Disasterpiece]

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]

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

miss lynne, any suggestion?

--------------- Added 1310378641 at 1310378641 ---------------

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]

bump???

[cellarius]

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]

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]

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]

Yes.

[Nocturnal222]

thank you sirs