Tablespace left space automatic alert

[cyril vieville]

Hello everybody,

I have a question, maybe a stupid question but i didn't find the answer to ...
I'd like to schedule an automatic alert to avoid "table full" errors.
I have two versions of MySQL 4.1.20 & 5.0.45 and, on the two versions, i don't understand one thing... I read on a lot of forums and blogs that the only solution to know if there's a left space in a tablespace is the command "show table status". Is it true ?
When i write that command, i saw the comment column where was written "InnoDB free: 7168kb". Is it the left space of the table or of the whole tablespace ?

Is it possible to compare that result to the size of the datafiles?
My config is
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:50M:autoextend:max:2000M

but when i watch the explorer screen, i only saw a size of 223 232 ko for the fourth ibdata file, the one with autoextend option. So why did i get "7168kb free space" if 2 048 000 ko (max size) - 223 232 ko (current size) equals 1 824 768 ko free on the last datafile ?
Do i have to think it's the left space of the current size ?

Thx for answers



Edited 1 time(s). Last edit at 06/02/2008 11:26AM by cyril vieville.