askmaclean.com
【技术分享】开Oracle调优鹰眼,深入理解AWR性能报告
http://www.askmaclean.com/archives/awr-hawk-eyes-training.html
诗檀软件 邮箱: service@parnassusdata.com , ORACLE QQ群号 171092051,微信公众号: askMaclean. 了解 Maclean Liu 刘相兵 @诗檀软件. Oracle DUL Data Unloader数据恢复工具. Oracle DUL LEARN MORE. Oracle调优鹰眼系列只有2讲,对AWR感兴趣的同学更多指标可以参考 性能调优 Oracle AWR报告指标全解析 http:/ www.askmaclean.com/archives/performance-tuning-oracle-awr.html. Maclean Liu技术分享 开Oracle调优鹰眼,深入理解AWR性能报告 20130303版.pdf.pdf (1.79 MB, 下载次数: 32641). 涉及性能优化教学知识 Host CPU、Instance CPU、Wait Class、SQL Statistics、AWR FOR RAC集群特定调优. 企业级归档应用 Solix Big Data Suite 和 HDP HWX SolutionOverview Solix.
vmcd.org
Advanced Pagination for MySQL | VMCD.ORG
http://www.vmcd.org/2014/07/advance-for-mysql-pagination/comment-page-1
Advanced Pagination for MySQL. July 28, 2014. December 23, 2014. 在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如. SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t1`ORDER BY id DESC LIMIT 935500,10) t2 USING (id). 通过直接对id的操作 而不是整张表的扫描 通过id 的join 抓出符合条件id 然后通过ID 再去做数据的抓取。 不过这样也不是最佳的方法 还可以通过对id 的 range更加缩小范围 例如. Page size=100 select * from t where id 99 order by id asc limit $page size ; select * from t where id 199 order by id asc limit $page size;. Select * from t order by column1 desc limit 10. Leave...
vmcd.org
test | VMCD.ORG
http://www.vmcd.org/tag/test
PCIE performance test — LSI vs FusionIO vs VIRI. April 2, 2013. December 22, 2014. Testing three PCIE cards’s performance for all of scenes using fio. Reference: fio parameter setting. MySQL key partition and MongoDB TEST. March 8, 2013. December 22, 2014. 对于业务的激活码需求做了一次关于mysql,mongodb的比对.mysql分为normal,key partition 数量分别是1亿和10亿数据,mysql采用直接访问PK键,partition key为PK,mysql table size 为90G,mongodb table size为15[……]. Oracle Bind Graduation 测试. November 28, 2012. December 22, 2014. Mahir M. Quluzade. June 29, 2016.
vmcd.org
trouble shooting | VMCD.ORG
http://www.vmcd.org/tag/trouble-shooting
一次诡异的缓慢”死亡” CASE. September 13, 2013. December 22, 2014. 今天下午遇到的一个诡异CASE,现象为系统诡异的死亡,目前判定为sqluldr2工具导致 (同事使用sqluldr2 用具 执行了sqluldr2 linux64 10204.bin -help 命令). Sep 11 09:00:54[.]. March 19, 2013. December 22, 2014. TPCC对mysql 5.5.27做一次性能测试时遭遇 Segmentation fault,gdb调试记录之:. Root@db-81 ]# uname -a Linux db-81 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010[.]. 一次cursor: pin S wait on X的解决. November 2, 2011. December 19, 2014. Mahir M. Quluzade. Vmcd's mirror site. June 29, 2016. May 29, 2016.
vmcd.org
mysqlawr | VMCD.ORG
http://www.vmcd.org/tag/mysqlawr
MyAWR : MySQL Workload Report V3 release. December 2, 2014. December 23, 2014. 8212;———————–. V1: create by noodba. Mysql load information and system information. Some data collection display. August 21, 2014. December 23, 2014. Reference Oracle AWR. These two was developed by python and perl. Both of these are following data collection method. Use these tools can help[……]. MyAWR another mysql awr –That is Great! May 22, 2013. December 22, 2014. 开源了,第一版的reference 已经放出, tx to noodba. May 6, 2013.
askmaclean.com
ORACLE数据库恢复服务热线:13764045638,ORA-00600、Oracle数据库打不开 就找诗檀软件
http://www.askmaclean.com/know-maclean-liu
诗檀软件 邮箱: service@parnassusdata.com , ORACLE QQ群号 171092051,微信公众号: askMaclean. 了解 Maclean Liu 刘相兵 @诗檀软件. Oracle DUL Data Unloader数据恢复工具. Oracle DUL LEARN MORE. 了解 Maclean Liu 刘相兵 @诗檀软件. 有技术问题 快去t.askmaclean.com发帖,向老刘快速咨询. AskMaclean 技术博客文章入口 http:/ www.askmaclean.com/posts. ORACLE DB 技术学习QQ群号 171092051. MongoDB NOSQL 技术学习QQ群号 421431253. 百度版网站地图 http:/ www.askmaclean.com/sitemap.html. Google版网站地图 http:/ www.askmaclean.com/sitemap.xml. 向Maclean 提问Oracle技术问题 http:/ t.askmaclean.com/forum.php. 2012年7月Oracle C...
vmcd.org
Unix/Linux | VMCD.ORG
http://www.vmcd.org/unixlinux
Leave a Comment Cancel reply. Your email address will not be published. Required fields are marked *. Mahir M. Quluzade. Vmcd's mirror site. June 29, 2016. May 29, 2016. MySQL distributed message system. April 12, 2016. February 1, 2016. How to backup remote redis instance. January 29, 2016. Linux tools part 11 – Monitoring specified file-IO. December 28, 2015. TokuDB benchmark on PCIe. October 21, 2015. MaterialWP by Brad Williams.