I missed attaching the trace file!
Sorry !!
Regards,
Sp.Raja
> ------------Original Message------------
> From: "Sp.Raja" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Date: Wed, Mar-3-2004 1:13 PM
> Subject: Innodb table space getting filled up without any increase in actual rows!!
>
> 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]
>
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
Update_time | Check_time | Create_options | Comment |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| axactivealarmtbl | InnoDB | Dynamic | 467 | 210 | 98304 |
NULL | 98304 | 0 | NULL | NULL | NULL |
NULL | | InnoDB free: 9216 kB |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
Update_time | Check_time | Create_options | Comment |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| axactivealarmtbl | InnoDB | Dynamic | 4946 | 321 | 1589248 |
NULL | 622592 | 0 | NULL | NULL | NULL |
NULL | | InnoDB free: 6144 kB |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
Update_time | Check_time | Create_options | Comment |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| axactivealarmtbl | InnoDB | Dynamic | 5873 | 270 | 1589248 |
NULL | 851968 | 0 | NULL | NULL | NULL |
NULL | | InnoDB free: 5120 kB |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
Update_time | Check_time | Create_options | Comment |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| axactivealarmtbl | InnoDB | Dynamic | 6774 | 234 | 1589248 |
NULL | 1998848 | 0 | NULL | NULL | NULL |
NULL | | InnoDB free: 4096 kB |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
Update_time | Check_time | Create_options | Comment |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| axactivealarmtbl | InnoDB | Dynamic | 6735 | 235 | 1589248 |
NULL | 2031616 | 0 | NULL | NULL | NULL |
NULL | | InnoDB free: 4096 kB |
+------------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
+------------------+--------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
Update_time | Check_time | Create_options | Comment |
+------------------+--------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+
| axactivealarmtbl | InnoDB | Dynamic | 12117 | 217 | 2637824 |
NULL | 2048000 | 0 | NULL | NULL | NULL |
NULL | | InnoDB free: 3072 kB |
+------------------+--------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+----------------+----------------------+--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
