MySQL客户端工具MySQL slap概述.docx

MySQL客户端工具MySQL_slap概述
 
 
知识可以迟到，但是却始终不会缺席哒~Amy今天为大家介绍MySQLslap的相关内容，希望能够给大家带来帮助哦~
1 . 简介
mysqlslap是一个诊断程序，旨在模cho 1" --pre-query="select 2" --post-query="select 3" --post-system="echo 4" --delimiter=";" --query="SELECT * FROM a;select 0;" --create="CREATE TABLE a (b int);INSERT INTO a VALUES (23)"
mysqlslap: [Warning] unknown variable 'loose-default-character-set=utf8'
1
4
1
4
1
4
Benchmark
Running for engine myisam
Average number of seconds to run all queries: seconds
Minimum number of seconds to run all queries: seconds
Maximum number of seconds to run all queries: seconds
Number of clients running queries: 2
Average number of queries per client: 8
从一般日志可得到：可见语句执行逻辑符合简介中的原理及参数描述
2019-05-06T15:41: 20734 Connect ******@localhost on using TCP/IP
2019-05-06T15:41: 20734 Query SET sql_mode = ``
2019-05-06T15:41: 20734 Query DROP SCHEMA IF EXISTS `ztdslap`
2019-05-06T15:41: 20734 Query CREATE SCHEMA `ztdslap`
2019-05-06T15:41: 20734 Init DB ztdslap
2019-05-06T15:41: 20734 Query set default_storage_engine=`myisam`
2019-05-06T15:41: 20734 Query CREATE TABLE a (b int)
2019-05-06T15:41: 20734 Query INSERT INTO a VALUES (23)
2019-05-06T15:41: 20734 Query SET AUTOCOMMIT=0
2019-05-06T15:41: 20734 Query select 2
2019-05-06T15:41: 20735 Connect ******@localhost on ztdslap using TCP/IP
2019-05-06T15:41: 20735 Query SET AUTOCOMMIT=0
2019-05-06T15:41: 20735 Query SELECT * FROM a
2019-05-06T15:41: 20736 Connect ******@localhost on ztdslap using TCP/IP
2019-05-06T15:41: 20735 Query select 0
2019-05-06T15:41: 20736 Query SET AUTOCOMMIT=0
2019-05-06T15:41: 20735 Query SELECT * FROM a
2019-05-06T15:41: 20736 Query SELECT * FROM a
2019-05-06T15:41: 20735 Query COMMIT
2019-05-06T15:41: