I know that I can gauge the disk space usage of my tables with :

show table status;
and look at the Data_length column for each table, which is in bytes.

But does anyone know of another way to gauge the disk usage of MySQL dbs via
the prompt?


--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com

On Fri, 18 May 2007 12:49:37 +0100, Jack Vamvas wrote:
> I know that I can gauge the disk space usage of my tables with :
>
> show table status;
> and look at the Data_length column for each table, which is in bytes.
>
> But does anyone know of another way to gauge the disk usage of MySQL dbs via
> the prompt?

du(1) from the appropriate directory.

--
"Every new technology carries with it an opportunity to invent a new
crime." --Laurence Urgenson (an assistant chief US attorney),
speaking in 1987 about the first arrests for what was later called
cellphone cloning.

Peter H. Coffin wrote:
> On Fri, 18 May 2007 12:49:37 +0100, Jack Vamvas wrote:
>> I know that I can gauge the disk space usage of my tables with :
>>
>> show table status;
>> and look at the Data_length column for each table, which is in bytes.
>>
>> But does anyone know of another way to gauge the disk usage of MySQL dbs via
>> the prompt?
>
> du(1) from the appropriate directory.
>
a variation of du that has served me well:
du -h -d1
from the data directory.

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".