mysql size

[namvo]

Hello,

Could anyone show me how to get the size of a database together with how to set the database size when create a new db??

In SQL server, it's pretty easy but it seems complicated in Mysql.

Thanks for your help.

 

[Deleted]

% show table status

http://unixjunky.com

 

[namvo]

Thanks for your response. Maybe i wasn't clear in the 1st post, i need to know how to write the sql statement to get the db size only.

As i know that Mysql db size = table size + index, but since i dont' have mysql knowledge, don't know what to write.

 

[namvo]

ok i found a help at

http://www.google.com/search?hl=en&q=mysql+database+size

(first link)

My next question is how to set the disk quota(or size quota) for a database ??