设为首页 加入收藏

TOP

Innodb三大特性之insert buffer(二)
2015-11-21 01:32:41 来源: 作者: 【 】 浏览:1
Tags:Innodb 三大 特性 insert buffer
ts, 41 merged recs, 499 merges Hash table size 3984403, node heap has 967 buffer(s) 14.66 hash searches/s, 64.65 non-hash searches/s --- LOG --- Log sequence number 27233311008 Log flushed up to 27233311008 Last checkpoint at 27233310593 0 pending log writes, 0 pending chkp writes 37848626 log i/o's done, 1.00 log i/o's/second
size: The number of pages used within the change buffer. Change buffer size is equal to seg size - (1 + free list len). The 1 + value represents the change buffer header page.
?
free list len: The number of pages free within the change buffer.代表了空闲页的数量
?
seg size: The size of the change buffer, in pages. 插入缓冲的大小为2 *16KB
?
merges: The total number of change buffer merges.表示合并次数
?
merged operations - insert: The number of inserted records merged.merged插入的记录数
?
merged operations - delete mark: The number of deleted records merged.merged删除记录数
?
merged operations - delete: The number of purge records merged.merged清除记录数
?
discarded operations - insert: The number of insert merge operations discarded.
?
discarded operations - delete mark: The number of delete merge operations discarded.
?
discarded operations - delete: The number of purge merge operations discarded.
首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇mysql修改默认的环境的字符集为ut.. 下一篇Innodb三大特性之adaptive hash i..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: