Page 1 of 1

Limit MySql table size

Posted: Sat Jan 01, 2005 8:39 am
by Clarkent
It's possible to limit (by PHP code) the size of a table ? E.g. My table users cannot contain more than 10 Mbyte.
It is possible to insert a little PHP script that verify the table (users) size and allows or not other INSERT ?

Thanks

Sory for my english

Posted: Sat Jan 01, 2005 9:04 am
by feyd
well.. here's how phpMyAdmin does it:

Code: Select all

SHOW TABLE STATUS LIKE 'table_name'
it then combines the data_length and index_length fields for the byte size used.