Deleted some table contents via PHP, but shows as table overhead

Discussion in 'MySQL' started by postcd, May 15, 2014.

  1. #1
    Hello,

    im using some encoded third party PHP system and i clicked button to delete some Logs, But after done in PHPMyAdmin i see now the size of table as Overhead, not properly cleaned.. so i want to ask if its wrong to see this or why it was not deleted, what is overhead good for..

    PS: i know i can run optimise table, but im curious its not done immediatelly and automatically
     
    postcd, May 15, 2014 IP
  2. billzo

    billzo Well-Known Member

    Messages:
    961
    Likes Received:
    278
    Best Answers:
    15
    Trophy Points:
    113
    #2
    If you are using MySQL, this is a known annoyance. When deleting data from tables, MySQL does not reduce the size. Lots of people complain about that and from what I have read, OPTIMIZE TABLE does not reduce database size either (at least not with InnoDB tables).

    http://www.mysqlperformanceblog.com...e-in-innodb-when-innodb_file_per_table-is-on/

    See the above MySQL Performance Blog link for possible solutions.
     
    billzo, May 15, 2014 IP
    postcd likes this.