Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am using linux.

share|improve this question
    
Define "how large". How many records, how much disk space, what? –  Paul Tomblin Oct 27 '09 at 21:18
    
Disk Space :) thanks. –  Alex Oct 27 '09 at 21:21
    
@Zoredache - check the tags. –  Paul Tomblin Oct 27 '09 at 21:37

2 Answers 2

up vote 5 down vote accepted

I should think

du -sk /wherever/your/db/stores/its/files

Should do it. On Unix MySQL, /var/lib/mysql is typical (but not mandatory).

The result will include files not strictly part of your data such as binary logs, etc. But those are usually important to keep.

share|improve this answer
1  
Of course if you are using innodb without some additional options you won't be able to identify spaced used by a single table/database simply by looking at the filesystem. –  Zoredache Oct 27 '09 at 21:37

du -hcs /var/lib/mysql/*

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.