2014年2月28日

Mysql History list length 值太大引起的问题

摘要： 1.环境Mysql主从Mysql版本：5.1.49-log系统：RedHatEnterpriseLinuxServerrelease5.464bit2.表面现象数据库操作变慢，如用主键作为条件查询，有时也会超过1秒；主库IO使用率一直在90%以上（平常io比较低20%以内），dirty页占总数的90%左右，脏页刷不完；持续了几个小时~3.从系统上看主库的iostat的使用率一直在90%以上，Mysqldata所在目录的大小一直没变；主库的ib_logfile20分钟切换一次（主库上面的innodblog写得还是比较频繁），而从库的ib_logfile4小时切换一次。4.从mysql上看在主库B 阅读全文

posted @ 2014-02-28 01:07 Still water run deep 阅读(2203) 评论(0) 推荐(0)

Why is the ibdata1 file continuously growing in MySQL?

摘要： We receive this question about the ibdata1 file in MySQL very often inPercona Support.The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled.After some research you realize that most of the disk space is used by 阅读全文

posted @ 2014-02-28 00:42 Still water run deep 阅读(427) 评论(0) 推荐(0)

导航