i am facing a very strange problem with a table in my site that holds the record of bids. when my table statistics come the following ----------------- Space usage: Type Usage Data 65,516 Bytes Index 1,024 Bytes Total 66,540 Bytes -----------
Row Statistics: Statements Value Format dynamic Collation latin1_swedish_ci Rows 570 Row length ø 114 Row size ø 117 Bytes Creation May 01, 2005 at 08:55 PM Last update Oct 08, 2005 at 07:53 AM Last check Oct 07, 2005 at 06:28 PM -----------------
then it stops working and when user place bids so it doesnt take more date and gives the following error
the table TABLE NAME is full
and my customer cant place bid.... pls help me why is so happening i never put any check on my tables size and there is enough space left for my database then why is this happening and please note that when i remove some rows from the tb then it again start working .......
i am using MySQL DB, --> lastnight i executed Table Repair and Table Optimize queries and after sometime table started working again.... then after five hours it again corrupted and now giving the same error again i.e TABLE IS FULL...and now i executed the same two queries again but this time its not working,,,
i suspect its something from HOST, their server goes down and my table is corrupted,,,do u agree?