vb.org Archive - View Single Post

IRANCITY · #17 05-10-2012, 04:21 PM

Code:

Repair / Optimize Tables
Table 	Data Length 	Index Length 	Overhead 	Check All
access 	4.5 KB 	8.0 KB 	0 	Yes
action 	0 	1.0 KB 	0 	Yes
ad 	0 	1.0 KB 	0 	Yes
adcriteria 	0 	1.0 KB 	0 	Yes
adminhelp 	89.3 KB 	56.0 KB 	0 	Yes
administrator 	128 Bytes 	2.0 KB 	0 	Yes
adminlog 	306.0 KB 	77.0 KB 	0 	Yes
adminmessage 	104 Bytes 	5.0 KB 	0 	Yes
adminutil 	24 Bytes 	2.0 KB 	0 	Yes
album 	12.1 KB 	10.0 KB 	0 	Yes
albumpicture 	8.4 KB 	31.0 KB 	0 	Yes
albumupdate 	0 	1.0 KB 	0 	Yes
announcement 	5.3 KB 	4.0 KB 	0 	Yes
announcementread 	189 Bytes 	3.0 KB 	0 	Yes
attachment 	22.2 KB 	35.0 KB 	0 	Yes
attachmentcategory 	0 	1.0 KB 	0 	Yes
attachmentcategoryuser 	8.8 KB 	23.0 KB 	0 	Yes
attachmentpermission 	0 	1.0 KB 	0 	Yes
attachmenttype 	252 Bytes 	3.0 KB 	0 	Yes
attachmentviews 	0 	1.0 KB 	0 	Yes
automediaembed 	4.7 KB 	2.0 KB 	0 	Yes
avatar 	0 	1.0 KB 	0 	Yes
award 	1.7 KB 	2.0 KB 	0 	Yes
award_cat 	40 Bytes 	3.0 KB 	0 	Yes
award_user 	7.4 KB 	4.0 KB 	0 	Yes
bbcode 	0 	1.0 KB 	0 	Yes
bbcode_video 	2.7 KB 	5.0 KB 	0 	Yes
block 	0 	1.0 KB 	0 	Yes
blockconfig 	0 	1.0 KB 	0 	Yes
blocktype 	392 Bytes 	4.0 KB 	0 	Yes
bookmarksite 	780 Bytes 	2.0 KB 	0 	Yes
cache 	2.9 KB 	2.0 KB 	0 	Yes
cacheevent 	132 Bytes 	2.0 KB 	0 	Yes
calendar 	56 Bytes 	3.0 KB 	0 	Yes
calendarcustomfield 	0 	1.0 KB 	0 	Yes
calendarmoderator 	0 	1.0 KB 	0 	Yes
calendarpermission 	0 	1.0 KB 	0 	Yes
contentpriority 	0 	1.0 KB 	0 	Yes
contenttype 	420 Bytes 	3.0 KB 	0 	Yes
cron 	2.0 KB 	4.0 KB 	0 	Yes
cronlog 	867.6 KB 	269.0 KB 	0 	Yes
customavatar 	29.3 KB 	8.0 KB 	0 	Yes
customprofilepic 	18.1 KB 	7.0 KB 	0 	Yes
cyb_logintouser 	20 Bytes 	2.0 KB 	0 	Yes
cybvilxh_guests 	77.7 KB 	32.0 KB 	2.5 KB 	Yes
datastore 	1.02 MB 	2.0 KB 	0 	Yes
deletionlog 	519.5 KB 	249.0 KB 	0 	Yes
discussion 	2.3 KB 	3.0 KB 	0 	Yes
discussionread 	0 	1.0 KB 	0 	Yes
editlog 	150.6 KB 	49.0 KB 	0 	Yes
event 	124 Bytes 	6.0 KB 	0 	Yes
externalcache 	1.8 KB 	4.0 KB 	0 	Yes
faq 	1.8 KB 	4.0 KB 	0 	Yes
filedata 	14.19 MB 	37.0 KB 	0 	Yes
filedata122876 	14.19 MB 	37.0 KB 	0 	Yes
force_read_guests 	0 	1.0 KB 	0 	Yes
force_read_users 	1.7 KB 	5.0 KB 	0 	Yes
forum 	151.2 KB 	8.0 KB 	0 	Yes
forumpermission 	1,014 Bytes 	3.0 KB 	0 	Yes
forumprefixset 	640 Bytes 	2.0 KB 	0 	Yes
forumread 	0 	1.0 KB 	0 	Yes
groupmessage 	238.7 KB 	53.0 KB 	0 	Yes
groupmessage_hash 	35.7 KB 	40.0 KB 	0 	Yes
groupread 	0 	1.0 KB 	0 	Yes
holiday 	0 	1.0 KB 	0 	Yes
humanverify 	13.66 MB 	18.03 MB 	0 	Yes
hvanswer 	0 	1.0 KB 	0 	Yes
hvquestion 	40 Bytes 	2.0 KB 	0 	Yes
icon 	560 Bytes 	2.0 KB 	0 	Yes
imagecategory 	100 Bytes 	2.0 KB 	0 	Yes
imagecategorypermission 	0 	1.0 KB 	0 	Yes
indexqueue 	0 	1.0 KB 	0 	Yes
infraction 	1.1 KB 	7.0 KB 	0 	Yes
infractionban 	0 	1.0 KB 	0 	Yes
infractiongroup 	0 	1.0 KB 	0 	Yes
infractionlevel 	72 Bytes 	2.0 KB 	0 	Yes
language 	1.10 MB 	2.0 KB 	45.8 KB 	Yes
linkback 	0 	1.0 KB 	0 	Yes
mailqueue 	0 	1.0 KB 	0 	Yes
moderation 	110 Bytes 	3.0 KB 	0 	Yes
moderator 	663 Bytes 	3.0 KB 	0 	Yes
moderatorlog 	7.39 MB 	3.19 MB 	0 	Yes
music_album 	32 Bytes 	2.0 KB 	0 	Yes
music_artist 	28 Bytes 	2.0 KB 	0 	Yes
music_cat 	296 Bytes 	2.0 KB 	0 	Yes
music_comment 	0 	1.0 KB 	0 	Yes
music_logo 	0 	1.0 KB 	0 	Yes
music_news 	0 	1.0 KB 	0 	Yes
music_playlist 	168 Bytes 	2.0 KB 	0 	Yes
music_song 	572 Bytes 	2.0 KB 	0 	Yes
notice 	0 	1.0 KB 	0 	Yes
noticecriteria 	0 	1.0 KB 	0 	Yes
noticedismissed 	0 	1.0 KB 	0 	Yes
package 	28 Bytes 	3.0 KB 	0 	Yes
passwordhistory 	1.14 MB 	273.0 KB 	0 	Yes
paymentapi 	2.0 KB 	2.0 KB 	0 	Yes
paymentinfo 	0 	1.0 KB 	0 	Yes
paymenttransaction 	0 	1.0 KB 	0 	Yes
phpkd_maus 	112 Bytes 	2.0 KB 	0 	Yes
phrase 	3.11 MB 	959.0 KB 	64.9 KB 	Yes
phrasetype 	2.3 KB 	2.0 KB 	0 	Yes
picture 	25.80 MB 	17.0 KB 	0 	Yes
picturecomment 	13.4 KB 	10.0 KB 	0 	Yes
picturecomment_hash 	6.7 KB 	11.0 KB 	0 	Yes
picturelegacy 	4.1 KB 	7.0 KB 	0 	Yes
plugin 	268.4 KB 	8.0 KB 	133.4 KB 	Yes
pm 	740.7 KB 	1.13 MB 	0 	Yes
pmreceipt 	7.6 KB 	11.0 KB 	0 	Yes
pmtext 	47.49 MB 	838.0 KB 	0 	Yes
pmthrottle 	0 	1.0 KB 	0 	Yes
podcast 	0 	1.0 KB 	0 	Yes
podcastitem 	0 	1.0 KB 	0 	Yes
poll 	8.9 KB 	2.0 KB 	0 	Yes
pollvote 	11.8 KB 	25.0 KB 	0 	Yes
post 	866.66 MB 	19.70 MB 	0 	Yes
post_thanks 	6.36 MB 	4.27 MB 	0 	Yes
postedithistory 	43.65 MB 	277.0 KB 	0 	Yes
posthash 	343 Bytes 	3.0 KB 	0 	Yes
postindex 	0 	0 	0 	Yes
postlog 	378.8 KB 	117.0 KB 	226.3 KB 	Yes
postparsed 	21.69 MB 	455.0 KB 	17.53 MB 	Yes
prefix 	240 Bytes 	3.0 KB 	0 	Yes
prefixpermission 	720 Bytes 	2.0 KB 	0 	Yes
prefixset 	40 Bytes 	2.0 KB 	0 	Yes
product 	5.8 KB 	2.0 KB 	1.3 KB 	Yes
productcode 	132.7 KB 	3.0 KB 	96.8 KB 	Yes
productdependency 	408 Bytes 	2.0 KB 	100 Bytes 	Yes
profileblockprivacy 	20.9 KB 	23.0 KB 	0 	Yes
profilefield 	96 Bytes 	4.0 KB 	0 	Yes
profilefieldcategory 	0 	1.0 KB 	0 	Yes
profilevisitor 	168.0 KB 	380.0 KB 	68 Bytes 	Yes
ranks 	588 Bytes 	3.0 KB 	0 	Yes
reminder 	0 	1.0 KB 	0 	Yes
reputation 	0 	1.0 KB 	0 	Yes
reputationlevel 	135 Bytes 	3.0 KB 	0 	Yes
route 	24 Bytes 	4.0 KB 	0 	Yes
rssfeed 	0 	1.0 KB 	0 	Yes
rsslog 	83 Bytes 	3.0 KB 	0 	Yes
search 	63.9 KB 	4.0 KB 	61.7 KB 	Yes
searchcore 	0 	1.0 KB 	0 	Yes
searchcore_text 	0 	1.0 KB 	0 	Yes
searchgroup 	732.3 KB 	985.0 KB 	0 	Yes
searchgroup_text 	1.51 MB 	362.0 KB 	0 	Yes
searchlog 	184.7 KB 	7.0 KB 	0 	Yes
setting 	115.2 KB 	27.0 KB 	40.7 KB 	Yes
settinggroup 	2.8 KB 	4.0 KB 	180 Bytes 	Yes
sigparsed 	217.6 KB 	10.0 KB 	0 	Yes
sigpic 	380 Bytes 	2.0 KB 	0 	Yes
smilie 	51.0 KB 	4.0 KB 	0 	Yes
socialgroup 	5.3 KB 	10.0 KB 	160 Bytes 	Yes
socialgroupcategory 	280 Bytes 	3.0 KB 	0 	Yes
socialgroupicon 	840 Bytes 	2.0 KB 	40 Bytes 	Yes
socialgroupmember 	3.7 KB 	17.0 KB 	0 	Yes
socialgrouppicture 	286 Bytes 	4.0 KB 	0 	Yes
spamlog 	0 	1.0 KB 	0 	Yes
stats 	22.1 KB 	16.0 KB 	0 	Yes
strikes 	748 Bytes 	3.0 KB 	708 Bytes 	Yes
style 	188.9 KB 	2.0 KB 	70.7 KB 	Yes
stylevar 	41.8 KB 	17.0 KB 	0 	Yes
stylevardfn 	20.9 KB 	19.0 KB 	0 	Yes
subscribediscussion 	15 Bytes 	4.0 KB 	0 	Yes
subscribeevent 	21 Bytes 	4.0 KB 	0 	Yes
subscribeforum 	481 Bytes 	4.0 KB 	0 	Yes
subscribegroup 	84 Bytes 	4.0 KB 	0 	Yes
subscribethread 	223.9 KB 	424.0 KB 	0 	Yes
subscription 	0 	1.0 KB 	0 	Yes
subscriptionlog 	0 	1.0 KB 	0 	Yes
subscriptionpermission 	0 	1.0 KB 	0 	Yes
tachyforumcounter 	0 	1.0 KB 	0 	Yes
tachyforumpost 	0 	1.0 KB 	0 	Yes
tachythreadcounter 	0 	1.0 KB 	0 	Yes
tachythreadpost 	0 	1.0 KB 	0 	Yes
tag 	1.96 MB 	2.84 MB 	0 	Yes
tagcontent 	3.23 MB 	9.43 MB 	0 	Yes
tagsearch 	888.9 KB 	1.19 MB 	291.9 KB 	Yes
tagthread 	8.21 MB 	18.13 MB 	0 	Yes
template 	5.64 MB 	60.0 KB 	2.62 MB 	Yes
templatehistory 	215.9 KB 	3.0 KB 	0 	Yes
templatemerge 	0 	1.0 KB 	0 	Yes
thread 	14.91 MB 	4.94 MB 	0 	Yes
thread_serviceupdate 	0 	1.0 KB 	0 	Yes
threadrate 	186.2 KB 	159.0 KB 	0 	Yes
threadread 	0 	1.0 KB 	0 	Yes
threadredirect 	36 Bytes 	3.0 KB 	36 Bytes 	Yes
threadviews 	315 Bytes 	2.0 KB 	0 	Yes
upgradelog 	2.9 KB 	2.0 KB 	0 	Yes
user 	5.21 MB 	2.28 MB 	0 	Yes
useractivation 	216 Bytes 	3.0 KB 	216 Bytes 	Yes
userban 	5.1 KB 	3.0 KB 	0 	Yes
userchangelog 	79.8 KB 	110.0 KB 	0 	Yes
usercss 	32.8 KB 	33.0 KB 	0 	Yes
usercsscache 	60.8 KB 	2.0 KB 	0 	Yes
userfield 	546.5 KB 	270.0 KB 	0 	Yes
usergroup 	2.7 KB 	2.0 KB 	0 	Yes
usergroupleader 	0 	1.0 KB 	0 	Yes
usergrouprequest 	0 	1.0 KB 	0 	Yes
userlist 	77.2 KB 	287.0 KB 	0 	Yes
usernote 	65.6 KB 	4.0 KB 	0 	Yes
userpromotion 	0 	1.0 KB 	0 	Yes
usertextfield 	1.82 MB 	270.0 KB 	0 	Yes
usertitle 	771 Bytes 	2.0 KB 	0 	Yes
vbseo_blacklist 	20 Bytes 	3.0 KB 	0 	Yes
vbseo_likes 	330.2 KB 	256.0 KB 	0 	Yes
vbseo_linkback 	827.2 KB 	175.0 KB 	0 	Yes
vbseo_serviceupdate 	714.5 KB 	464.0 KB 	0 	Yes
visitormessage 	14.87 MB 	3.04 MB 	0 	Yes
visitormessage_hash 	0 	1.0 KB 	0 	Yes
word 	94.71 MB 	51.68 MB 	0 	Yes

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

tables cannot fix .... broweser just send request but no action show !

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

postindex 0 0 0 !!!! is it clear ?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01098 seconds Memory Usage 1,800KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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 showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: