- 浏览: 999508 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (529)
- 服务器 (8)
- jsp (1)
- java (6)
- AIX (1)
- solaris (3)
- linux学习 (53)
- javaScript (2)
- hibernate (1)
- 数据库 (74)
- sql语句 (8)
- oracle 学习 (75)
- oracle 案例 (42)
- oracle 管理 (42)
- Oracle RAC (27)
- oracle data guard (12)
- oracle 参数讲解 (14)
- Oracle 字符集 (8)
- oracle性能调优 (24)
- oracle备份与恢复 (12)
- oracle Tablespace (9)
- oracle性能诊断艺术 (1)
- oracle 11g学习 (5)
- oracle streams (1)
- oracle upgrade and downgrade (4)
- db2学习 (13)
- db2命令学习 (2)
- mysql (28)
- sql server (30)
- sql server 2008 (0)
- 工具 (10)
- 操作系统 (3)
- c++ (1)
- stock (1)
- 生活 (5)
- HADOOP (2)
最新评论
-
massjcy:
...
如何将ubuntu文件夹中文名改为英文 -
skypiea:
谢谢。。。
终于解决了。。。
Oracle 10.2.0.4(5)EM不能启动的解决方案(Patch 8350262) -
qwe_rt:
引用vi /etc/sysconfig/network 请问 ...
Linux操作系统下配置静态IP上网 -
liuqiang:
sudo killall -9 apache2
ps 和 kill 命令详解 -
dazuiba:
引用*绝杀 kill -9 PID 当使用此命令时,一定要通过 ...
ps 和 kill 命令详解
sysbench是一款开源的多线程性能测试工具,可以执行CPU/内存/线程/IO/数据库等方面的性能测试。数据库目前支持MySQL/Oracle/PostgreSQL。本文只是简单演示一下几种测试的用法,后续准备利用sysbench来对MySQL进行一系列的测试。具体的一些参数设置,需要根据不同的测试要求来进行调整。
下载
http://sourceforge.net/projects/sysbench/
编译安装
默认支持MySQL,如果需要测试Oracle/PostgreSQL,则在configure时需要加上–with-oracle或者–with-pgsql参数
./configure --prefix=/u01/sysbench \ --with-mysql-includes=/opt/mysql/include/mysql \ --with-mysql-libs=/opt/mysql/lib/mysql make && make install
参数
NinGoo:/u01/sysbench/bin>$sysbench Missing required command argument. Usage: sysbench [general-options]... --test= [test-options]... command General options: --num-threads=N number of threads to use [1] --max-requests=N limit for total number of requests [10000] --max-time=N limit for total execution time in seconds [0] --forced-shutdown=STRING amount of time to wait after --max-time before forcing shutdown [off] --thread-stack-size=SIZE size of stack per thread [32K] --init-rng=[on|off] initialize random number generator [off] --test=STRING test to run --debug=[on|off] print more debugging info [off] --validate=[on|off] perform validation checks where possible [off] --help=[on|off] print help and exit --version=[on|off] print version and exit Compiled-in tests: fileio - File I/O test cpu - CPU performance test memory - Memory functions speed test threads - Threads subsystem performance test mutex - Mutex performance test oltp - OLTP test Commands: prepare run cleanup help version See 'sysbench --test= help' for a list of options for each test.
CPU测试
sysbench采用寻找最大素数的方式来测试CPU的性能
NinGoo:/u01/sysbench/bin>$sysbench --test=cpu --cpu-max-prime=2000 run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Doing CPU performance benchmark Threads started! Done. Maximum prime number checked in CPU test: 2000 Test execution summary: total time: 2.3996s total number of events: 10000 total time taken by event execution: 2.3917 per-request statistics: min: 0.23ms avg: 0.24ms max: 27.44ms approx. 95 percentile: 0.24ms Threads fairness: events (avg/stddev): 10000.0000/0.00 execution time (avg/stddev): 2.3917/0.00
线程测试
NinGoo:/u01/sysbench/bin>$sysbench --test=threads --num-threads=64 --thread-yields=100 \ --thread-locks=2 run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 64 Doing thread subsystem performance test Thread yields per test: 100 Locks used: 2 Threads started! Done. Test execution summary: total time: 4.3925s total number of events: 10000 total time taken by event execution: 280.4418 per-request statistics: min: 0.04ms avg: 28.04ms max: 72.81ms approx. 95 percentile: 52.29ms Threads fairness: events (avg/stddev): 156.2500/1.43 execution time (avg/stddev): 4.3819/0.01
文件IO性能测试
首先生成需要的测试文件,文件总大小300M,16个并发线程,随机读写模式。执行完后会在当前目录下生成一堆小文件。
NinGoo:/u01/sysbench/bin>$sysbench --test=fileio --num-threads=16 \ --file-total-size=300M --file-test-mode=rndrw prepare sysbench 0.4.12: multi-threaded system evaluation benchmark 128 files, 2400Kb each, 300Mb total Creating files for the test...
执行测试
NinGoo:/u01/sysbench/bin>$sysbench --test=fileio --num-threads=16 \ --file-total-size=300M --file-test-mode=rndrw run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 16 Extra file open flags: 0 128 files, 2.3438Mb each 300Mb total file size Block size 16Kb Number of random requests for random IO: 10000 Read/Write ratio for combined random IO test: 1.50 Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random r/w test Threads started! Done. Operations performed: 5996 Read, 4004 Write, 12800 Other = 22800 Total Read 93.688Mb Written 62.562Mb Total transferred 156.25Mb (26.713Mb/sec) 1709.66 Requests/sec executed Test execution summary: total time: 5.8491s total number of events: 10000 total time taken by event execution: 12.5045 per-request statistics: min: 0.01ms avg: 1.25ms max: 373.28ms approx. 95 percentile: 0.03ms Threads fairness: events (avg/stddev): 625.0000/109.60 execution time (avg/stddev): 0.7815/0.29
清理现场
NinGoo:/u01/sysbench/bin>$sysbench --test=fileio --num-threads=16 \ --file-total-size=300M --file-test-mode=rndrw cleanup sysbench 0.4.12: multi-threaded system evaluation benchmark Removing test files...
Mutex测试
NinGoo:/u01/sysbench/bin>$sysbench --test=mutex --num-threads=16 \ --mutex-num=1024 --mutex-locks=10000 --mutex-loops=5000 run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 16 Doing mutex performance test Threads started! Done. Test execution summary: total time: 1.1561s total number of events: 16 total time taken by event execution: 18.3831 per-request statistics: min: 1084.60ms avg: 1148.94ms max: 1153.52ms approx. 95 percentile: 10000000.00ms Threads fairness: events (avg/stddev): 1.0000/0.00 execution time (avg/stddev): 1.1489/0.02
内存测试
NinGoo:/u01/sysbench/bin>$sysbench --test=memory --num-threads=16 \ --memory-block-size=8192 --memory-total-size=1G run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 16 Doing memory operations speed test Memory block size: 8K Memory transfer size: 1024M Memory operations type: write Memory scope type: global Threads started! WARNING: Operation time (0.000000) is less than minimal counted value, counting as 1.000000 WARNING: Percentile statistics will be inaccurate Done. Operations performed: 131072 (114162.68 ops/sec) 1024.00 MB transferred (891.90 MB/sec) Test execution summary: total time: 1.1481s total number of events: 131072 total time taken by event execution: 16.0448 per-request statistics: min: 0.00ms avg: 0.12ms max: 3.60ms approx. 95 percentile: 0.01ms Threads fairness: events (avg/stddev): 8192.0000/192.89 execution time (avg/stddev): 1.0028/0.00
MySQL数据库测试
首先需要创建默认的sbtest数据库,或者使用–mysql-db指定一个已经存在的数据库
生成测试数据,引擎为myisam,表大小为1000000条记录
NinGoo:/u01/sysbench/bin>$sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=1000000 \ --mysql-user=root --mysql-socket=/opt/mysql/run/mysql.sock prepare sysbench 0.4.12: multi-threaded system evaluation benchmark No DB drivers specified, using mysql Creating table 'sbtest'... Creating 1000000 records in table 'sbtest'... root@sbtest 11:42:18>desc sbtest.sbtest; +-------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | k | int(10) unsigned | NO | MUL | 0 | | | c | char(120) | NO | | | | | pad | char(60) | NO | | | | +-------+------------------+------+-----+---------+----------------+
执行测试
NinGoo:/u01/sysbench/bin>$sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=1000000 \ --mysql-user=root --mysql-socket=/opt/mysql/run/mysql.sock run sysbench 0.4.12: multi-threaded system evaluation benchmark No DB drivers specified, using mysql Running the test with following options: Number of threads: 1 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "LOCK TABLES WRITE" for starting transactions Using auto_inc on the id column Maximum number of requests for OLTP test is limited to 10000 Threads started! Done. OLTP test statistics: queries performed: read: 140000 write: 50000 other: 20000 total: 210000 transactions: 10000 (336.64 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 190000 (6396.11 per sec.) other operations: 20000 (673.27 per sec.) Test execution summary: total time: 29.7056s total number of events: 10000 total time taken by event execution: 29.6301 per-request statistics: min: 2.27ms avg: 2.96ms max: 43.88ms approx. 95 percentile: 3.36ms Threads fairness: events (avg/stddev): 10000.0000/0.00 execution time (avg/stddev): 29.6301/0.00
清理现场
NinGoo:/u01/sysbench/bin>$sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=1000000 \ --mysql-user=root --mysql-socket=/opt/mysql/run/mysql.sock cleanup sysbench 0.4.12: multi-threaded system evaluation benchmark No DB drivers specified, using mysql Dropping table 'sbtest'... Done.
发表评论
-
Permission denied: exec of '/usr/local/nagios/sbin/status.cgi' failed
2012-07-16 18:26 3938nagios登陆正常,但是访问所有的服务出错,检查nagios ... -
SwingBench配置
2012-07-16 13:37 2064SwingBench是一个Oracle压力 ... -
QPS、PV和需要部署机器数量计算公式(转)
2012-06-18 13:41 1416QPS、PV和需要部署机器数量计算公式(转) 术 ... -
QPS、PV和需要部署机器数量计算公式(转)
2012-06-18 13:41 0QPS、PV和需要部署机器数量计算公式(转) 术 ... -
Oracle SQL 调优健康检查脚本
2012-05-15 17:25 1111我们关注数据库系统的性能,进行数据库调优的主要工作就是进行SQ ... -
puppet运维自动化之puppet基础知识介绍
2012-05-09 16:54 1361【puppet 基础导读】 pup ... -
nagios安装注意点
2012-01-17 00:22 4095装了最新版nagios(3.3.1),在装得过程遇到如下问题: ... -
通过开源工具orabm计算TPS值来测试服务器CPU性能
2011-06-02 02:11 1819测试平台: RHEL4.8 x8_64 + Oracle ... -
Maatkit--Mysql的高级管理工具集
2011-03-24 16:01 5481Maatkit是Mysql的一个高级管理工具集。 官方网站:h ... -
Xtrabackup:MySQL DBA的必备工具
2011-03-24 15:53 1773Xtrabackup是percona开发的产品,可以看做是In ...
相关推荐
MySQL 性能测试工具sysbench安装使用
数据库经典压测工具sysbench双版本 sysbench0.5支持oracle sysbench1.1 支持达梦 附详细安装文档,亲测可用
mysql性能测试工具:sysbench+资源(autoconf、automake、libtool)
linux性能测试工具-sysbench使用方法,可以mysql读写性能
mysql 性能测试工具sysbench 0.4.12.10版本
sysbench是一个模块化、跨平台、多线程基准测试工具,主要用于测试不同系统参数下的数据库负载情况,本文主要介绍0.4版本的使用...sysbench主要用于以下性能测试: 文件I/O性能 调度 内存分配和传输 POSIX线程 数据库
数据库的基准测试是对数据库的性能指标进行定量的、可复现的、可对比的测试。基准测试与压力测试 基准测试可以理解为针对系统的一种压力测试。但基准测试不关心业务逻辑,更加简单、直接、易于测试,数据可以由工具...
sysbench是一个开源的、模块化的、跨平台的多线程性能测试工具,可以用来进行CPU、内存、磁盘I/O、线程、数据库的性能测试。目前支持的数据库有MySQL、Oracle和PostgreSQL。 官方站点:...
sysbench是一个多线程性能测试工具,可以进行CPU/内存/IO/数据库等性能测试。不过我绝大多数的时候都是用它来对数据库(MySQL)进行oltp测试。它能测哪些东西,怎么测让我从它的命令帮助来回答。 ~/zbs$ sysbench –...
Mysql数据库本身提供了比较优秀的性能测试工具,这里另外介绍下sysbench。Sysbench主要的测试方法有: 之前介绍了相关mysql的性能参数调优,这些天利用基准测试工具对mysql的测试,Jason留下点Memory。 Mysql...
sysbench是一个模块化的、跨平台、多线程基准测试工具,主要用于评估测试各种不同系统参数下的数据库负载情况。关于这个项目的详细介绍请看:http://sysbench.sourceforge.net。 它主要包括以下几种方式的测试: 1、...
sysbench 支持的测试有CPU运算性能测试、内存分配及传输速度测试、磁盘IO性能测试、POSIX线程性能测试、互斥性测试测试、数据库性能测试(OLTP基准测试)。目前支持的数据库主要是MySQL数据库和PG数据库。 在新服务器...
sysbench是一个模块化的、跨平台、多线程基准测试工具,主要用于评估测试各种不同系统参数下的数据库负载情况。 目前sysbench代码托管在launchpad上,项目地址:https://launchpad.net/sysbench(原来的官网 ...
sysbench是一款开源的多线程性能测试工具,可以执行CPU/内存/线程/IO/数据库等方面的性能测试。数据库目前支持MySQL/Oracle/PostgreSQL。本文只是简单演示一下几种测试的用法,后续准备利用sysbench来对MySQL进行一...
mysql官方基准测试工具,内含linux6.x版本和linux7.x版本的安装tar包,另附详细的安装说明和sysbench的使用说明,包括详尽的测试参数说明和性能测试方式说明,sysbench版本为1.0.8