Link to home
Start Free TrialLog in
Avatar of allelopath
allelopath

asked on

Get size of MySQL table

How do I get the size of a MySQL table?
ASKER CERTIFIED SOLUTION
Avatar of jcoombes
jcoombes
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>size of a MySQL table
what do you mean?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of allelopath
allelopath

ASKER

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.
Avatar of Mick Barry
limit isn't 4gb, i have mysql tables over 50gb
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How do I determine if the win32 system is FAT or NTFS?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial