Why the table gets deleted by the server in mysql? I have a table in mysql. I have one java application which will keep inserting the data into this table. So the size of the table grows drastically and at one point it gets deleted automatically by the mysql server. I am not sure about the reason yet. So please if anybody has come across this issue then please share the way to handle this, so that I can have my data preserved.

UPDATE

This is what I found in the sql log of the server.

&gt; 2013-11-27T15:07:39.285156Z    9 Query    SELECT s.Sql_Id
&gt;       ,s.Child_Number
&gt;       ,s.Executions
&gt;       ,s.Last_Active_Time
&gt;       ,s.User_Io_Wait_Time
&gt;       ,s.Object_Status
&gt;       ,s.Plan_Hash_Value FROM   V$sql s WHERE  s.Sql_Text LIKE 'SELECT /*+ FIRST_ROWS XX */ T1.SYNC_TIMESTMP, T1.CUSTNO, T1.XAFID_ID_IFX,
&gt; T1.XAFID_CLASSIFIED%' 2013-11-27T15:07:39.286132Z    9 Query  SHOW
&gt; WARNINGS 2013-11-27T15:08:08.791015Z    9 Query   select
&gt; @@session.tx_read_only
&gt; 2013-11-27T15:08:08.791992Z    9 Query    drop table devicedata 2013-11-27T15:08:08.926757Z    9 Query    SHOW WARNINGS
&gt; 2013-11-27T15:08:08.936523Z    9 Query    select @@session.tx_read_only


Thanks
Reading the log seems to make the problem fairly apparent:

2013-11-27T15:08:08.791992Z 9 Query drop table devicedata 


That's not mysql dropping the table.  That's your application dropping the table.

There's another line in the log that is very suspicious:

 ,s.Plan_Hash_Value FROM V$sql s WHERE s.Sql_Text LIKE 'SELECT /*+ FIRST_ROWS XX */ 


V$sql is not a valid table name, at least not without backticks.  It sounds like the application may be trying to build the table name from a string and building the string incorrectly... when that query fails, it drops the table in some kind of misguided attempt at "recovery."

Search the code for the word "drop."  MySQL has no concept of dropping a table because it's too full.