FBSD 5.2.CURRENT-p4 and mysqld problems
Julian Elischer
julian at elischer.org
Thu Apr 15 00:33:05 PDT 2004
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 <ganbold at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-threads
> To unsubscribe, send any mail to "freebsd-threads-unsubscribe at freebsd.org"
>
More information about the freebsd-threads
mailing list