Solved

Get size of MySQL table

Posted on 2007-11-13
8
6,364 Views
Last Modified: 2008-01-09
How do I get the size of a MySQL table?
0
Comment
Question by:allelopath
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle SQL syntax check  without executing 6 104
jdbc error in jsp application 20 71
Convert from a json string array to a Java object 3 63
Selenium docs api java index 3 64
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
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…

762 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