Lock and slow server

------=_NextPart_000_002E_01C66942.7A9CEB20
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_002F_01C66942.7AA1A610"

------=_NextPart_001_002F_01C66942.7AA1A610
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I=92m 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=E9veloppeur 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=E9s peuvent contenir des informations
confidentielles =E0 l=92attention unique du destinataire. Si le =
destinataire
estime que ce message lui est parvenu par erreur, il doit alors en =
informer
l=92exp=E9diteur mais en aucun cas n=92est autoris=E9 =E0 faire usage ni =
=E0 en diffuser
le contenu. Masternaut d=E9cline toute responsabilit=E9 si ce message =
est
alt=E9r=E9, d=E9form=E9 ou falsifi=E9.

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.

------=_NextPart_001_002F_01C66942.7AA1A610
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"PersonName"/>

<style>

</style>

</head>

<body lang=3DFR link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

I’m having =A0a 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. <o:p></o:p>

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.<o:p></o:p>

I though the lock was locking only the table, =
not the
server. <o:p></o:p>

Can you explain to me what may be causing =
this ?<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

Best regards.<o:p></o:p>

<o:p> </o:p>

<st1:PersonName ProductID=3D"Laurent JACQUES" =
w:st=3D"on">Laurent JACQUES</st1:PersonName><o:p></o:p>

<st1:PersonName ProductID=3D"Serge Deleau" =
tabIndex=3D"0"
style=3D"BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: =
url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
w:st=3D"on"></st1:PersonName>D=E9veloppeur VB6 & =
..NET<o:p></o:p>

<a href=3D"http://www.masternaut.com/" =
title=3Dmasternaut><img =
border=3D0
width=3D94 height=3D48 id=3D"_x0000_i1025" =
src=3D"cid:image001.gif [at] 01C66942.79563A50"
alt=3Dmasternaut></a><o:p></o:p>

=
masternaut<o:p></o:p><=
/p>

4 rue
Charles Cros<o:p></o:p>

BP =
30712<o:p></o:p>

27407
Louviers Cedex<o:p></o:p>

Tel :
02 32 25 37 00<o:p></o:p>

Fax : 02 32 25 37 =
01<o:p></o:p>

<img border=3D0 width=3D103 height=3D18 =
id=3D"_x0000_i1026"
src=3D"cid:image002.gif [at] 01C66942.79563A50"><o:p></o:p>

<a
href=3D"callto://laurent_jacques/" =
title=3D"callto://laurent_jacques/"><img border=3D0 width=3D80 =
height=3D18
id=3D"_x0000_i1027" =
src=3D"cid:image003.gif [at] 01C66942.79563A50"></a><a
href=3D"callto://fbriere/" =
title=3D"callto://fbriere/"></a><o:p></o:p>

<o:p> </o:p></fo=
nt>



Ce message ou les documents attach=E9s peuvent contenir des
informations confidentielles =E0 l’attention unique du =
destinataire. Si le
destinataire estime que ce message lui est parvenu par erreur, il doit =
alors en
informer l’exp=E9diteur mais en aucun cas n’est autoris=E9 =
=E0 faire
usage ni =E0 en diffuser le contenu. Masternaut d=E9cline toute =
responsabilit=E9 si
ce message est alt=E9r=E9, d=E9form=E9 ou =
falsifi=E9.<o:p></o:p>

<o:p> </o:p>

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.<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------=_NextPart_001_002F_01C66942.7AA1A610--

------=_NextPart_000_002E_01C66942.7A9CEB20--