VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Webm: MySQL database performance web monitor

Posted by admin on 28th September 2014

You can download webm from github: https://github.com/ylouis83/webm

webm: mysql web key performance monitor

webm is a tool that display key val[……]

Read more

Tags: , ,
Posted in Architect, MYSQL | No Comments »

Talk about some MySQL HA architecture

Posted by admin on 12th August 2014

Some tips for MySQL architecture

Tags: ,
Posted in MYSQL | No Comments »

Advanced Pagination for MySQL

Posted by admin on 28th July 2014

看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法

在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如:

SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]

Read more

Tags:
Posted in MYSQL | No Comments »

MySQL replication case 一则

Posted by admin on 10th September 2013

最近同事处理了一则mysql复制错误.发出来参考下

MYSQL同步出错,报错信息如下:

Last_Errno: 1267
Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and[......]

Read more

Tags:
Posted in MYSQL | No Comments »

MySQL InnoDB的一些非常规恢复

Posted by admin on 9th July 2013

最近关于下厨房的数据恢复,讨论的很火热,乘机测试了把Percona Data Recovery Tool for InnoDB工具,并且事实证明这款工具对一些操作的恢复,还是比较困难的。

我们以一张小表为例做一个测试:

mysql> select * from  customer;[......]

Read more

Tags:
Posted in MYSQL | 2 Comments »

Recent MySQL performance Test detial

Posted by admin on 14th June 2013

最近team基于mysql的性能基准测试,包含多种场景

Tags:
Posted in MYSQL | 2 Comments »

mysql sync-binlog 导致 poor IO performance

Posted by admin on 29th January 2013

mysql 数据库 poor IO performance.从DELL 815(6disk raid 5,oel5.5) 迁移至 HP DL380 (14disk raid 1+0,rhl5.8)

当时的IO 表现

avg-cpu:  %user   %nice %system %[......]

Read more

Tags:
Posted in MYSQL | No Comments »

优化mysql ibdata*

Posted by admin on 18th January 2012

由于此前的mysql salve服务器没有进行规划,一些参数都是使用的默认参数,导致innodb datafile 无限制增长,所以需要重新规划一下datafile空间的分配,以及其他参数的优化

version:

mysql>
mysql>
mysql> select version([……]

Read more

Tags:
Posted in MYSQL | No Comments »