Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
    
I'm voting to close this question as off-topic because lacking vital information, such as the database product. Also demonstrates no effort to research. – gWaldo Jan 6 at 13:45
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.