RE: MySQL db size using "show table status"

2005-09-12 Thread Martijn van den Burg
> > Qus 2. Is there any other way to compute the db size (other > than disk > > quota). > > > > du -s mysql_data_directory If you want to know the size of a /single/ database (i.e. schema) then this method works if there's just one database in the mysql_data_directory. If there are multiple da

Re: MySQL db size using "show table status"

2005-09-11 Thread Josh Chamas
Jaspreet Singh wrote: Hi, I am trying to compute the MySQL db size using "show table status" command. It gives me the size of .MYD and .MIY files, but not .frm which is typically 12k (using 4.1.9 version of MySQL) Qus 1. is there any way to deterministically compute the value of .frm file usi