Hi,
I need to manage Innodb Tablespace very effectively from my application. To do that I
require clear picture of Innodb tablespace file and its organization. My application
needs to do the following
1. backup/restore of databases
While doing so should calculate the size of source database, and check it against
free space available in data directory. How do I calculate this figure for InnoDB
databases
2. Free-Disk Space controlled inserts
My application uses two databases normal and faults. I have to restrict faults
database in disk size. At present if I have huge number of faults, fault database eats
away the disk space(ibdata) and normal is not able to insert. I want to restrict disk
space occupied by fault database(say, it can take max 5MB), how do I do it?
3. Innodb reaches table full soon.
My system has only 50 MB Flash partition, where I have to store data. Innodb logs
occupy 10MB and other files (.frm) occupies 10MB more, which leaves 30MB for ibdata
file. Transactions return back table full when about 6000 rows are inserted to them.
but show table status reports 3072KB free against the table name. Why is this
contradiction?
SHOW TABLE STATUS FROM Agora LIKE 'objects'
| 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 |
| objects | InnoDB | Dynamic | 6054 | 955 | 5783552 |
NULL | 0 | 0 | NULL | NULL | NULL
| NULL
| | InnoDB free: 3072 kB |
Any Help will be greatly appreciated.
Thanks a lot,
Sp.Raja
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
