Hello.
On Fri 2002-09-13 at 02:42:16 -0400, [EMAIL PROTECTED] wrote:
> Benjamin Pflugmann wrote:
[...]
> > SHOW TABLE STATUS [FROM yourdatabase] [LIKE pattern]
> >
> > in order to see a overview of the tables including their resp. data
> > and index file sizes.
[...]
> That seems to do it. But I'm not sure what to use for a pattern.
Did you have a look at the appropriate manual section? You can specify
patterns as you would in for a LIKE in a WHERE clause, i.e. "_" means
"any char" and "%" means "any number of any chars".
It restricts the tables you want to inspect. E.g. if you only want to
see the tables "user_old" and "user_new", the following might to the
trick:
SHOW TABLE STATUS LIKE "user\_%"
("\_" escapes the "_" to mean a real "_" and not "any char" in this
case.)
> My first attempt I used the table name with a \G and got back some
> data. I'm guessing 'Data_length' is the size of the table? That's
> about right, since after installing phpMyAdmin, it gives me about
> the same number.
The manual is your friend:
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
which says that "Data_length" is the length of the data file,
i.e. size of the the .MYD file which is what you probably mean with
"size of the table".
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
