java - JMeter jdbc :mysql error

Question

我正在尝试在远程数据库服务器上设置一个 JMeter 服务器/客户端实例。我已经在服务器上提取了 JMeter，将 MySQL java 连接器复制到 $JMETER_HOME/lib 并启动了 JMeter-server 监听器。在客户端(我的本地桌面)上，我已将 JMeter 客户端指向远程服务器(通过 $JMETER_HOME/bin/jmeter.properties 中的 remote_hosts 条目)。每当我尝试在客户端上运行 MySQL 加载作业时(运行 -> 远程启动 -> )，我都会收到以下错误:

Response message: java.sql.SQLException: No suitable driver found for jdbc:mysql://1.2.3.4/database

这是在服务器端:

2013/04/10 12:44:43 WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver found for jdbc:mysql://1.2.3.4/dbname at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:185) at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672) at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:178) at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123) at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:402) at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130) at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222) at org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:286) at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:146) at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:85) at org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:428) at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:256) at java.lang.Thread.run(Thread.java:662)

有谁知道为什么即使 Java 连接器位于 jmeter lib 目录中也无法正常工作？

Answer 1

事实证明，我们运行的 Percona MySQL 版本需要特定版本的连接器。把它放进去，一切都解决了。