From owner-freebsd-database Fri Sep 22 9:23:50 2000 Delivered-To: freebsd-database@freebsd.org Received: from fe160.worldonline.dk (fe160.worldonline.dk [212.54.64.198]) by hub.freebsd.org (Postfix) with SMTP id D7A0337B422 for ; Fri, 22 Sep 2000 09:23:45 -0700 (PDT) Received: (qmail 24110 invoked by uid 0); 22 Sep 2000 16:23:41 -0000 Received: from unknown (HELO here) (213.237.20.85) by fe160.worldonline.dk with SMTP; 22 Sep 2000 16:23:41 -0000 Message-ID: <00cf01c01d9e$7909d660$7801a8c0@here> From: "Martin Jakobsen" To: Subject: Date: Wed, 13 Sep 2000 18:20:03 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hello. I am trying to compile MySQL with mit-threads under FreeBSD 4.1. I have compiled the kernel for SMP and it runs excellent. ./configure --with-mit-threads seems to go ok, but make returns: --------------------------------------------------- gcc -O -pipe -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=6 4 -O6 -DDBUG_OFF -Werror -I/usr/local/mysql/mysql-3.22.32/mit-pthreads -I/ usr/local/mysql/mysql-3.22.32/mit-pthreads/include -I/usr/local/mysql/mysql- 3.22.32/mit-pthreads/include -DPTHREAD_KERNEL -c /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c -o sig.o /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c:408: invalid initializer /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c:415: invalid initializer /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c: In function `sigaddset': /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c:430: invalid operands to binary | /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c: In function `sigdelset': /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c:440: invalid operands to binary & /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c: In function `sigismember': /usr/local/mysql/mysql-3.22.32/mit-pthreads/pthreads/sig.c:450: invalid operands to binary & *** Error code 1 Stop in /usr/local/mysql/mysql-3.22.32/mit-pthreads. *** Error code 1 Stop in /usr/local/mysql/mysql-3.22.32. *** Error code 1 Stop in /usr/local/mysql/mysql-3.22.32. --------------------------------------------------- Any ideas why this happens everytime? I have compiled it without mit-threads and it runs fine, but because the servers only purpose are to be a database server, I'd really like if it used both CPU's. Any Ideas? Regards, Martin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Sep 22 21: 7:58 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id E8D0F37B422 for ; Fri, 22 Sep 2000 21:07:54 -0700 (PDT) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13cgEp-0006bj-00; Fri, 22 Sep 2000 20:44:31 -0700 Date: Fri, 22 Sep 2000 20:43:20 -0700 (PDT) From: Tom Samplonius To: Martin Jakobsen Cc: freebsd-database@freebsd.org Subject: Re: your mail In-Reply-To: <00cf01c01d9e$7909d660$7801a8c0@here> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 13 Sep 2000, Martin Jakobsen wrote: > Hello. > I am trying to compile MySQL with mit-threads under FreeBSD 4.1. > I have compiled the kernel for SMP and it runs excellent. ... > Any ideas why this happens everytime? > I have compiled it without mit-threads and it runs fine, > but because the servers only purpose are to be a database server, > I'd really like if it used both CPU's. It won't help. Neither mit-threads nor native threads will balance the threads of a single app over multiple CPUs. Solution? If you have multiple databases, run separate instances of mySQL for each. Or perhaps, one instance for each customer. There are additional advantages to this approach too. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message