#1
  1. No Profile Picture
    rbergs
    Guest
    Devshed Newbie (0 - 499 posts)
    I am developing a large MySQL database consisting of about 18 tables. It's a backend for a website & we charge our clients per megabyte per month. Therefore I need to know how much disk space the database is using.
    I went to the /data/<database name> dir & found all of the files, which is fine. One table consists only of two columns, both of which are MEDIUMINT. There are 69 rows in this table. Yet for some reason it's taking up 1342992 bytes! All the other tables are far smaller, so does anyone know why this one is so memory hungary?
  2. #2
  3. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    Not a clue why it's doing that. Try dumping the table using mysqldump, then drop it from the database and restore it from the dump. That may clear it up.
  4. #3
  5. No Profile Picture
    rbergs
    Guest
    Devshed Newbie (0 - 499 posts)
    Yup, that did the trick.

    The ISD file is now 483 bytes, so it's quite a reduction. It makes me wonder if doing a mysqldump and reload occasionaly is a good habit to get into?
  6. #4
  7. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    I don't think that's necessary. Have you had a lot of data shuffle in and out of that table? If so, it's possible that an OPTIMIZE might have cleared it up. Dang, wish I'd thought of that sooner.

Similar Threads

  1. searching through a table in a mySql database
    By deano in forum MySQL Help
    Replies: 2
    Last Post: November 26th, 2003, 10:43 AM
  2. The max. of tables size in MySQL?
    By RayRay in forum MySQL Help
    Replies: 1
    Last Post: February 10th, 2003, 04:09 AM
  3. transfer datas from file to mysql table
    By ermarkar in forum PHP Development
    Replies: 0
    Last Post: February 7th, 2003, 01:48 PM
  4. test for mySQL table
    By Splendid_Bob in forum PHP Development
    Replies: 4
    Last Post: July 12th, 2002, 07:50 AM
  5. Replies: 0
    Last Post: June 20th, 2002, 03:12 PM

IMN logo majestic logo threadwatch logo seochat tools logo