[前][次][番号順一覧][スレッド一覧]

mysql:2188

From: "N.Yoshida" <"N.Yoshida" <yosh_no@xxxxxxxxxx>>
Date: Sat, 10 Jun 2000 19:27:03 +0900
Subject: [mysql 02188] Re: mysql デーモンの負荷テストで不可解な現象

  吉田です。
  解決しました。ありがとうございました。
>
>libz (-lz) が mysql.so 作成時にリンクされていないのでは?
>
>ldd ....../mysql.so
>nm --dynamic ......../mysql.so
>nm --dynamic ...../lib/libz.so
>
>ldd ......../mysqldump
>ldd ......../libmysqlclient.so
>
>
>-- 
> 村上 毅  takeshi@xxxxxxxxxx
>

  なぜかは分かりませんが、libz.soがリンクされていないのが原因でした。
  そこで、perl Makefile.PLが生成するMsql-Mysql-moduleのmysqlサブディ
  レクトリのMakefileのリンクパラメタに -lz を書き加えてmake,make test
  してやり、正常に動作する mysql.soが作成されました。

==(ログ)=============================================================
Shell > perl %f --static --config
Which drivers do you want to install?

    1)  MySQL only
    2)  mSQL only (either of mSQL 1 or mSQL 2)
    3)  MySQL and mSQL (either of mSQL 1 or mSQL 2)

    4)  mSQL 1 and mSQL 2
    5)  MySQL, mSQL 1 and mSQL 2

Enter the appropriate number:  [3] 1


Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [n]
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local/mysql]
Which database should I use for testing the MySQL drivers? [test]
On which host is database test running (hostname, ip address
or host:port) [localhost]
User name for connecting to database test? [root]
Password for connecting to database test? [undef]
Creating files for MySQL ....................
Checking if your kit is complete...
Looks good
Using DBI 1.13 installed in /usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules
-----------------------------------------------------------------
(〜/Msql-Mysql-modules-1.22XX/mysql/Makefileの修正)
.......
LD = cc
LDDLFLAGS = -shared -L/usr/local/lib -lz     ◆39行目あたりのLDDFLAGS変数に
LDFLAGS =  -L/usr/local/lib                    -lzを追加(libz.soのリンク)
.......
-----------------------------------------------------------------
Shell > make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/Msql-Mysql-modules
mkdir blib/lib/auto
mkdir blib/lib/auto/Msql-Mysql-modules
mkdir blib/man1
/usr/bin/pod2text mysql/lib/DBD/mysql.pm >README
make[1]: Entering directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
mkdir ../blib/lib/DBD
mkdir ../blib/arch/auto/DBD
mkdir ../blib/arch/auto/DBD/mysql
mkdir ../blib/lib/auto/DBD
mkdir ../blib/lib/auto/DBD/mysql
mkdir ../blib/man3
cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm
cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm
cp lib/Mysql.pm ../blib/lib/Mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBI -I/usr/local/mysql/in
clude/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBI -I/usr
/lib/perl5/5.00503/i586-linux -Dbool=char -DHAS_BOOL -O2    -DVERSION=\"2.0414\"
 -DXS_VERSION=\"2.0414\" -fpic -I/usr/lib/perl5/5.00503/i586-linux/CORE -DDBD_MY
SQL dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" < /usr/lib/perl5/site_perl/5.005/i586-l
inux/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl -I/usr/lib/perl5/5.00503/i586-linux -I/usr/lib/perl5/5.00503 /usr/
lib/perl5/5.00503/ExtUtils/xsubpp -object_capi  -typemap /usr/lib/perl5/5.00503/
ExtUtils/typemap mysql.xs >xstmp.c && mv xstmp.c mysql.c
cc -c -I/usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBI -I/usr/local/mysql/in
clude/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBI -I/usr
/lib/perl5/5.00503/i586-linux -Dbool=char -DHAS_BOOL -O2    -DVERSION=\"2.0414\"
 -DXS_VERSION=\"2.0414\" -fpic -I/usr/lib/perl5/5.00503/i586-linux/CORE -DDBD_MY
SQL mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="/lib:/usr/lib/gcc-lib/i586-pc-linux/2.95.2" cc -o ../blib/arch/auto
/DBD/mysql/mysql.so  -shared -L/usr/local/lib -lz dbdimp.o mysql.o -L/usr/local/
mysql/lib/mysql    /usr/local/mysql/lib/mysql/libmysqlclient.a -lm -L/usr/lib/gc
c-lib/i586-pc-linux/2.95.2 -lgcc
chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs
Manifying ../blib/man3/DBD::mysql.3
Manifying ../blib/man3/Bundle::DBD::mysql.3
Manifying ../blib/man3/Mysql.3
make[1]: Leaving directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
mkdir blib/script
cp dbimon blib/script/dbimon
/usr/bin/perl -I/usr/lib/perl5/5.00503/i586-linux -I/usr/lib/perl5/5.00503 -MExt
Utils::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon
Manifying blib/man1/dbimon.1

-----------------------------------------------------------------
Shell > make test
make[1]: Entering directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
make[1]: Leaving directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
make[1]: Entering directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.
00503/i586-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $ve
rbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............ok
t/10dsnlist.........ok
t/20createdrop......ok
t/30insertfetch.....ok
t/40bindparam.......ok
t/40blobs...........ok
t/40listfields......ok
t/40nulls...........ok
t/40numrows.........ok
t/50chopblanks......ok
t/50commit..........ok
t/60leaks...........skipping test on this platform
t/ak-dbd............ok
t/dbdadmin..........ok
All tests successful, 1 test skipped.
Files=14,  Tests=276, 34 wallclock secs (11.54 cusr +  1.11 csys = 12.65 CPU)
make[1]: Leaving directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'

Shell > make install
make[1]: Entering directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
make[1]: Leaving directory `/usr1/src/Msql-Mysql-modules-1.2214/mysql'
Installing /usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBD/mysql/mysql.so
Installing /usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBD/mysql/mysql.bs
Files found in blib/arch --> Installing files in blib/lib into architecture depe
ndend library tree!
Installing /usr/lib/perl5/site_perl/5.005/i586-linux/DBD/mysql.pm
Installing /usr/lib/perl5/site_perl/5.005/i586-linux/Bundle/DBD/mysql.pm
Installing /usr/lib/perl5/site_perl/5.005/i586-linux/Mysql/Statement.pm
Installing /usr/lib/perl5/site_perl/5.005/i586-linux/Mysql.pm
Installing /usr/man/man1/dbimon.1
Installing /usr/lib/perl5/5.00503/man/man3/DBD::mysql.3
Installing /usr/lib/perl5/5.00503/man/man3/Bundle::DBD::mysql.3
Installing /usr/lib/perl5/5.00503/man/man3/Mysql.3
Installing /usr/bin/dbimon
Writing /usr/lib/perl5/site_perl/5.005/i586-linux/auto/Msql-Mysql-modules/.packl
ist
Appending installation info to /usr/lib/perl5/5.00503/i586-linux/perllocal.pod

Shell >
-----------------------------------------------------------------

-------------------------------------------------------------------------
  吉田 伸次(N.Yoshida) E-mail:yosh_no@xxxxxxxxxx
                       nifty :TCN00171@xxxxxxxxxx
-------------------------------------------------------------------------

[前][次][番号順一覧][スレッド一覧]

      2153 2000-06-02 11:39 ["N.Yoshida" <yosh_no] mysql デーモンの負荷テストで不可解な現象
      2154 2000-06-02 17:32 ┗[<takeshi@xxxxxxxxxx>]                                       
      2156 2000-06-02 20:12  ┗["N.Yoshida" <yosh_no]                                     
      2158 2000-06-02 22:43   ┗[<takeshi@xxxxxxxxxx>]                                   
      2163 2000-06-05 14:58    ┗["N.Yoshida" <yosh_no]                                 
      2164 2000-06-05 16:14     ┗[Seiji Tateyama <tate]                               
      2165 2000-06-05 19:41      ┗["N.Yoshida" <yosh_no]                             
      2166 2000-06-05 21:44       ┣[<takeshi@xxxxxxxxxx>]                           
->    2188 2000-06-10 19:27       ┃┗["N.Yoshida" <yosh_no]                         
      2167 2000-06-06 01:42       ┗[tateyan <tateyan@xxx]                           
      2168 2000-06-06 10:22        ┗["N.Yoshida" <yosh_no]