Home >Database >Mysql Tutorial >使用Jmeter对Mysql进行压力测试无法执行多条sql语句问题_MySQL

使用Jmeter对Mysql进行压力测试无法执行多条sql语句问题_MySQL

WBOY
WBOYOriginal
2016-06-01 13:56:171124browse

执行一条语句可以,多条语句则出错,查询Jmter日志,告知sql语法错误。

后来发现需要allowMultiQueries参数置为true,而且,只有MySQL Connector/J 3.1.1以上版本才支持。

建立连接时设置一下就可以了,如:jdbc:mysql://192.168.3.180/sample?user=root&password=&allowMultiQueries=true

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn