Jmeter学习（四）

﹏ヽ暗。殇╰゛Y 2021-09-24 07:58 401阅读 0赞

性能测试-mysql数据库

分布式性能测试

监听器以及测试结果分析

性能测试结果分析与报告

一：性能测试-数据库

需求：测试用户表

1:加入mysql-connector-java-5.1.41-bin.jar包

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70][]

2:jdbc的配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 1][]

![20200525110944490.png][]

3：jdbc请求

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 2][]

现在做的额是select(根据具体需要选择)

![20200525111140104.png][]

![20200525111432156.png][]

4：加其他

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 3][]

然后运行报错了

Variable Name must not be null in JDBCrequest

解决方法：参考：[https://blog.csdn.net/yimiym/article/details/89445835][https_blog.csdn.net_yimiym_article_details_89445835]

![20200525113538240.png][]

![20200525113552711.png][]

运行可以了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 5][]

如果要实现同时多个不同用户使用不同的sql，可以通过把整条sql语句参数化来实现

如把sql语句放在csv文件中，然后在jdbc request的Query中使用参数代替$\{sql\_Statement\}

二：分布式性能测试

jmeter由java开发、耗内存、cpu

三：监听器以及测试结果分析

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 6][]

建议把Save File Name、Save Assertion Failure Message勾上

![2020052511580466.png][]

大概，不一定对应

![20200525120341982.png][]

四：性能测试结果分析与报告

参考学习：[https://www.bilibili.com/video/BV1nt411s78b?p=17][https_www.bilibili.com_video_BV1nt411s78b_p_17]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70]: /images/20210923/47a07be297a943f9957d96b7d17bc36e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 1]: /images/20210923/27f47c4f49d94a9f9b1cfab3a0948a0f.png
[20200525110944490.png]: /images/20210923/8ea3445ce82a421a9e8083e314639d11.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 2]: /images/20210923/74f480da3fcd4d1a8ad36052163f7b57.png
[20200525111140104.png]: /images/20210923/345dc13eca334a3e90329ca69c3f2148.png
[20200525111432156.png]: /images/20210923/11fb774404944e498855547d0b135c73.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 3]: /images/20210923/6373272851d64c878834a3e7ba974ea8.png
[https_blog.csdn.net_yimiym_article_details_89445835]: https://blog.csdn.net/yimiym/article/details/89445835
[20200525113538240.png]: /images/20210923/c8239d7b874d481c8c799d0b16b7003f.png
[20200525113552711.png]: /images/20210923/54409ab2e7fe498c8cbbbaeca66c0a17.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 4]: /images/20210923/c33f6a7380e1414096a2195306deb247.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 5]: /images/20210923/fd14e06a745040b5a68c7febe0abbd66.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjcxNzkyOA_size_16_color_FFFFFF_t_70 6]: /images/20210923/b9a5e0d6696147c19a6072ec5a1da893.png
[2020052511580466.png]: /images/20210923/d24318f03765424e9e04a6d53d668362.png
[20200525120341982.png]: /images/20210923/c8e23bc72a1a44ef8362d0de92697527.png
[https_www.bilibili.com_video_BV1nt411s78b_p_17]: https://www.bilibili.com/video/BV1nt411s78b?p=17