dreamwest Posted June 20, 2009 Share Posted June 20, 2009 Whenever i delete a row using this query below i always get overhead - some tables have over 5 MB overhead, why is this? mysql_query( "DELETE FROM links WHERE id='5' ") ; Link to comment https://forums.phpfreaks.com/topic/163002-overhead-from-delete/ Share on other sites More sharing options...
fenway Posted June 22, 2009 Share Posted June 22, 2009 Because that's how deleting from MyISAM tables works -- you end up with fragmentation. No big deal, OPTIMIZE TABLE will fix that -- but depending on table size, it might take a while, and it LOCKs the tables. Link to comment https://forums.phpfreaks.com/topic/163002-overhead-from-delete/#findComment-860991 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.