以下脚本主要是测试分库分表并发insert操作。可根据具体需求进行sql修改。
部署操作:
1、安装必要包并复制文本:
yum install -y freetds-devel.x86_64 / apt-get install freetds-dev
pip install pymysql
vim polar_test.py
i
2、付可执行权限并执行:
chmod +x polar_test.py
./polar_test.py
#coding:utf-8
import time
import threading
from time import ctime
row_count=1000000000 #共计插入数据令
threads_count = 48 #并发线程数
import pymysql
def time_me(fn):
@time_me
def ordinary_insert(count):
local_var=threading.local()
def Clean(args):
threads=[]
for i in range(threads_count):
print ('start:', ctime())
start = time.time()
if __name__ == '__main__':
seconds = time.time() - start
print ('end:', ctime())
print("{func}函数每{count}条数数据写入耗时{sec}秒".format(func='ordinary_insert', count=row_count, sec=seconds))