show table status

From: Jack O'Connor (jo418..ristol.ac.uk)
Date: Thu Jul 19 2007 - 03:49:28 EDT

  • Next message: Peter Schröder: "commit exception after server restart"

    Hi all, in my project I need to extract the total db size(kb). Im using
    Cayenne 1.2.3 and MySQL and I found the SQL command "show table status
    from <db name>" which displays a table of information about all of the
    tables in a certain db. This table has columns like "Name"(of table),
    "Data_length" and "Index_length", and apparently the best way to extract
    the size(kb) of a db is to sum the Data_length and Index_length columns
    of this table.

    Does anyone know how I can get the results of this query into java?

    Many Thanks
    Jack



    This archive was generated by hypermail 2.0.0 : Thu Jul 19 2007 - 03:53:57 EDT