Re: How to find size of my database

2006-05-03 Thread Rhino
D]> To: "Shivaji S" <[EMAIL PROTECTED]> Cc: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; Sent: Wednesday, May 03, 2006 9:20 AM Subject: Re: How to find size of my database On Wed, 03 May 2006 Rhino wrote : Daniel de Veiga has already answered you on how

Re: How to find size of my database

2006-05-03 Thread Mark Leith
On Wed, 03 May 2006 Rhino wrote : Daniel de Veiga has already answered you on how to determine the size of your database by using the file system and simply looking at the size of the physical files in your database. Another possibility is that you could use the SHOW TABLE STATUS command in M

RE: Re: How to find size of my database

2006-05-02 Thread Rithish Saralaya
> 1) I'll assume you use myisam tables, as your version is kinda outdated. > 2) I'll assume you want the total DISK space required for your > database. (could be rows, could be tables, could be space used by the > rows and tables, all of those are different, different storage engines > use space d

Re: Re: Re: Re: How to find size of my database

2006-05-02 Thread Shivaji S
would appear to be a >very useful command to create if it doesn't already exist! > >-- >Rhino > > > >----- Original Message - From: "Shivaji S" <[EMAIL PROTECTED]> >To: "Rhino" <[EMAIL PROTECTED]> >Cc: >Sent: Tuesday, May 02

Re: Re: Re: How to find size of my database

2006-05-02 Thread Rhino
to be a very useful command to create if it doesn't already exist! -- Rhino - Original Message - From: "Shivaji S" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 02, 2006 5:12 PM Subject: Re: Re: Re: How to find size of m

Re: Re: How to find size of my database

2006-05-02 Thread Daniel da Veiga
On 2 May 2006 20:33:56 -, Shivaji S <[EMAIL PROTECTED]> wrote: Hi Rhino, Thanks for the input. I mean to say the total Database Size ,that is to see my current Database Size.I am using 4.0.20 version Hmm, as generic as your first post. I'll just assume a lot of things in order to try a

Re: Re: Re: How to find size of my database

2006-05-02 Thread Shivaji S
? In other words, would the answer look like: >1. 234,000 KB? >2. 2.75 million rows? >3. 321 tables? >Or something else altogether? > >-- >Rhino > >- Original Message - From: "Shivaji S" <[EMAIL PROTECTED]> >To: "Rhino" <[EMAIL PROTECTED

Re: Re: How to find size of my database

2006-05-02 Thread Rhino
riginal Message - From: "Shivaji S" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 02, 2006 4:33 PM Subject: Re: Re: How to find size of my database Hi Rhino, Thanks for the input. I mean to say the total Database Size ,that is to

Re: Re: How to find size of my database

2006-05-02 Thread Shivaji S
Hi Rhino, Thanks for the input. I mean to say the total Database Size ,that is to see my current Database Size.I am using 4.0.20 version Regards, Shivaji On Wed, 03 May 2006 Rhino wrote : >It would be easier to help if you specified what you meant by "size". > >Do you mean the amount of spa

Re: How to find size of my database

2006-05-02 Thread Rhino
It would be easier to help if you specified what you meant by "size". Do you mean the amount of space the database is using on your hard drive? Or the number of tables in the database? Or the number of rows in the tables? Or somethng else altogether? You should also mention which version of M