Gossamer Forum
Home : Products : Gossamer Links : Discussions :

What is overhead in mysql

Quote Reply
What is overhead in mysql
Hi there,

I've been looking at my database via phpadmin and have found that there is a section called space useage and from time to time a row appears called overhead. I can use optimize to get rid of it, but what causes this "overhead?" What is this anyway? it doesn't sound like a good thing, and I assume it affects performance on some level.

I've been developing new scripts and adding new tables, and I notice the overhead appears when I delete items from the database, but I have no idea how to stop it from producing overhead and I can't find documentation on this anywhere.

I'm using this code to delete:
my $sth = $custdb->delete ({'Username' => $user},$cond,$acond3);

There are two tables which connect on a key called
CustomerID which is found in $cond.

thanks in advance for any thoughts and tips you can provide.

peace.