VMCD.ORG

Focus on database mail:ylouis83#gmail.com

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 »