Date: Thu, 15 Apr 2004 16:28:45 +0900 From: Ganbold <ganbold@micom.mng.net> To: den <moreau@myrealbox.com> Cc: threads@freebsd.org Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems Message-ID: <6.0.3.0.2.20040415162511.02afd010@202.179.0.80> In-Reply-To: <407E3725.9020307@myrealbox.com> References: <Pine.BSF.4.21.0404142306290.36886-100000@InterJet.elischer.org> <407E3725.9020307@myrealbox.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, Probably your mysql wasn't compiled with threads support. You will see difference if you run big query. Mysql will serve to that query and puts into the queue all other queries. You should use threads. regards, Ganbold At 04:17 PM 15.04.2004, you wrote: >I'm sorry that my question is not exactly in essence of problem. >I compile mysql 4.17 ( static compilation ) on 5.2 from ports. I don't >choose linuxthreads , so as I think libpthread was used . >I don't have any problem with mysql on the box. >But when I do >ps axH >I don't see any threads at all. Actually >ps ax >and >ps axH >almost are not differ. >Can you tell me why this is happened ? > >Thanks. >Denis. > >Julian Elischer wrote: > >>firstly, >>how many threads did it create? >>how much memory did it use? >>what does ps -p[pid] -H show? >> >>is it using system scope or process scope threads? >> >>Other people have found that there are tricks to compiling it >>(something to do with compiler options) and tuning considerations.. >> >> >> >> >>On Thu, 15 Apr 2004, Ganbold wrote: >> >> >> >>>Hi, >>> >>>I compiled mysql-4.0.18 from ports on CURRENT machine with >>>BUILD_STATIC=yes option with libpthread. >>>After installation everything seemed OK. However after few minutes it >>>hang again. >>>It seems mysql with libpthread is even more unstable than using >>>linuxthreads. >>> >>>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" >> >> >> > >_______________________________________________ >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?6.0.3.0.2.20040415162511.02afd010>