Lock and slow server

Hi,

I’m having  a strange behaviour with my mySQL server (version 4.0.22).
Sometimes some lock happened, and while it happens the entire server appears
to be locked. 

All my applications freeze during the 2-5 seconds of the lock and restart as
if nothing happened as soon as the lock is gone.

I though the lock was locking only the table, not the server. 

Can you explain to me what may be causing this ?

 

 

Best regards.

 

Laurent JACQUES

Développeur VB6 & .NET

 <http://www.masternaut.com/> masternaut

masternaut

4 rue Charles Cros

BP 30712

27407 Louviers Cedex

Tel : 02 32 25 37 00

Fax : 02 32 25 37 01



 <callto://laurent_jacques/>  <callto://fbriere/> 

 

Ce message ou les documents attachés peuvent contenir des informations
confidentielles à l’attention unique du destinataire. Si le destinataire
estime que ce message lui est parvenu par erreur, il doit alors en informer
l’expéditeur mais en aucun cas n’est autorisé à faire usage ni à en diffuser
le contenu. Masternaut décline toute responsabilité si ce message est
altéré, déformé ou falsifié.

 

This message or attached files may contain privileged and confidential
information intended only for the use of the addressee. If the recipient
feels he is not intended recipient of this message, he is hereby notified
that he must not disclose, copy or take any action in reliance on it. If he
has received this message in error, the recipient is requested to notify
Masternaut immediately. Masternaut will decline any responsibility if this
message is altered deformed or falsified.