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
