RE: Determining Database size via SQL

2001-05-28 Thread Chris Bolt
If you are using only fixed-length (no VARCHARs, TEXTs or BLOBs) MyISAM tables you can calculate it by finding the storage required for each row (http://www.mysql.com/doc/S/t/Storage_requirements.html) and multiplying it by the number of rows. If you are using variable-length MyISAM tables, you sh

Determining Database size via SQL

2001-05-28 Thread Scott Pawluk
I need a way to determine the size of a single database on mySQL via an SQL command. I am running an application on a service provider that gives me a limited amount of database space for my application. I want to be able to gauge the percentage of that space that I am using. The only access I