size (in KB) of table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
phice
Moderator
Posts: 1416
Joined: Sat Apr 20, 2002 3:14 pm
Location: Dallas, TX
Contact:

size (in KB) of table

Post by phice »

I'm looking for the right query/php code to show the actual amount in KB of the data in a certain table/database.
Image Image
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

there may be other ways, this is one that I've used with MySQL 3.23

SHOW TABLE STATUS
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
User avatar
Johnm
Forum Contributor
Posts: 344
Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:

Post by Johnm »

Phice,
Were you able to figure this out? If not, I have a few ideas.


John M
Post Reply