06 2012 档案

主键乱序插入对Innodb性能的影响
摘要：在平时的mysql文档学习中我们经常会看到这么一句话：MySQL tries to leave space so that future inserts do not incur un-necessary page splits (and thus higher IO cost). In an "ideal" world, MySQL tries to keep the index pages at 15/16-th full, but depending on insert order, this fill factor can be as low as 1/2大致含义就 阅读全文
posted @ 2012-06-29 15:09 cenalulu 阅读(3165) 评论(0) 推荐(3) 编辑
MySQL中 timeout相关参数解析
摘要：本博客已经迁移至：http://cenalulu.github.io/本篇博文已经迁移，阅读全文请点击：http://cenalulu.github.io/mysql/mysql-timeout/前言：MySQL中有两个关于连接超时的配置项。他们之间在某些条件下会互相继承，那究竟这两个参数会在什么情... 阅读全文
posted @ 2012-06-20 09:47 cenalulu 阅读(11947) 评论(0) 推荐(3) 编辑

点击右上角即可分享
微信分享提示