thanks for your help, i have read the vararies through mysqld, there's no the varary defining the max_space of a certern database.i think it's important defect in mysql. i can define how much space will be dispensed to a database,and show how much space have been used to my database user. In sql server i can do it with a stored precedure . yin du