![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
性能测试
Luke_wang
数据库、软件测试、编程、Linux
展开
-
单算子benchmark测试工具pgbench, SQL-bench, mydbtest
TPC:Transaction processing Performance Council 事务处理性能委员会TPC-B: measures throughput in terms of how many transactions per second a system can perform 测试一秒可以处理的事务个数pgbenchpgbench是基于tp原创 2017-11-03 21:00:14 · 1027 阅读 · 0 评论 -
Oracle wait event --- log file
www.itpub.net/thread-1777234-1-1.htmllog file switch(checkpoint incomplete):原因:1)存在大量update操作;2)log file size太小,导致log switch太频繁;3)log group太少;log file switch(private strand flush incomplete):log file ...原创 2018-02-07 22:29:27 · 423 阅读 · 0 评论 -
Oracle wait event --- buffer cache
http://m.blog.itpub.net/12679300/viewspace-1244578/Buffer Cache是SGA的一部分,Oracle利用Buffer Cache来管理data block,Buffer Cache的最终目的就是尽可能的减少磁盘I/O。 Buffer Cache中主要有3大结构用来管理Buffer Cache:Hash Bucket、Hash Chain Li...原创 2018-02-07 22:28:53 · 334 阅读 · 0 评论 -
Oracle wait event --- shared pool
https://blog.csdn.net/lqx0405/article/details/44777319Library cache包含了共享SQL区(shared SQL areas),私有SQL区(private SQLareas,如果配置了共享服务器),PL/SQL存储过程以及包,还有一些控制信息,比如说locks以及library cache handles。Dictionary cac...原创 2018-02-07 22:28:01 · 402 阅读 · 0 评论 -
Oracle wait event --- I/O
db file sequential read:db file scattered read, Avg wait time应当小于20ms 如果数据库执行全表扫描或者是全索引扫描会执行 Multi block I/O ,此时等待物理I/O 结束会出现此等待事件。一般会从应用程序(SQL),I/O 方面入手调整; 注意和《Instance Activity Stats》中的index fast ...原创 2018-02-07 22:27:09 · 382 阅读 · 0 评论 -
Oracle wait event --- enqueue
https://blog.csdn.net/notbaron/article/details/51284555latch: enqueue hash chainsenq: TX - row lock contentionenq: TX - index contentionenq: TX - contentionenq: HW - contentionenq: FB - contentionenq:...原创 2018-02-07 22:24:33 · 405 阅读 · 0 评论 -
Oracle wait event --- latch
latch free 其实是未获得latch ,而进入latch sleep,见《全面解析9i以后Oracle Latch闩锁原理》原创 2018-02-07 22:18:52 · 384 阅读 · 0 评论 -
Oracle wait event --- cluster
gc buffer waitgc current block 2-waygc cr multi block request原创 2018-02-07 22:12:03 · 950 阅读 · 0 评论 -
Oracle性能调优
http://www.toutiao.com/a6439484337649975554/ 善用性能工具进行SQL整体优化http://www.itpub.net/thread-1384552-1-1.html Oracle性能调优原理及具体手段https://wenku.baidu.com/view/31eb51270722192e4536f6f8.html Oracle内存全原创 2017-09-02 16:11:08 · 354 阅读 · 0 评论 -
数据库TPCE benchmark测试工具
http://www.pgcon.org/2007/schedule/attachments/35-TPC-E%20implementation-Mark-Wong-Rilson-Nascimento.pdf https://wenku.baidu.com/view/0ad580faf90f76c661371a0c.html https://www.baidu.com/link?u原创 2017-12-15 21:51:14 · 4532 阅读 · 0 评论 -
Sysbench安装和测试
http://www.perlmonks.org/?node_id=130699执行mysql测试sql-bench/test-select,报错Can't locate DBI.pm in @INCperl -MCPAN -e 'install DBI'perl -MCPAN -e 'install DBD::mysql'perl -MCPAN -e 'install原创 2017-05-14 00:09:28 · 658 阅读 · 0 评论 -
数据库TPCC benchmark测试工具对比
http://blog.chinaunix.net/uid-7589639-id-4126046.htmlhttp://www.cnblogs.com/conanwang/p/5910079.htmlhttp://imysql.cn/2014/10/17/sysbench-full-user-manual.shtmlsysbench:sysbench --test=fi原创 2017-05-13 18:44:29 · 5085 阅读 · 0 评论 -
压力测试工具
jMeter: java编写的压力测试工具http://jmeter.apache.org/usermanual/get-started.htmlLoadRunner:https://saas.hpe.com/en-us/software/loadrunner原创 2017-11-03 20:53:48 · 325 阅读 · 0 评论 -
Oracle ASM和ACFS
ASM原创 2017-11-03 20:51:52 · 1000 阅读 · 0 评论 -
Linux性能监控工具
topiostatsarperf原创 2017-06-03 18:19:56 · 300 阅读 · 0 评论 -
Oracle wait event --- latch: in memory undo latch
latch: in memory undo latch原创 2017-11-01 20:20:22 · 1235 阅读 · 0 评论 -
Linux内核参数解析
http://blog.csdn.net/kaka1121/article/details/51496387http://blog.chinaunix.net/uid-24907956-id-3428052.html原创 2017-09-30 22:31:53 · 1011 阅读 · 1 评论 -
Oracle wait event --- PGA
PGA memory operation原创 2018-05-01 10:58:45 · 1735 阅读 · 0 评论