mysqlslap测试并发
<h3>使用mysqlslap测试并发以及用 mysql workbench检测吞吐量</h3>
<pre><code>测试带有索引的数据库语句select * from agency where name ='1' limit 100</code></pre>
<p>以下是的数据量测试并发 使用的虚拟机是8G 16核 30G硬盘
测试环境是在虚拟机41上测试44这台虚拟机的并发和吞吐量
在mysql/bin在</p>
<pre><code>输入./mysqlslap -h192.168.1.41 -uroot -pkyd8899 --concurrency=100 --iterations=20 --create-schema=QIWUIOT --query="select * from agency where name='1' limit 100 ;" --engine=innodb --number-of-queries=220000</code></pre>
<table>
<thead>
<tr>
<th>数据量 （万）</th>
<th>线程数</th>
<th>总查询数（万）</th>
<th>测试环境</th>
<th>吞吐量</th>
<th>1个线程处理（总查询数/线程数）时间</th>
<th>单个语句处理时间</th>
<th>速率MB/s</th>
</tr>
</thead>
<tbody>
<tr>
<td>500w</td>
<td>100</td>
<td>22w</td>
<td>本机windows环境测试41虚拟机</td>
<td>7000~8000</td>
<td></td>
<td>0.003s</td>
<td>33MB/s</td>
</tr>
<tr>
<td>500w</td>
<td>100</td>
<td>22 w</td>
<td>44虚拟机与41虚拟机</td>
<td>35000~36000</td>
<td></td>
<td>0.003s</td>
<td>156MB/s</td>
</tr>
<tr>
<td>1000w</td>
<td>100</td>
<td>22w</td>
<td>本机windows环境与41虚拟机</td>
<td>7817</td>
<td>118/2200=0.08s</td>
<td>0.003s</td>
<td>33MB/s</td>
</tr>
<tr>
<td>1000w</td>
<td>100</td>
<td>22 w</td>
<td>44虚拟机测试41虚拟机</td>
<td>40835</td>
<td>16/2200=0.007s</td>
<td>0.003s</td>
<td>174MB/s</td>
</tr>
<tr>
<td>2000w</td>
<td>100</td>
<td>22w</td>
<td>本机windows与测试41虚拟机</td>
<td>7785左右</td>
<td>174/2200=0.079s</td>
<td>0.004s</td>
<td>33MB/s</td>
</tr>
<tr>
<td>2000w</td>
<td>100</td>
<td>22w</td>
<td>41虚拟机与测试41虚拟机</td>
<td>27418~28000</td>
<td>24/2200=0.011s</td>
<td>0.004s</td>
<td>120MB/s</td>
</tr>
<tr>
<td>4000w</td>
<td>100</td>
<td>22w</td>
<td>本机windows与测试41虚拟机</td>
<td>7770~7804</td>
<td>173/2200=0.078s</td>
<td>0.002s</td>
<td>33.75MB/s</td>
</tr>
<tr>
<td>4000w</td>
<td>100</td>
<td>22w</td>
<td>41虚拟机与测试41虚拟机</td>
<td>37248左右</td>
<td>18/2200=0.008s</td>
<td>0.004s</td>
<td>161.9MB/s</td>
</tr>
<tr>
<td>5000w</td>
<td>100</td>
<td>22w</td>
<td>本机windows与测试41虚拟机</td>
<td>7534~7850</td>
<td>173/2200=0.078s</td>
<td>0.004s</td>
<td>33MB/s</td>
</tr>
<tr>
<td>5000w</td>
<td>100</td>
<td>22w</td>
<td>41虚拟机与测试41虚拟机</td>
<td>37133~39151</td>
<td>17.239/2200=0.0077s</td>
<td>0.004s</td>
<td>163.57MB/s</td>
</tr>
<tr>
<td>6000w</td>
<td>100</td>
<td>22w</td>
<td>本机windows与测试41虚拟机</td>
<td>5251~7850</td>
<td>191/2200=0.086s</td>
<td>0.003s</td>
<td>33.63MB/s</td>
</tr>
<tr>
<td>6000w</td>
<td>100</td>
<td>22w</td>
<td>41虚拟机与测试41虚拟机</td>
<td>35353左右</td>
<td>18/2200=0.008s</td>
<td>0.004s</td>
<td>149MB/s</td>
</tr>
<tr>
<td>6000w</td>
<td>200</td>
<td>22w</td>
<td>41虚拟机与测试41虚拟机</td>
<td>35178左右</td>
<td>18/1100=0.016s</td>
<td>0.004s</td>
<td>150MB/s</td>
</tr>
<tr>
<td>6500w</td>
<td>100</td>
<td>22w</td>
<td>本机windows与测试41虚拟机</td>
<td>5127~7319</td>
<td>199.9/2200=0.09s</td>
<td>0.003s</td>
<td>33MB/s</td>
</tr>
<tr>
<td>6500w</td>
<td>100</td>
<td>22w</td>
<td>41虚拟机与测试41虚拟机</td>
<td>35566左右</td>
<td>18.36/2200=0.0083s</td>
<td>0.004s</td>
<td>148MB/s</td>
</tr>
</tbody>
</table>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitfile/sign/cb13cffb8da7ce691b258907cfe5298a" alt="" /></p>