There is little performance hit due to this. It would only start to affect performance when the overhead started to increase to the point that it was a significant percentage of the total table size. Perhaps someone else can ring in here with real numbers but I'd say it'd have to be 10-20% of your table size before it would be a problem, and more so on smaller tables.
It's just stuff that the database engine has to work around. Remember it's referring to data overhead, not CPU overhead. If this grows quickly in your system, just automate a nightly or hourly cleaning. -Micah On 11/17/2008 06:35 PM, sangprabv wrote: > Thanks for the reply, does this overhead reduce performance? And is > there any tips to avoid this overhead? TIA. > > > WM > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
