很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。
源帖子内容见：https://community.oracle.com/thread/1087650?start=0&tstart=0
这个[……]
September 2, 2014 Internals, MYSQL, oracle No comments internal
很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。
源帖子内容见：https://community.oracle.com/thread/1087650?start=0&tstart=0
这个[……]
August 21, 2014 MYSQL, performance No comments architecture, mongodb, mysqlawr, nosql
Reference Oracle AWR. These two was developed by python and perl.
Both of these are following data collection method.
Use these tools can help[……]
August 12, 2014 Architecture, MYSQL No comments architecture, mysql
July 28, 2014 MYSQL, performance 2 comments mysql
看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法
在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如：
SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]
July 17, 2014 migration, oracle, system, unix No comments architecture
You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码[……]
June 18, 2014 Architecture, MYSQL No comments architecture
June 9, 2014 Architecture, MYSQL, replication No comments HA
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]
May 13, 2014 Architecture, MYSQL, replication No comments architecture
news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]
May 12, 2014 Architecture, MYSQL, replication No comments
Multi-master-rep
two masters: -- 192.168.126.128 mysql 5.6.12 -- 192.168.126.129 mysql 5.6.12
slave : -- 192.168.126.130 MariaDB 10.0
[……]
April 3, 2014 Architect, Exadata, hardware, oracle No comments architecture
Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践[……]