Hi List, My tablespace is getting filled up so quick when no. of transactions increase without number of rows increasing considerably. I have a test client which adds and deletes row dynamically maintaining number of rows at any instant between 20 and 60. When I run this test client, after some time the client emits the following error:
"[MySQL][ODBC 3.51 Driver][mysqld-4.0.15a-debug]The table 'axactivealarmtbl' is full." I was confused on seeing this. So ran the test again but this time monitoring table status. I noticed that Rows, Data_length and Index_length column increased monotonically and InnoDB free decreased. I was not able to reason why ? But when I used select count(*) from <tablename> it consistently gave me numbers between 20 and 60 I have attached output of "show table status"(trace.txt) as I observed taken at increasing time. Any Pointers/Ideas on this to help me resolve this issue?? Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
