VMCD.ORG

Focus on Oracle mail:ylouis83#gmail.com

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 »