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 databases

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