代码改变世界

Jmeter连接mysql成功

2017-01-21 21:11  zouhui  阅读(304)  评论(0编辑  收藏  举报

1 下载,mysql-connector-odbc-5.3.4-winx64.msi 进行安装  《转载》

2 安装后, copy “C:\ProgramFiles (x86)\MySQL\MySQL Connector J\ mysql-connector-java-5.1.33-bin.jar”to  ..\apache-jmeter-2.9\lib

3 增加环境变量,Add CLASSPATH=.;...;%JMETER_HOME%\lib\mysql-connector-java-5.1.33-bin.jar;

4 配置数据源,mysqlsource

wKioL1iDXvKzb1J8AABjJ7h0YKQ065.png-wh_50

5 jmeter设置,增加配置元件jdbc con,增加采集器jdbc req,增加响应断言,增加监听器查看结果树;运行jmeter;查看结果;

jdbc connection configuration  

wKiom1iDXyCTEJgQAABhqhbsiUw606.png-wh_50


jdbc request

wKiom1iDX13hXiF5AAA8u7io8fw089.png-wh_50


查看结果树

wKioL1iDX26xcraHAABrwWsAGKg324.png-wh_50



另:查询结果数据过多时,出现错误日志:java head space    OutOfMemoryError