[KLUG Members] Fw: [linux-Ahmedabad-users] How to get size of Database in MySQL

[MPs]

If you lack php/phpmyadmin you could just walk the database by hand.

Go to each database,
 go to each table in the database,
  write down the type/length of each field,
  -the MySQL manual has tables of types/sizes
  -at and around http://www.mysql.com/doc/en/Numeric_types.html
  -short version [in bytes]:
  - int:4
  - 4 year time stamp: 8
  - char: as defined in the table and add one byte
  - varchar: /up to/ as defined in the table and add one byte

  add up the lengths of each field and multiply by the number
  -of records in the table

This should give you a somewhat accurate count.

Anyone want to submit this to programming, probably get a better answer
there.

On Tue, 10 Feb 2004, komal wrote:

>
> ----- Original Message -----
> From: Jigar Vakharia
> To: linux-Ahmedabad-users@yahoogroups.com
> Sent: Tuesday, February 10, 2004 4:04 PM
> Subject: [linux-Ahmedabad-users] How to get size of Database in MySQL
>
>
>
> Hi,
>
> i am having space constrains on my database server, and need to plan for one
> new project, so i need to calculate the space available on my current
> database server, so please can any one tell me how to get the space
> available and also how to calculate space used by different databases
> already existing.
>
> i am using one full machine (i.e. a full system of 20 GB) for my MySQL
> server, nothing else is there on that PC other than database, and its on
> linux.
>
> thanks for your help in advance.
>
> jigaruu....
>
>
>
>
>
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
>
> To unsubscribe, email to: linux-Ahmedabad-users-unsubscribe@yahoogroups.com
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/linux-Ahmedabad-users/
>
> To unsubscribe from this group, send an email to:
> linux-Ahmedabad-users-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
> 
>