List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 13 1999 12:06am
Subject:MySQL lockups revisited
View as plain text  
Hi!

>>>>> "Orlando" == Orlando Andico <orly@stripped> writes:

Orlando> Hello,

Orlando> I'm using MySQL 3.22.27 on Sun Solaris 2.7 (I also used this same version
Orlando> on FreeBSD 3.3) and am experiencing lockups and very slow queries. Since I
Orlando> didn't see these problems before (3.22.21 on Linux-SMP) I am inclined to
Orlando> believe there's a bug introduced in this version -- unless both Solaris
Orlando> 2.7 and FreeBSD 3.3 have a severe bug where Linux 2.2.9 (glibc-2.0.7)
Orlando> doesn't.

<cut>

Orlando>
> +--------+------+------------------+-----------+----------------+--------+-----------------+------------------------------------------------------------------------------------------------------+
Orlando> | Id     | User | Host             | db        | Command        | Time   |
> State           | Info                                                                    
>                             |
Orlando>
> +--------+------+------------------+-----------+----------------+--------+-----------------+------------------------------------------------------------------------------------------------------+
Orlando> | 2      |      |                  | mosaic_db | Delayed_insert | 10     |
> Waiting on cond | radius_acct_19991001                                                    
>                             |
Orlando> | 11944  | root | ipass.mozcom.com | mosaic_db | Query          | 131995 |
> Locked          | INSERT INTO radius_acct_19991001 (Client_Id,
Orlando> Client_Port_Id, User_Name, Acct_Session_Id, Acct_Stat |

Orlando> --- cut ---

This is a bit short;  It only shows that you combines INSERT INTO with 
INSERT DELAYED into the same table.  Is this really what you want ?

Anyway;  Is there any change that you can modify 'fork_test.pl' to
simulate your insert / queries.  If you can get this stuck, then it
should be pretty easy to fix this.

Regards,
Monty
Thread
MySQL lockups revisitedOrlando Andico23 Oct
  • Re: MySQL lockups revisitedsinisa24 Oct
    • Re: MySQL lockups revisitedOrlando Andico25 Oct
      • Re: MySQL lockups revisitedsinisa25 Oct
        • Re: MySQL lockups revisitedOrlando Andico25 Oct
          • Re: MySQL lockups revisitedsinisa25 Oct
      • Re: MySQL lockups revisitedMichael Widenius13 Nov
        • Re: MySQL lockups revisitedOrlando Andico20 Nov
          • Re: MySQL lockups revisitedMichael Widenius20 Nov
  • MySQL lockups revisitedMichael Widenius13 Nov