I have got an example with a simple and very often used select here also...
| 28 | DELAYED | localhost | dbSmurfa | Delayed_insert | 1 |
Waiting on cond | GuestBook
| 479 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 480 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 496 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | UPDATE Users SET Logons=Logons+1
| 494 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0 |
Locked | UPDATE Users SET Logons=Logons+1
| 511 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 517 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 518 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 528 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Hits FROM UserCounters
| 525 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Hits FROM UserCounters
| 523 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Hits FROM UserCounters
| 531 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.Alias, Users.ID
| 536 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT ID, Alias, Name, Email
| 539 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0 |
| NULL
| 538 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0 |
| NULL
| 537 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0 |
| NULL
| 546 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 549 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT Users.ID, Users.Alias
| 533 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT ID, Alias, Name, Email
| 532 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | UPDATE UserCounters SET Hits=Hits+1
| 530 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | UPDATE UserCounters SET Hits=Hits+1
| 550 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT MezzIndex.ID, MezzIndex.Title
| 553 | root | localhost | NULL | Query | 0 |
NULL | show processlist
| 555 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Sending data | SELECT ID, Alias, Password
| 556 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0 |
Locked | SELECT Users.ID, Users.Alias
| 558 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | UPDATE UserCounters SET Hits=Hits+1
| 557 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | UPDATE Users SET LastAccess=
| 559 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1 |
Locked | SELECT ID, Alias, Password
| 560 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0 |
Locked | SELECT Users.ID, Users.Alias
| 561 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0 |
Locked | UPDATE Users SET LastAccess=
| 562 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0 |
Locked | SELECT MezzIndex.ID, MezzIndex.Title
| 563 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0 |
Locked | SELECT MezzIndex.ID, MezzIndex.Title
----- Original Message -----
From: "Andrius Armonas" <[EMAIL PROTECTED]>
To: "Johan Wahlström" <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 6:19 AM
Subject: Re: locking problem!
> if you're using write lock and do not unlock tables for a longer time, it
is
> normal.
>
> .:: Andrius Armonas ::.
> .:: [EMAIL PROTECTED] ::.
> .:: http://baubas.andrius.org ::.
> ----- Original Message -----
> From: "Johan Wahlström" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 10:12 PM
> Subject: locking problem!
>
>
> I have problem with table lockings scince i upgraded the MySQL version,
and
> i have tried with
> both RedHat 7.1 rpm version 2.23.36 and compile myself with 2.23.39. The
> result is the same.
>
> As can be seen in the "screenshot" below there is one process running, and
a
> lot sleeping. In
> this example it happens to be an update running, but it might as well be
an
> INSERT or SELECT.
>
> When the lock is released the server starts working on all locked querries
> at the same time, the
> result is a slow server with a load average around 60 where it can be run
> for long times with load
> between 1.00 and 2.00 on a dual cpu machine.
>
> Any ideas on how to solve this? Is this standard behaivour? I hope not...
>
> | 6899 | root | localhost | NULL | Query | 0 | NULL
> | show processlist
> | 7697 | smurfa | smurfa-www | dbSmurfa | Sleep | 788 |
> | NULL
> | 15079 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Users.ID, Users.Alias
> | 15083 | smurfa | smurfa-www | dbSmurfa | Sleep | 1 |
> | NULL
> | 15090 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Users.ID, Users.Alias
> | 15091 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Users.ID, Users.Alias
> | 15094 | smurfa | smurfa-www | dbSmurfa | Query | 1 | end
> | UPDATE Users SET Logons=Logons+1,
> | 15095 | smurfa | smurfa-www | dbSmurfa | Sleep | 1 |
> | NULL
> | 15096 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Users.ID, Users.Alias
> | 15097 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Users.ID, Users.Alias
> | 15098 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Users.ID, Users.Alias
> | 15100 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT Users.ID, Users.Alias
> | 15101 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT Alias FROM Users WHERE
> | 15102 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT ID, Alias, Name, Email,
> | 15103 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT ID, Alias, Password,
> | 15104 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT ID, Alias, Name, Email,
> | 15105 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT ID, Alias, Name, Email,
> | 15106 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT Users.ID, Users.Alias,
> | 15107 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT MezzIndex.ID, MezzIndex.
> | 15108 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT Users.ID, Users.Alias,
> | 15109 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT Users.ID, Users.Alias,
> | 15111 | smurfa | smurfa-www | dbSmurfa | Query | 2 | Locked
> | SELECT MezzIndex.ID, MezzIndex.
> | 15114 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT Alias FROM Users WHERE
> | 15113 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT ID, Alias, Name, Email,
> | 15115 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT Alias FROM Users WHERE
> | 15118 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT MezzIndex.ID, MezzIndex
> | 15117 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT MezzIndex.ID, MezzIndex
> | 15124 | smurfa | smurfa-www | dbSmurfa | Query | 1 | Locked
> | SELECT ID, Alias, Name, Email
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
