cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack O'Connor <>
Subject show table status
Date Thu, 19 Jul 2007 07:49:28 GMT
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

View raw message