XxWickedxX Posted January 10, 2009 Share Posted January 10, 2009 Here is the message I am getting when visiting my website. I have not been doing any work on it so I have not caused it by changing anything. Why would this table mysteriously crash and how would I go about fixing it.. I am going into look at my db now to see if any one click solutions are available. 1194 - Table 'whos_online' is marked as crashed and should be repaired delete from whos_online where time_last_click < '1231550391' [TEP STOP] Here is some Server information Operation System : Debian GNU/Linux MySQL Version : mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i386) using readline 5.0 Currently using PHP4 for lack of being able to upgrade my version of osc for php5 Link to comment Share on other sites More sharing options...
XxWickedxX Posted January 10, 2009 Author Share Posted January 10, 2009 I am not real DB savvy but the only thing I see showing a warning flag is that the table has no Indexes defined. Warning No index defined! Should I define an index for it? I dont know if there ever was one of if there was why its crashed now? Link to comment Share on other sites More sharing options...
XxWickedxX Posted January 10, 2009 Author Share Posted January 10, 2009 Ok I clicked to optimize the table and it changed number of rows from 3 to 2 and lowered the overhead space usage from 20,000 and some bytes to 108 bytes. Everything seems to be in working order now.. Did this happen because the overhead space usage got to large? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.