Get the App
SLTechnology News&Howtos  ›  Development  › 

How to implement shell script Code for concurrent Database stress Test

Shulou Source: shulou.com Published: 2022-06-03 07:41:11 11月16日 Update

This article is about how to implement the shell script code for concurrent database stress testing. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The code is as follows:

#! / bin/bash

# *

# running fun concurrently in the background #

# for wanggy 2012-01-25 #

# note: #

# number of times the fun_num fun function runs in the background #

# sql_num number of sql runs per function #

# *

# Database variable settings

Dbhost=192.168.1.182

Dbbase=recharge

Dbuser=infosms

Dbpass=infosms

Fun ()

{

# the number of concurrent functions

Fun_num=5

# number of times sql is executed within the function

Sql_num=1000

For ((jcu1witjcall.log)

Done

Echo "the execution of the $j function is complete."

} &

Done

Wait

}

Main ()

{

Fun

}

Main

Exit 0

Thank you for reading! This is the end of this article on "how to achieve shell script code for concurrent database stress testing". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Tags: Function number code data database run pressure script test content background more article good practical variable article see knowledge reference Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker Microsoft Shulou Information Xiaomi vpn