Go Back   vb.org Archive > Community Discussions > Forum and Server Management

Reply
 
Thread Tools Display Modes
  #11  
Old 05-10-2012, 03:31 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would suggest a server optimization.

You could raise your timeout's in my.cnf & restart sql.
Reply With Quote
  #12  
Old 05-10-2012, 03:39 PM
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Location: Manchester
Posts: 3,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It doesn't help with you obliterating the table and column calls in that sql, so we cant help you with that. You have probably got a poorly configured server, if you have eAccelerator enabled and you are running SuPHP you will find this simply doesn't work as intended. You'll certainly not see any performance benefits and depending how it's configured, you may find that it actually decreases performance and fills up your "/tmp/eaccelerator" folder with thousands of files. Opcode caching tools only work when running PHP scripts under DSO or similar. So that could be a reason for your server being full.
Reply With Quote
  #13  
Old 05-10-2012, 03:54 PM
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
Posts: 180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i rebuild server with out e Accelerator ... i wait to see result ...
Reply With Quote
  #14  
Old 05-10-2012, 04:02 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

As df shows on 12% usage on /tmp, this is not a tmp w/eac issue, the sql error is the problem at this point if it keeps sending out cant connect emails.
Reply With Quote
  #15  
Old 05-10-2012, 04:11 PM
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
Posts: 180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Invalid SQL:
SHOW CREATE TABLE postindex;

MySQL Error : Table './iecloob_db/postindex' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Thursday, May 10th 2012 @ 07:10:30 PM
Error Date : Thursday, May 10th 2012 @ 07:10:31 PM

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

Deprecated: Assigning the return value of new by reference is deprecated i

i upgrade php to new version but ... Deprecated ...
Reply With Quote
  #16  
Old 05-10-2012, 04:18 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Repair the table.

I would suggest you let/hire some one to fix the server correctly.
Reply With Quote
  #17  
Old 05-10-2012, 04:21 PM
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
Posts: 180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ?
Reply With Quote
  #18  
Old 05-10-2012, 04:29 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would suggest that your stop at this point, do NOT restart mysql at this point.

Repair that table from the cmd line via a shell.
Reply With Quote
  #19  
Old 05-10-2012, 04:30 PM
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Location: Manchester
Posts: 3,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you cant repair it you'll need to use ssh to find the postindex.TMD file and delete it, when i file is attempting to repair they make another temporary file, if the databse crashes for some reason when this is taking place it leaves that file unfinished, trying to repair again does nothing as that file still exists, i suggest you backup your postindex table as it is then via ssh find that file, delete it, and repair again, you could run the Check table or analyse table first, when you see the full text it will give you the name of the file that already exists.
Reply With Quote
  #20  
Old 05-10-2012, 04:33 PM
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
Posts: 180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i can not see tables via php my admin i click it .. it not open just send request

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

send my commant to do it ... plz
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 01:30 PM.


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.05660 seconds
  • Memory Usage 2,259KB
  • Queries Executed 13 (?)
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
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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
  • (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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete