[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: Finding Table and  database size
From:       "Dan Muey" <dmuey () infiniplex ! com>
Date:       2003-07-31 16:12:10
[Download RAW message or body]

> Hello Dan,
> 
> Probably the reason that no-one has replied to you is that 
> on-one feels that they have anything helpful to add to what 
> you already know. A quick check on my system shows that the 
> data and index sizes reported by SHOW TABLE STATUS are the 
> same as the byte sizes of the MYD and MYI files - which is a 
> clue that they may represent the table sizes in bytes. 
> Whether this also applies to InnoDB tables, I have no idea.
> 

Excellent

> SImply checking the manual page 
> http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html will show 
> that there is no syntax for selecting only a few columns from 
> the SHOW STATUS. The fact that no-one else has replied 
> suggests that there is no alternative command. However, 
> unless your number of tables is prodigious, the extra data 
> transferred is hardly likely to be prodigious.

I figured that, I'll just have to loop around in my function and add it all up.

> 
> If you phrase your question in the style "please tell me 
> more", then you must accept that silence means that there is 
> no more to tell. If this list cannot answer your question, 
> your only alternative is to purchase support from MySQL AB 
> (always a good idea) , and then enquire of the fount of all
> (MySQL) knowledge.
> 
>       Alec

Right on,
Thanks Alec

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]