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' ") ; Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/163002-overhead-from-delete/#findComment-860991 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.