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