Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 使用Jmeter对Mysql进行压力测试无法执行多条sql语句问题_MySQL

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

WBOY
Release： 2016-06-01 13:56:17
Original
1130 people have browsed it

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

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

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

Related labels：
sql syntax pressure test
source：php.cn
Previous article：数据库的跨平台设计_MySQL Next article：计算指定年月的最后一天的自定义MYSQL函数_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
Can a workerpool declared in multiple routes still maintain its cpu usage without caring about the threshold I'm hoping to find a node.js system with a workerpool to handle CPU intensive tasks, but I...
From 2024-04-06 19:54:23
0
1
444
How to select multiple checkboxes in Reactjs I have a list of options in which I want to select multiple checkboxes but am unable to do...
From 2024-04-06 18:55:21
0
1
396
MySQL gets data from multiple tables I have a eg_design table which contains the following columns: and eg_domains table which ...
From 2024-04-06 18:42:44
0
2
479
Invalid React child element (found: Object with key {clientVersion}). If you want to render a collection of child elements, use an array instead I have a multi-step form and when I try to submit it shows this error. However, if I use c...
From 2024-04-06 16:25:39
0
1
346
Mysql returns some records as empty in date field because date has multiple formats I am trying to analyze order_date column and the column has multiple date formats and I wa...
From 2024-04-06 13:29:40
0
1
466
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template