VMCD.ORG

Focus on database mail:ylouis83#gmail.com

MySQL 5.5&5.6 new features summary

Posted by admin on February 10th, 2014

upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF

Tags:
Posted in MYSQL | No Comments »

MySQL-Oslayer-Performance-Optimization

Posted by admin on January 13th, 2014

upload on 2014.1 [ten important tips of MySQL database design for better performance] Download this PDF

Tags:
Posted in MYSQL | No Comments »

MySQL replication case 一则

Posted by admin on September 10th, 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 July 9th, 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 June 14th, 2013

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

Tags:
Posted in MYSQL | 2 Comments »

MyAWR another mysql awr –That is Great !!

Posted by admin on May 22nd, 2013

MyAWR 开源了,第一版的reference 已经放出, tx to noodba

MyAWR_Reference_Guid
slideshare地址:MyAWR (awr of MySQL)
MyAWR template:MySQL WorkLoad Report

Tags:
Posted in MYSQL | No Comments »

MySQL AWR – Myawr

Posted by admin on May 6th, 2013

noodba同学写的基于mysql的 WORKLOAD REPOSITORY工具,目前还没有开源 非常的给力!!

主要思想为一台管理机器,集中了所有client端的数据,client 为mysql database 使用host_id来区分 如 host_id=1代表mysql databas[......]

Read more

Tags:
Posted in MYSQL | No Comments »

基于MHA 的MySQL高可用方案

Posted by admin on March 25th, 2013

aaqwsh与select同学测试的MHA文档,另外基于这个HA方案公司应该会部署一些核心应用。另外提供之前的MHA测试

Tags:
Posted in MYSQL | No Comments »

gdb 调试TPCC 一例

Posted by admin on March 19th, 2013

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[......]

Read more

Tags:
Posted in MYSQL | No Comments »

mysql sync-binlog 导致 poor IO performance

Posted by admin on January 29th, 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 »