Benchmark
Average number of seconds to run all queries: 31.633 seconds
Minimum number of seconds to run all queries: 31.269 seconds
Maximum number of seconds to run all queries: 32.194 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Average number of seconds to run all queries: 27.778 seconds
Minimum number of seconds to run all queries: 27.436 seconds
Maximum number of seconds to run all queries: 28.119 seconds
Number of clients running queries: 100
Average number of queries per client: 100
Benchmark
Average number of seconds to run all queries: 11.222 seconds
Minimum number of seconds to run all queries: 10.831 seconds
Maximum number of seconds to run all queries: 11.577 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Average number of seconds to run all queries: 7.164 seconds
Minimum number of seconds to run all queries: 6.961 seconds
Maximum number of seconds to run all queries: 7.522 seconds
Number of clients running queries: 100
Average number of queries per client: 100
3、优化做了目录映射共享的mysql容器
3.1、优化过程
查看磁盘管理配置文件:cat /etc/fstab
# <file system> <mount point> <type> <options> <dump> <pass>
# / was on /dev/sdb2 during installation
UUID=d91c81a0-74ed-4b1d-b5d3-e8862add46d1 / ext4 errors=remount-ro 0 1
# swap was on /dev/sdb3 during installation
UUID=0f106376-1f87-4c53-865c-01688b4f72da none swap sw 0 0
barrier=none / barrier=flush
This disables / enables the use of write barriers in the journaling code.
barrier=none disables, barrier=flush enables (default). This also requires an IO
stack which can support barriers, and if reiserfs gets an error on a barrier write,
it will disable barriers again with a warning. Write barriers enforce proper on-
disk ordering of journal commits, making volatile disk write caches safe to use, at
some performance penalty. If your disks are battery-backed in one way or another,
disabling barriers may safely improve performance.
Benchmark
Average number of seconds to run all queries: 10.431 seconds
Minimum number of seconds to run all queries: 9.800 seconds
Maximum number of seconds to run all queries: 11.022 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Average number of seconds to run all queries: 6.848 seconds
Minimum number of seconds to run all queries: 6.563 seconds
Maximum number of seconds to run all queries: 7.196 seconds
Number of clients running queries: 100
Average number of queries per client: 100