Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 15 Apr 2004 16:54:31 +0900
From:      Ganbold <ganbold@micom.mng.net>
To:        Julian Elischer <julian@elischer.org>
Cc:        alexander@Leidinger.net
Subject:   Re: FBSD 5.2.CURRENT-p4 and mysqld problems
Message-ID:  <6.0.3.0.2.20040415165032.02b06a10@202.179.0.80>
In-Reply-To: <Pine.BSF.4.21.0404150023220.36886-100000@InterJet.elischer .org>
References:  <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> <Pine.BSF.4.21.0404150023220.36886-100000@InterJet.elischer.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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@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"
> >



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6.0.3.0.2.20040415165032.02b06a10>