python编写mysql和redis压测脚本

港控/mmm° 2023-01-01 01:50 49阅读 0赞

接上两篇文章的，单独写一下脚本的编写思路。  
[简易mysql压测教程-linux ubuntu下][mysql_-linux ubuntu]  
[简易redis压测教程-linux ubuntu下][redis_-linux ubuntu]

### 脚本一：压测mysql ###

import os
    import re
    import time
    
    b = os.system("mysqlslap -uroot -proot  --concurrency=1,50,100,200 --iterations=3 --number-char-cols=5 --number-int-cols=5 --auto-generate-sql --auto-generate-sql-add-autoincrement  --engine=myisam,innodb  --create-schema='enjoytest1'")
    
    
    while True:
        c = os.system('ps -ef >> ps.txt')
        with open('ps.txt', 'r') as f:
            e = re.findall('mysqlslap', f.read())
            if not e:
                os.system("mysqlslap -uroot -proot  --concurrency=1,50,100,200 --iterations=3 --number-char-cols=5 --number-int-cols=5 --auto-generate-sql --auto-generate-sql-add-autoincrement  --engine=myisam,innodb  --create-schema='enjoytest1'")
                time.sleep(3)
                print('mysql不在了，重新启动，3秒后再次检测')

### 脚本二：压测mysql和redis ###

import os
    import re
    import time
    
    a = os.system('redis-benchmark -q -n 100000')
    b = os.system("mysqlslap -uroot -proot  --concurrency=1,50,100,200 --iterations=3 --number-char-cols=5 --number-int-cols=5 --auto-generate-sql --auto-generate-sql-add-autoincrement  --engine=myisam,innodb  --create-schema='enjoytest1'")
    
    
    while True:
        c = os.system('ps -ef >> ps.txt')
        with open('ps.txt', 'r') as f:
            d = re.findall('benchmark', f.read())
            e = re.findall('mysqlslap', f.read())
            if not d:
                print('redis不在了，重新启动，3秒后再次检测')
                os.system('redis-benchmark -q -n 100000')
                time.sleep(3)
            elif not e:
                os.system("mysqlslap -uroot -proot  --concurrency=1,50,100,200 --iterations=3 --number-char-cols=5 --number-int-cols=5 --auto-generate-sql --auto-generate-sql-add-autoincrement  --engine=myisam,innodb  --create-schema='enjoytest1'")
                time.sleep(3)
                print('mysql不在了，重新启动，3秒后再次检测')

[mysql_-linux ubuntu]: https://blog.csdn.net/shuryuu/article/details/111947156
[redis_-linux ubuntu]: https://blog.csdn.net/shuryuu/article/details/111950157