Hi Karl,
native threads on FreeBSD does not yet support multi processor,
however you can try using the ports collection, cvsup the latest
ports, then
cd /usr/ports/databases/mysql323-server
DB_DIR=/usr/local/var WITH_LINUXTHREADS=yes make
make install
Change the DB_DIR to where you want you database to be. There are
some quirks to this build so try it on a test machine first, but once
build and installed it seems to run fine.
Ken
----- Original Message -----
From: "Karl Prinz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 3:27 AM
Subject: mysql and multiproz
> Hi,
>
> mysql under FreeBSD has apparantly problems to distribute threads
on
> serveral
> processors. So does it make sense to install several instances of
the
> mysql-server on one
> machine, which perform different tasks, but use one database? In
other
> words, is the access to the database the performance bottleneck or
the
> handling of the data, stored or to be stored in the database?? In
the
> latter
> case one could profit from several mysql-servers on one machine,
filling
> one
> database, using the different prozessors better than one server.
>
> thanx for hints
>
> Dr. Karl Prinz
> Senior Project Manager
>
> freshnet GmbH Tel.: +49 89 552988 15
> Arnulfstrasse 27 Fax: +49 89 552988 88
> D-80335 Muenchen http://www.freshnet.de
> Germany mailto:[EMAIL PROTECTED]
>
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
