Solved

Get size of MySQL table

Posted on 2007-11-13
8
6,361 Views
Last Modified: 2008-01-09
How do I get the size of a MySQL table?
0
Comment
Question by:allelopath
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 4

Accepted Solution

by:
jcoombes earned 350 total points
ID: 20275295
If you want the number of rows, then just

select count(*) from table

will do it.

If you want the physical size of the table then:

SHOW TABLE STATUS

might do what you want, see here:  http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
0
 
LVL 9

Expert Comment

by:ysnky
ID: 20275489
>>size of a MySQL table
what do you mean?
0
 
LVL 9

Assisted Solution

by:ysnky
ysnky earned 150 total points
ID: 20275536
for "show table status" usage in php;
http://www.modwest.com/help/kb6-199.html
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 1

Author Comment

by:allelopath
ID: 20275623
by table size I want to know how much space the data I have in there is occupying.

show table status shows a data_length of 15,800,991,744 (almost 16 gb)

I'm confused in that here:
http://jeremy.zawodny.com/blog/archives/000796.html
says that the limit is 4 gb.
The article is 4 years old, so it may be obsolete.
0
 
LVL 92

Expert Comment

by:objects
ID: 20275723
limit isn't 4gb, i have mysql tables over 50gb
0
 
LVL 9

Assisted Solution

by:ysnky
ysnky earned 150 total points
ID: 20277958
0
 
LVL 1

Author Comment

by:allelopath
ID: 20280541
How do I determine if the win32 system is FAT or NTFS?
0
 
LVL 4

Assisted Solution

by:jcoombes
jcoombes earned 350 total points
ID: 20280804
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle 11g 23 80
factorial example 4 39
configure dependency in POM for new database 3 25
Is there a simpler dropbox system? 10 20
For customizing the look of your lightweight component and making it look opaque like it was made of plastic.  This tip assumes your component to be of rectangular shape and completely opaque.   (CODE)
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question