List:Internals« Previous MessageNext Message »
From:Antony T Curtis Date:June 8 2001 1:51pm
Subject:Re: mysqlshow.c - Modifications - 2nd Try
View as plain text  
Markus Grundmann wrote:

Such a feature as this would have to be a "optional" rather than
default.

I wouldn't want it to open 400+ tables in a database to find out how
many million rows there are...

> 
> Two additional columns view more database/table details.
> 
> Example:
> 
> TRINITRON# mysqlshow <-- show all databases
> +---------------+--------+------------+
> |   Databases   | Tables | Total Rows |
> +---------------+--------+------------+
> | activezone    |     18 |       4727 |
> | bennini       |      - |          - |
> | clientstats   |      3 |          1 |
> | collin        |      - |          - |
> | domains       |      1 |         21 |
> | em2000        |      5 |       1108 |
> | foerster      |      - |          - |
> +---------------+--------+------------+
> 
> .. and ..
> 
> TRINITRON# mysqlshow activezone   <-- Show details of "activezone"
> Database: activezone
> +-------------+------------+
> |   Tables    | Total Rows |
> +-------------+------------+
> | access      |       2719 |
> | dnsentries  |          0 |
> | downloads   |        615 |
> | links       |         78 |
> | member      |          8 |
> | news        |         39 |
> | nolog       |          4 |
> +-------------+------------+
> 
> Best Regards
> 
> Markus Grundmann
> http://activezone.org
> 
> ---------------------------------------------------------------------
> 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 internals-thread868@stripped
> To unsubscribe, e-mail <internals-unsubscribe@stripped>

-- 
ANTONY T CURTIS                     Tel: +44 (1635) 36222
Abacus Polar Holdings Ltd           Fax: +44 (1635) 38670
> Support your local Search and Rescue unit -- get lost.
Thread
Re: Re: mysqlshow.c - Modifications - 2nd TryMarkus Grundmann8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TryAntony T Curtis8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryJeremy Zawodny8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryRussell E Glaue8 Jun
      • Re: mysqlshow.c - Modifications - 2nd TryMichael Widenius11 Jun
  • Re: mysqlshow.c - Modifications - 2nd Trycj8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryRussell E Glaue8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryPaul DuBois8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TryAntony T Curtis8 Jun
  • Re: mysqlshow.c - Modifications - 2nd Trycj8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TrySinisa Milivojevic9 Jun