Date: Wed, 14 Apr 2004 18:48:51 -0700 (PDT) From: Julian Elischer <julian@elischer.org> To: Ganbold <ganbold@micom.mng.net> Cc: mysql@lists.mysql.com Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems Message-ID: <Pine.BSF.4.21.0404141848290.36559-100000@InterJet.elischer.org> In-Reply-To: <6.0.3.0.2.20040415102606.02b00f90@202.179.0.80>
next in thread | previous in thread | raw e-mail | index | archive | help
2 processes, ok, but ps doesn;t shouw you how many threads.. try ps -auxH On Thu, 15 Apr 2004, Ganbold wrote: > 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/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 <ganbold@micom.mng.net> 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 > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0404141848290.36559-100000>