MySQL

size of database

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2009

Posts: 19

Reputation: srpa01red is an unknown quantity at this point

Solved Threads: 0

srpa01red

Offline

Newbie Poster

size of database

Apr 7th, 2009

how can i find size of my database

what is the max table size in mysql

is table size shown is in terms of kb or mb in mysql by default

actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb or mb.

•

Join Date: Apr 2009

Posts: 15

Reputation: Upsilon is an unknown quantity at this point

Solved Threads: 3

Upsilon

Offline

Newbie Poster

Re: size of database

Apr 7th, 2009

•

Originally Posted by srpa01red

actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb or mb.

I thought Max_data_length was in bytes, but I could be wrong. Also the maximum size of a table is usually determined by the operating system and not MySQL itself, in most cases I think this is around 2GB.

Last edited by Upsilon; Apr 7th, 2009 at 4:44 am.

http://file2.ws/ - Convert any file into a webpage (doc, ppt, pdf, jpg, png, html, java, zip, csv, rtf and more)

•

Join Date: Dec 2007

Posts: 190

Reputation: mwasif is an unknown quantity at this point

Solved Threads: 25

mwasif

Offline

Junior Poster

Re: size of database

Apr 11th, 2009

Please find here the table limit (http://dev.mysql.com/doc/refman/5.0/en/full-table.html). You can increase the limit by ALTERing Max_data_length.

Max_data_length is in bytes as Upsilon said.

•

Join Date: Jun 2008

Posts: 79

Reputation: varmadba is an unknown quantity at this point

Solved Threads: 8

varmadba

Offline

Junior Poster in Training

Re: size of database

Apr 13th, 2009

Try this for Database Size or Table Size :

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT TABLE_NAME,ROUND((DATA_LENGTH/1024)/1024) AS DATA_SIZE,ROUND((INDEX_LENGTH/1024)/1024) AS INDEX_SIZE,ROUND(((DATA_LENGTH/1024)/1024) + ((INDEX_LENGTH/1024)/1024)) AS TOTAL_TABLE_SIZE
FROM information_schema.TABLES
GROUP BY TABLE_NAME
SELECT TABLE_NAME,ROUND((DATA_LENGTH/1024)/1024) AS DATA_SIZE,ROUND((INDEX_LENGTH/1024)/1024) AS INDEX_SIZE,ROUND(((DATA_LENGTH/1024)/1024) + ((INDEX_LENGTH/1024)/1024)) AS TOTAL_TABLE_SIZE
FROM information_schema.TABLES
GROUP BY TABLE_NAME

Last edited by peter_budo; Apr 15th, 2009 at 7:39 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags. Keep It Spam-Free Do not spam, advertise, plug your website.

:- Varma

We are Happy to inform launch of a new site with loads of database related information Site offers wide range of functionality Forums,Blogs,Articles,Editorials and much more
http://www.sqllibrarian.info/