Python Server端性能测试 - Mock环境搭建

tidewang2k

于 2015-01-07 18:07:02 发布

阅读量266

点赞数

分类专栏： db 文章标签： automation test tool python

本文链接：https://blog.csdn.net/tidewang2k/article/details/42497255

版权

这篇博客探讨了如何进行Python服务器端的性能测试，重点在于如何搭建Mock环境。内容包括模拟删除用户（id>6000）和从groups表中选择id大于27的记录的SQL操作，以及两个存储过程`sp_deleteDevices`和`sp_updateDevices`的详细步骤，这些存储过程用于批量处理和更新devices表中的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1, create a stored procedure in mysql;

   1, copy sp.sql to /root/ on dev01o

   2, log on mysql

   3, source /root/sp.sql

2,   delete devices where id>24000;

3, delete users where id >6000;

4, execute sql: call sp_deleteDevices;

5, export device data:

1: create an view in mysql
create view view_devices as select `d`.`Id` AS `Id`,`d`.`Udid` AS `Udid`,`d`.`SerialNumber` AS `SerialNumber`,`d`.`MacAddress` AS `MacAddress`,`d`.`Imei` AS `Imei`,`d`.`AssetNumber` AS `AssetNumber`,`d`.`DeviceFriendlyName` AS `DeviceFriendlyName`,`g`.`Name` AS `LocationGroupName`,`l`.`DisplayName` AS `GroupLocation`,`u`.`UserNam

最低0.47元/天解锁文章