• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6387
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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