Use JMeter to BULK insert data into MySQL

1. Start Jmeter

2.      add   dbc Connection Configuration

-> add -> Configuring Components ->jdbc Connection Configuration

650) this.width=650; "src=" http://s2.sinaimg.cn/mw690/005NDN77gy723CyxNW9f1&690 "height=" 325 "width=" 558 "name= "image_operate_2841464491320697" alt= "JMeter <wbr> Insert data using JMeter Bulk database" title= "JMeter <wbr> Use JMeter Bulk database to insert data "style=" margin:0px;padding:0px;border:0px;list-style:none; "/>

Make the necessary configuration after adding

3. add parameterized Required variables

Configuration

650) this.width=650; "Src=" Https://s4.51cto.com/wyfs02/M00/9D/10/wKioL1l5lxnQpkvHAAAxSO5tvTs171.png "title=" Sp170727_153229.png "alt=" Wkiol1l5lxnqpkvhaaaxso5tvts171.png "/>
 

4.      add JDBC Request

Right-click Thread Group - Add ->SAMPLER->JDBC Request

650) this.width=650; "Src=" http://s4.sinaimg.cn/mw690/005NDN77gy723D00Nh1c3&690 "height=" 384 "width=" 538 "name=" Image_operate_ 86891464491037560 "alt=" jmeter <wbr> using JMeter Bulk database to insert data "title=" jmeter <wbr> Use JMeter Bulk database to insert data "style=" margin:0px;padding:0px;border:0px;list-style:none; "/>

 

Configuration:

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/9D/10/wKiom1l5l1zxEP_WAABMv7UWbQ8566.png "title=" Sp170727_153336.png "alt=" Wkiom1l5l1zxep_waabmv7uwbq8566.png "/>

4.1 Inserting 1000 data

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/9D/10/wKioL1l5l4fDFnCYAAAn3EehkOw074.png "title=" Sp170727_153420.png "alt=" Wkiol1l5l4fdfncyaaan3eehkow074.png "/>

5. Add View results Tree

 650) this.width=650; " Src= "http://s6.sinaimg.cn/mw690/005NDN77gy723DiTvlbe5&690" height= "501" width= "558" name= "Image_operate_ 61211464491681057 "alt=" jmeter <wbr> using JMeter Bulk database to insert data "title=" jmeter <wbr> Use JMeter Bulk database to insert data "style=" margin:0px;padding:0px;border:0px;list-style:none; "/>

6. Finally, after you have configured the thread group as necessary, run the view

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/9D/10/wKiom1l5l7fi5Q6WAAAhBR1jomw060.png "title=" Sp170727_153504.png "alt=" Wkiom1l5l7fi5q6waaahbr1jomw060.png "/>

This article from the "32 Krypton" blog, reproduced please contact the author!

Use JMeter to BULK insert data into MySQL