From owner-freebsd-questions Tue Sep 21 14:25:27 1999 Delivered-To: freebsd-questions@freebsd.org Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by hub.freebsd.org (Postfix) with ESMTP id B7B2914F4D; Tue, 21 Sep 1999 14:25:22 -0700 (PDT) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.9.3/8.9.3) id QAA04154; Tue, 21 Sep 1999 16:25:22 -0500 (CDT) (envelope-from dan) Date: Tue, 21 Sep 1999 16:25:21 -0500 From: Dan Nelson To: Dirk Froemberg Cc: "Ronald F. Guilmette" , ports@FreeBSD.ORG, questions@FreeBSD.ORG Subject: Re: mysql-server-3.22.25 install botch (pthread_attr_setschedparam?) Message-ID: <19990921162521.A4053@dan.emsphone.com> References: <19990919230055.E42360@physik.TU-Berlin.DE> <27137.937789692@monkeys.com> <19990921222033.A96951@physik.TU-Berlin.DE> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre2i In-Reply-To: <19990921222033.A96951@physik.TU-Berlin.DE> X-OS: FreeBSD 4.0-CURRENT Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG In the last episode (Sep 21), Dirk Froemberg said: > > I hope that it is apparent what I am really asking here. If I run > > mySQL on a multiprocessor system that is running FreeBSD, will it > > actually be able to make use of more than one processor at a time > > on that system? Does the FreeBSD kernel provide adequate support > > for this? > > Yes, definitly. FreeBSD-SMP scales very well (see > http://www.freebsd.org/~fsmp/SMP/akgraph-a/graph1.html for details). > > And yes, MySQL will benefit from more than one processor. That's what > threads support is for. 8-) Are you sure? I thought threads support was to avoid the context switch of a full process, mainly because Windows processes are so inefficient. AFAIK, user-level threads are implemented as a single process, and use setitimer() to switch threads. All threads will run on one CPU, so SMP won't help much at all. -- Dan Nelson dnelson@emsphone.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message