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
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.