Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6391
  • Last Modified:

Get size of MySQL table

How do I get the size of a MySQL table?
0
allelopath
Asked:
allelopath
  • 3
  • 2
  • 2
  • +1
4 Solutions
 
jcoombesCommented:
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
 
ysnkyCommented:
>>size of a MySQL table
what do you mean?
0
 
ysnkyCommented:
for "show table status" usage in php;
http://www.modwest.com/help/kb6-199.html
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
allelopathAuthor Commented:
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
 
objectsCommented:
limit isn't 4gb, i have mysql tables over 50gb
0
 
allelopathAuthor Commented:
How do I determine if the win32 system is FAT or NTFS?
0
 
jcoombesCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now