SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Overhead Data

  1. #1
    SitePoint Guru SharifTK's Avatar
    Join Date
    Jan 2004
    Location
    New York, NY
    Posts
    621
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Overhead Data

    What causes there to be overhead data in a table?
    SK

  2. #2
    This is all Mumbo Jumbo Amit's Avatar
    Join Date
    Oct 2001
    Location
    New Delhi, India
    Posts
    277
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    One of the causes is deletion of records. When you delete the records, mysql, empties the records space, but doesn't remove that record (i.e in certain cases, depending upon, where your record was)

    You can recover the space by executing

    Code:
    OPTIMIZE table_name
    HTH!

  3. #3
    SitePoint Guru SharifTK's Avatar
    Join Date
    Jan 2004
    Location
    New York, NY
    Posts
    621
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well are there ways of optimizing record deletions so it wont cause overhead date?
    SK

  4. #4
    This is all Mumbo Jumbo Amit's Avatar
    Join Date
    Oct 2001
    Location
    New Delhi, India
    Posts
    277
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I am not sure! Usually it is taken as normal for the "overhead" in MySQL operations. This overhead is usally not much for normal operations (unless you have a very fragmented table)

    Well usually you can do a OPTIMIZE once a week to keep the table in good condition.


Bookmarks

Posting Permissions

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