FBSD 5.2.CURRENT-p4 and mysqld problems
Ganbold
ganbold at micom.mng.net
Thu Apr 15 00:49:41 PDT 2004
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 <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