Concurrent Database Stress test shell script code _linux Shell

Copy Code code as follows:

#!/bin/bash
#********************************#
#并发后台运行fun #
#for Wanggy 2012-01-25 #
#note: #
#fun_num Fun function Background Run number #
#sql_num How many times per function SQL runs #
#********************************#
#数据库变量设置
dbhost=192.168.1.182
Dbbase=recharge
Dbuser=infosms
Dbpass=infosms
Fun ()
{
#函数并发次数
Fun_num=5
#函数内sql执行次数
sql_num=1000
For ((j=1;j<= $fun _num;j++));d o
{
Random_num= ' echo $RANDOM '
echo "$j function"
For ((i=1;i<= $call _num;i++));d o
Mysql-h$dbhost-u$dbuser-p$dbpass-d$dbbase <<getrecode >>fun_$j.log
Call Fun_accountbycustid (2,0,10. $random _num)
Getrecode
echo "$j a function $i times"
echo "$j a function $i times" >>call.log
Done
echo "$j function execution Complete ..."
}&
Done
Wait
}
Main ()
{
Fun
}
Main
Exit 0