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.
This is what I found in the sql log of the server.
> 2013-11-27T15:07:39.285156Z 9 Query SELECT s.Sql_Id > ,s.Child_Number > ,s.Executions > ,s.Last_Active_Time > ,s.User_Io_Wait_Time > ,s.Object_Status > ,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, > T1.XAFID_CLASSIFIED%' 2013-11-27T15:07:39.286132Z 9 Query SHOW > WARNINGS 2013-11-27T15:08:08.791015Z 9 Query select > @@session.tx_read_only > 2013-11-27T15:08:08.791992Z 9 Query drop table devicedata 2013-11-27T15:08:08.926757Z 9 Query SHOW WARNINGS > 2013-11-27T15:08:08.936523Z 9 Query select @@session.tx_read_only