mysql压力测试时，报出错。请大侠指点！！

acxellencedk

[root@u151-RD-DB sql-bench]# perl -e "use DBI"
[root@u151-RD-DB sql-bench]# perl -e "use DBI"
DBD是没有问题的。

[root@u151-RD-DB sql-bench]# ./test-connect
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 4 line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Pg, Proxy, Sponge.
at /usr/local/mysql/sql-bench/server-cfg line 240
Compilation failed in require at ./test-connect line 36.




[root@u151-RD-DB sql-bench]# ./test-select
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 4 line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Pg, Proxy, Sponge.
at /usr/local/mysql/sql-bench/server-cfg line 240
Compilation failed in require at ./test-select line 35.

talen-t

你那肯定是dbd包得问题,你上面显示只表示你得dbi是对得,没说你得dbd也对啊
去goole一下,下个dbd包安装吧

[ 本帖最后由 talen-t 于 2006-7-31 15:41 编辑 ]

acxellencedk

[root@test22 sql-bench]# ./run-all-tests --server=mysql
Can't locate object method "connect" via package "DBI" at /usr/local/mysql/sql-bench/server-cfg line 240.

[root@test22 sql-bench]# perl -e "use DBI"

[root@test22 sql-bench]# ./test-connect
Can't locate object method "connect" via package "DBI" at /usr/local/mysql/sql-bench/server-cfg line 240.
Compilation failed in require at ./test-connect line 36.

[root@test22 sql-bench]# ./test-select
Can't locate object method "connect" via package "DBI" at /usr/local/mysql/sql-bench/server-cfg line 240.
Compilation failed in require at ./test-select line 35.




/usr/local/mysql/sql-bench/server-cfg line 240行的内容如下：

   233  # Connection with optional disabling of logging
   234  #
   235
   236  sub connect
   237  {
   238    my ($self)=@_;
   239    my ($dbh);
   240    $dbh=DBI->connect($self->{'data_source'}, $main:pt_user,
   241                      $main:pt_password,{ PrintError => 0}) ||
   242                        die "Got error: '$DBI::errstr' when connecting to " . $self->{'data_source'} ." with user: '$main:pt
_user' password: '$main:pt_password'\n";
   243
   244    $dbh->do("SET OPTION LOG_OFF=1,UPDATE_LOG=0";
   245    return $dbh;
   246  }
   247

[ 本帖最后由 acxellencedk 于 2006-8-3 14:25 编辑 ]

acxellencedk

顶一下

[ 本帖最后由 acxellencedk 于 2006-8-3 14:22 编辑 ]

acxellencedk

又改进了一点点：
[root@u151-RD-DB sql-bench]# ./test-connect -user root  -p admin123 -host 127.0.0.1 -sock /tmp/mysql.sock
Got error: 'Access denied for user: 'root@u151-RD-DB' (Using password: YES)' when connecting to DBI:mysql:database=test;host=127.0.0.1;mysql_socket=/tmp/mysql.sock with user: 'root' password: 'admin123'
Compilation failed in require at ./test-connect line 36.

[ 本帖最后由 acxellencedk 于 2006-8-3 14:24 编辑 ]

yejr

/usr/local/mysql/bin/mysql -uroot -padmin123 -h127.0.0.1 能连上吗

acxellencedk

搞定，大家看下结果，呵呵。但还有一个：./crash-me仍旧不行。

[root@u151-RD-DB sql-bench]# ./run-all-tests --server=mysql -user root  -p admin123  -h localhost
Benchmark DBD suite: 2.15
Date of test:        2006-08-03 14:02:51
Running tests on:    Linux 2.6.9-34.EL i686
Arguments:           -sock
Comments:            
Limits from:         
Server version:      MySQL 4.0.25 log
Optimization:        None
Hardware:            

alter-table: Total time: 30 wallclock secs ( 0.07 usr  0.02 sys +  0.00 cusr  0.00 csys =  0.09 CPU)
ATIS: Total time: 12 wallclock secs ( 8.39 usr  1.84 sys +  0.00 cusr  0.00 csys = 10.23 CPU)
big-tables: Total time: 13 wallclock secs ( 5.60 usr  3.57 sys +  0.00 cusr  0.00 csys =  9.17 CPU)

pulf

帮你顶一下吧。

acxellencedk

redhatAS4.0+MYSQL4.1.20的环境：


[root@hss2 sql-bench]# ./test-connect -user root  -p admin123  
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 47) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Proxy, Sponge.
at /tmp/sql-bench/server-cfg line 240
Compilation failed in require at ./test-connect line 36.

huhuegg

安装dbd-mysql包就好了