MySQL Lockups

------=_NextPart_000_0020_01C4E225.E943D2A0
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: 7bit

We have an app running on MySQL on a WinXP box that is experiencing
occasional lockups. When the lockups occur, they also appear to take out
Firefox and cause the system to become unstable. To me, this sounds like it
might be a TCP/IP issue. Anyone have any ideas on where to start tracking
this down?



Thanks,

Dan




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 12/9/2004


------=_NextPart_000_0020_01C4E225.E943D2A0--

Re: MySQL Lockups

Dan,

You could start by checking your available resources when mySql locks up. A=
lso check your long-query log (if it's not enabled, enabled it).

You can use the task manager (taskmgr.exe) to see what processes are using =
how much memory. Check the amount of memory mysqld is using to see if it ge=
ts significantly larger than normal when the 'lockups' occur.

I'm just guessing, but if the mySql lockup takes out other applications, yo=
ur computer's likely out of memory.

Hope this helps get you started.

Randy Clamons
Systems Programming
Astro-auction.com


> ------------Original Message------------
> From: "Dan Cumpian"
> To: win32@lists.mysql.com
> Date: Tue, Dec-14-2004 7:43 PM
> Subject: MySQL Lockups
>
> We have an app running on MySQL on a WinXP box that is experiencing
> occasional lockups. When the lockups occur, they also appear to take =

> out
> Firefox and cause the system to become unstable. To me, this sounds =

> like it
> might be a TCP/IP issue. Anyone have any ideas on where to start =

> tracking
> this down?
> =

> =

> =

> Thanks,
> =

> Dan
> =

> =

> =

> =

> -- =

> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 12/9/2004
> =

> =



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQL Lockups

First, Is this happening during a long query? I experience the same
thing, but only when MySql is processing a large amount of data.


Dan Cumpian wrote:

>We have an app running on MySQL on a WinXP box that is experiencing
>occasional lockups. When the lockups occur, they also appear to take out
>Firefox and cause the system to become unstable. To me, this sounds like it
>might be a TCP/IP issue. Anyone have any ideas on where to start tracking
>this down?
>
>
>
>Thanks,
>
>Dan
>
>
>
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQL Lockups

==========================
>>> "Randy Clamons" 12/14/04 10:23PM >>>
Dan,

You could start by checking your available resources when mySql locks
up. Also check your long-query log (if it's not enabled, enabled it).

You can use the task manager (taskmgr.exe) to see what processes are
using how much memory. Check the amount of memory mysqld is using to see
if it gets significantly larger than normal when the 'lockups' occur.

I'm just guessing, but if the mySql lockup takes out other
applications, your computer's likely out of memory.
==========================

Another suggestion: I had a "lockup" that turned out to be simply a
(very!) poorly designed query. Access wrote the SQL, and used a HAVING
clause for something that belonged in the WHERE clause. Access
apparently optimzed it (it must have), but MySQL built the cross
tabulation, which was seriously huge, and then filtered it. Who is
right? I don't know; one could argue it as a Microsoft feature or
Microsoft vendor lock and a MySQL optimization weakness. However, the
SQL was clearly not well written.

I took longer to debug it than I should have, in large part because I
intermittently made the mistake of reconfiguring ODBC connections w/o
reconecting. The result was that it appeared to be a random problem.

HTH.

Bill




Wilhelm K. Schwab, Ph.D.
University of Florida
Department of Anesthesiology
PO Box 100254
Gainesville, FL 32610-0254

Email: bills@anest4.anest.ufl.edu
Tel: (352) 846-1285
FAX: (352) 392-7029


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: MySQL Lockups

This is happening only on a specific machine with an app that has been
running just fine on several hundred other machines. In taking a look at =
the
database, the total DB size was less than 300MB, so there wasn't that =
much
data to cause a problem. We're going to try and do a better job of =
checking
the machine state (memory usage, etc...) the next time it occurs.

Thanks,
Dan


-----Original Message-----
From: Brandon Schenz [mailto:brandons@midwestsports.com]=20
Sent: Tuesday, December 14, 2004 11:19 PM
Cc: win32@lists.mysql.com
Subject: Re: MySQL Lockups

First, Is this happening during a long query? I experience the same=20
thing, but only when MySql is processing a large amount of data.


Dan Cumpian wrote:

>We have an app running on MySQL on a WinXP box that is experiencing
>occasional lockups. When the lockups occur, they also appear to take =
out
>Firefox and cause the system to become unstable. To me, this sounds =
like it
>might be a TCP/IP issue. Anyone have any ideas on where to start =
tracking
>this down?
>
>=20
>
>Thanks,
>
>Dan
>
>=20
>
>
> =20
>


--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004
=20


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org