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/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var
But when I compile with linuxthreads I see many threads:
88 36250 68876 0 87 11 458452 441436 select SN ?? 0:02.59 (mysqld)
88 36253 36250 0 87 11 458452 441436 select SN ?? 0:00.06 (mysqld)
88 36254 36253 0 20 14 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36255 36253 0 20 14 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36256 36253 0 20 14 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36257 36253 0 20 14 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36258 36253 0 20 14 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36259 36253 0 90 14 458452 441436 select SN ?? 0:00.77 (mysqld)
88 36260 36253 0 20 14 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36270 36253 0 20 11 458452 441436 pause SN ?? 0:00.10 (mysqld)
88 36271 36253 0 20 12 458452 441436 pause SN ?? 0:00.00 (mysqld)
88 36272 36253 0 4 14 458452 441436 sbwait SN ?? 0:36.24 (mysqld)
88 36273 36253 0 4 14 458452 441436 sbwait SN ?? 0:00.25 (mysqld)
88 36274 36253 0 4 14 458452 441436 sbwait SN ?? 0:02.07 (mysqld)
88 36288 36253 0 20 14 458452 441436 pause SN ?? 0:00.65 (mysqld)
88 36297 36253 0 4 14 458452 441436 sbwait SN ?? 0:18.40 (mysqld)
88 36298 36253 0 20 14 458452 441436 pause SN ?? 0:02.81 (mysqld)
88 38326 36253 0 20 14 458452 441436 pause SN ?? 0:01.60 (mysqld)
88 38843 36253 0 20 14 458452 441436 pause SN ?? 0:00.60 (mysqld)
0 68876 1 0 8 0 1568 1024 wait S p5- 0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/backend2.pid --log-slow-queries=slow.log --log=general.log --log-update=update.log --default-character-set=latin1
I thought after default compile of mysqld server and start, it should create several mysql threads.
I think I compiled mysql without any thread support. How can I compile it to use libpthread?
thanks in advance,
Ganbold
At 09:30 PM 14.04.2004, you wrote:
On Wed, 14 Apr 2004 20:44:30 +0900 Ganbold <[EMAIL PROTECTED]> wrote:
> Can you give me some hints and tricks to compile mysql with libpthread? > What compiler options should I use?
None, it's the default threading lib with a recent -current. You just have to recompile (every application which may use threads, since mixing the thread libs is not possible, alternatively you can have a look at the man-page of libmap.conf).
Bye, Alexander.
-- I'm available to get hired.
http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
