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.
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.
vmcd.org
mysql test | VMCD.ORG
http://www.vmcd.org/2013/06/recent-mysql-performance-test-detial/comment-page-1
Recent MySQL performance Test detial. June 14, 2013. December 22, 2014. 2 thoughts on “ Recent MySQL performance Test detial. December 5, 2013 at 5:09 pm. December 14, 2013 at 8:10 pm. 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. December 28, 2015.
vmcd.org
bug | VMCD.ORG
http://www.vmcd.org/tag/bug
September 25, 2013. December 22, 2014. 某国内巨头的一起CASE,在系统繁忙情况下大量的CTAS 导致数据字典表的不一致,由原来10.0.2.4版本升级到10.0.2.5之后问题依旧。 15:00:18 SQL @dropts 2012.0319.150[.]. 11202 EXPDP 遭遇 ORA-4031. July 16, 2012. December 22, 2014. 一套oracle 11.2.0.2 数据仓库系统使用expdp导出数据时 进程hang 死 使用kill -9命令杀掉之后 database一直没有释放latch 通过下面的日志可以发现 pmon已经发现 ospid=15038的process dead 但是无法clean 进程在为 “fixed[……]. ORA-16009 in alert log with standby and LGWR ASYNC. December 2, 2011. December 22, 2014. 今天用102.0.1的一套物理DG 转 逻辑 standby 出现大量错误. June 29, 2016.
leafonsword.org
刀尖红叶的博客 - Page 2
http://www.leafonsword.org/page/2
User Statistic是个能统计MySQL中线程、用户、表、索引等信息的插件,在Percona和MariaDB直接集成了,但官方文档没有多少实用例子,以下是我日常用的一些例子(测试跑在MariaDB 10.0上): 1.找出没被访问过的表 use INFORMATION SCHEMA; select table schema,table name from STATISTICS where (table schema,table name) not in (select table schema,table name from TABLE STATISTICS ) and table schema not in ('information schema','performance schema','mysql'); 生成drop语句: use…. 自从2008年接触Linux,Linux一直是我的主力桌面操作系统- 从Ubuntu到Fedora到Arch到Gentoo再到Deepin，现在又回到起点用上了Ubuntu Kylin;但感觉我的超极本跑着还是有些卡,优化了下,记录之: 删除无用的启动项...
