Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option with libpthread.
After installation everything seemed OK. However after few minutes it hang
again.
It seems mysql with libpthread is even more unstable than using linuxthreads.
Ganbold
At 09:30 PM 14.04.2004
Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option.
However ps ax shows only 2 processes:
61652 p0 S 0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/ta
61671 p0 S 0:00.82 /usr/local/libexe
Hi,
Can you give me some hints and tricks to compile mysql with libpthread?
What compiler options should I use?
thanks,
Ganbold
At 08:31 PM 14.04.2004, you wrote:
On Wed, 14 Apr 2004 19:59:33 +0900
Ganbold <[EMAIL PROTECTED]> wrote:
> So what threading library should I use with mysql?
> Can some
Hi,
So what threading library should I use with mysql?
Can somebody recommend me which to use? Because I'm bit confused.
I used to use linuxthreads and it was pretty good. Now there appears some
other threading libraries:)
Which one is reliable and has good performance?
Ganbold
At 07:41 PM 14.0
p00:00.04 (mysqld)
0 32575 12045 0 76 0 1332 740 Giant L+p30:00.00 grep mysql
- Original Message -
From: "Ganbold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 11, 2004 11:35 PM
Subject: FBSD 5.2.CURRENT-p4 and mysqld proble
ged and fixed.
Hope this helps,
Ken
- Original Message -
From: "Ganbold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 11, 2004 11:35 PM
Subject: FBSD 5.2.CURRENT-p4 and mysqld problems
> Hi,
>
> I found some problematic queries which loc
Hi,
I found some problematic queries which locks mysql server any further
processing. I'm using mysql-4.0.18
from FreeBSD ports collection. I'm using FreeBSD-5.2-CURRENT.
Some of the queries like :
select sum(total_amount) pbc from customers.payment where contract_id>=0
and contract_id<=4999 an
