From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:49:41 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 90DCA16A4CE for ; Thu, 15 Apr 2004 00:49:41 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB1F643D49 for ; Thu, 15 Apr 2004 00:49:37 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=ganbold.micom.mng.net) by publicd.ub.mng.net with asmtp (Exim 4.30; FreeBSD) id 1BE2Ux-000K7l-Mx; Thu, 15 Apr 2004 16:45:27 +0800 Message-Id: <6.0.3.0.2.20040415165032.02b06a10@202.179.0.80> X-Sender: ganbold@micom.mng.net@202.179.0.80 X-Mailer: QUALCOMM Windows Eudora Version 6.0.3.0 Date: Thu, 15 Apr 2004 16:54:31 +0900 To: Julian Elischer From: Ganbold In-Reply-To: References: <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: threads@freebsd.org cc: kenm@icarz.com cc: alexander@Leidinger.net Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 15 Apr 2004 07:49:41 -0000 I compiled kernel with option MAXDSIZ=(1024*1024*1024). I thought in this case mysql can use data space up to 1GB. Am I right? Ganbold At 04:33 PM 15.04.2004, you wrote: >On Thu, 15 Apr 2004, Ganbold wrote: > > > Hi, > > > > I did cvsup today and updated FreeBSD 5.2-CURRENT. > > I used top command to see how much memory it is using. It was OK. Machine > > itself has 3GB memory. > > Is there any trick compiling mysql with libpthread? Without any trick it > > just hangs. > > >by default your data space is limited to 512MBytes >how much dataspace does your process use? >(top shows this) > > >I know nothing about Mysql >so I suggest you talk to petri.. >look in the threads mailing list archive.. look for MySQL. > > > > > ps axH shows first time after mysql start: > > > > 8826 p1 SL 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --user=mysql > > --datadir=/var/db/mysql --pid-file=/var/db/mysql/ba > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > > > ps axHlwww|grep mysql shows: > > > > backend2# ps axHlwww|grep mysql > > 0 8826 1 0 8 0 1580 1236 wait SL p1 0:00.02 > /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 > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 76 0 449804 449156 select > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 sigwai > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 ksesig > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 0 8879 796 0 76 0 1332 828 Giant LL+ p1 0:00.00 > grep mysql > > > > After sometime: > > > > backend2# ps axHlwww | grep mysql > > 0 8890 778 0 5 0 3392 2904 ttyin SL+ p0 0:00.03 > mysql -p > > 0 8826 1 0 8 0 1580 1236 wait SL p1 0:00.02 > /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 > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 ksesig > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 sigwai > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 76 0 450316 449264 select > > SL p1 0:03.51 (mysqld) > > 0 9395 796 0 76 0 1328 824 Giant LL+ p1 0:00.00 > grep mysql > > > > mysql show processlist shows at hang time: > > > > mysql> show processlist; > > > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > > | Id | User | Host | db | Command | > Time | > > State | > > Info > > | > > > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > > | 14 | root | localhost | NULL | Query | > 0 | > > NULL | show > > processlist > > | > > | 17 | admin | xxx:3773 | radius | Sleep | > > 40 | | > > NULL > > | > > | 18 | admin | xxx:3774 | radius | Query | 22 | > > update | insert > > into VOIP_TERMINATION > > (acctdelaytime,acctinputoctets,acctoutputoctets,acctsessionid,acctsessi | > > | 25 | admin | radiator1.ub.mng.net:4435 | radius | Query | > 22 | > > update | insert > > into ACCOUNTING > > > (ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSESSIONTIME | > > | 52 | admin | localhost | customers | Query | > 14 | > > statistics | select > > count(*) from users where > > userid='ganbold' | > > > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > > 6 rows in set (0.00 sec) > > > > thanks in advance, > > > > Ganbold > > > > > > At 03:12 PM 15.04.2004, you 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 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" > >