Skip to content
  • Search
  • Login
Login Register

Simple Life

Ooooo

menu

Skip to content
menu
  • About Me

July 20, 2014

MySQL 5.6

DML对innodb page空间的影响

前言 我们知道Innodb使用BTREE来进行数据组织存储,当发生INSERT/UPDATE/DELETE时,有可能会产生数据空洞,不能有效的利用page的空间。而这些空洞在未来甚至有可能不再被使用到。本文主要记录了相关的代码,现有的处理方式,最后介绍了facebook mysql对page碎片的处理方式.   DML对page空间影响 以下简述下三种操作类型对页面空间的影响 原创文章,转载请注明: 转载自Simple Life 本文链接地址: DML对innodb page空间的影响 Post Footer automatically generated by wp-posturl plugin for wordpress.

管理

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Search

近期文章

  • 博客全面迁移到云栖社区
  • procedure analyse() 随手记
  • InnoDB 存储引擎系列文章
  • MySQL5.6.27 Release Note解读(innodb及复制模块)
  • MySQL 5.6.26 Release Note解读
  • [MySQL bug] unique key corruption again…..
  • InnoDB foreign key 实现
  • InnoDB IO子系统介绍

日历

July 2014
M T W T F S S
« Jun   Aug »
 123456
78910111213
14151617181920
21222324252627
28293031  

文章归档

  • May 2016 (1)
  • November 2015 (3)
  • August 2015 (1)
  • June 2015 (1)
  • May 2015 (2)
  • April 2015 (2)
  • March 2015 (14)
  • February 2015 (2)
  • January 2015 (3)
  • December 2014 (5)
  • November 2014 (11)
  • October 2014 (5)
  • September 2014 (4)
  • August 2014 (1)
  • July 2014 (2)
  • June 2014 (1)
  • May 2014 (3)
  • March 2014 (5)
  • February 2014 (1)
  • January 2014 (4)
  • December 2013 (3)
  • October 2013 (2)
  • September 2013 (2)
  • August 2013 (2)
  • July 2013 (1)
  • June 2013 (8)
  • May 2013 (6)
  • April 2013 (5)
  • March 2013 (9)
  • February 2013 (1)
  • January 2013 (6)
  • December 2012 (5)
  • November 2012 (7)
  • October 2012 (14)
  • September 2012 (6)
  • August 2012 (9)
  • July 2012 (11)

Views

  • MySQL 5.6.12的Innodb性能改进 - 573,247 views
  • [MySQL 5.6] MySQL 5.6 online ddl 使用、测试及关键函数栈 - 219,173 views
  • [MySQL 调试] 初试breakpad - 207,327 views
  • 一个线上死锁问题分析 - 203,759 views
  • [MySQL 5.6] innodb_flush_method新值O_DIRECT_NO_FSYNC 及bug#68555 - 175,920 views
  • [MySQL 5.6] MySQL 5.6 group commit 性能测试及内部实现流程 - 174,776 views
  • [MySQL Bug]Bug#13986705 CRASH IN GET_INTERVAL_VALUE() WITH DATE CALCULATION WITH UTF32 INTERVALS - 133,111 views
  • [MySQL学习] MySQL压缩表 - 40,031 views
  • [MySQL学习] Innodb锁系统(4) Insert/Delete 锁处理及死锁示例分析 - 23,246 views
  • About Me - 15,013 views