Date: Thu, 15 Apr 2004 15:34:23 +0900 From: Ganbold <ganbold@micom.mng.net> To: Julian Elischer <julian@elischer.org> Cc: kenm@icarz.com Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems Message-ID: <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> In-Reply-To: <Pine.BSF.4.21.0404142306290.36886-100000@InterJet.elischer .org> References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> <Pine.BSF.4.21.0404142306290.36886-100000@InterJet.elischer.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
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 <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
> >
> >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6.0.3.0.2.20040415152523.02ad4b10>