Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: Table size in Mb

    Hi ,
    How to find table size in Mb for particular database

  2. #2
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    You could use SHOW TABLE STATUS (see the MySQL manual, section 12.5.5.29).

    Code:
    SHOW TABLE STATUS FROM database;

  3. #3
    Join Date
    Aug 2008
    Posts
    5
    Or another lazy way to get that information is to ssh into the server and use the "du -sh" command like so:

    du -sh /var/lib/mysql/*

    That is the most common path to the actual file data stored on the disk for the MySQL databases. It will give you a real size on disk breakdown of all of your databases.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •