InnoDB体系架构简介
来源:互联网 发布:韩国打榜用什么软件 编辑:程序博客网 时间:2024/06/14 20:12
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
mysql> show engine innodb status\G;
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
140506 22:57:52 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 48 seconds
……
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
……
----------------------------
END OF INNODB MONITOR OUTPUT
============================
3、Purge Thread:事务被提交后,其所使用的undo log可能不再需要,因此需要Purge Thread来回收已经使用并分配的undo页。
1
2
3
4
5
6
7
mysql> show variables like 'innodb_purge_threads';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| innodb_purge_threads | 1 |
+----------------------+-------+
1 row in set (0.00 sec)
缓冲池简单来说就是一块内存区域。
1
2
3
4
5
6
7
mysql> show variables like 'innodb_buffer_pool_size';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| innodb_buffer_pool_size | 134217728 |
+-------------------------+-----------+
1 row in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
mysql> show engine innodb status\G;
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
140506 23:37:52 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 10 seconds
……
Buffer pool size 8191 //缓冲池总大小,8191*16K
Free buffers 7785 //Free列表中的页的数量
Database pages 405 //LRU列表中页的数量
Old database pages 0
Modified db pages 0 //脏页数量
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 405, created 0, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
……
----------------------------
END OF INNODB MONITOR OUTPUT
============================
0 0
- InnoDB体系架构简介
- InnoDB体系架构简介
- InnoDB体系架构
- InnoDB体系架构
- innoDB 体系架构 ----后台线程
- InnoDB 存储引擎体系架构
- InnoDB 存储引擎体系架构
- teradata体系架构简介
- MySQL InnoDB体系架构之内存
- 第二章 InnoDB体系架构(一)
- MySQL InnoDB体系架构之内存
- Mysql innodb存储引擎体系架构
- 读书笔记第二章第二节2.2 InnoDB体系架构
- 对于innodb体系架构之后台线程、内存
- 软件体系架构:RM-ODP参考模型简介
- 软件体系架构:RM-ODP参考模型简介
- Android开发之Android体系架构简介(一)
- Android开发之Android体系架构简介(二)
- 项目开发规范,数据库设计规范
- html字符转义
- 日期的操作类
- java线程的生命周期
- 如果你喜欢上了一个程序员小伙,献给所有的程序员女友
- InnoDB体系架构简介
- 关于VC中 error C2871: 'std' : does not exist or is not a namespace
- 集合栈计算机
- SUSE HA的安装
- 计数排序
- Unity中各种常用文件夹的用处
- 源码解读Spring IOC原理
- 字符串匹配——KMP算法
- ZOJ 3228 Searching the String (AC自动机)