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

Re: How to find size of my database

2006-05-03 Thread Rhino
: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED]; mysql@lists.mysql.com 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 to determine the size of your database by using the file

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

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 space

Re: Re: How to find size of my database

2006-05-02 Thread Rhino
- From: Shivaji S [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Cc: mysql@lists.mysql.com 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 see my current Database Size.I am using

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

2006-05-02 Thread Shivaji S
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] Cc: mysql@lists.mysql.com Sent: Tuesday, May 02, 2006 4:33 PM Subject: Re: Re: How to find size of my

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

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

2006-05-02 Thread Rhino
! -- Rhino - Original Message - From: Shivaji S [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, May 02, 2006 5:12 PM Subject: Re: Re: Re: How to find size of my database Hi Rhino, sorry ,for my unclear reply. the size i meant is in KB or MB

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

2006-05-02 Thread Shivaji S
: mysql@lists.mysql.com Sent: Tuesday, May 02, 2006 5:12 PM Subject: Re: Re: Re: How to find size of my database Hi Rhino, sorry ,for my unclear reply. the size i meant is in KB or MB.. Regards, Shivaji On Wed, 03 May 2006 Rhino wrote : You still haven't said what you mean by size! Let me put

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