Total memory allocated
The total memory allocated for the buffer pool in bytes.
Dictionary memory allocated
The total memory allocated for the InnoDB data dictionary in bytes.
Buffer pool size
The total size in pages allocated to the buffer pool.
Free buffers
The total size in pages of the buffer pool free list.
Database pages
The total size in pages of the buffer pool LRU list.
Old database pages
The total size in pages of the buffer pool old LRU sublist.
Modified db pages
The current number of pages modified in the buffer pool.
Pending reads
The number of buffer pool pages waiting to be read in to the buffer pool.
Pending writes LRU
The number of old dirty pages within the buffer pool to be written from the bottom of the LRU list.
Pending writes flush list
The number of buffer pool pages to be flushed during checkpointing.
Pending writes single page
The number of pending independent page writes within the buffer pool.
Pages made young
The total number of pages made young in the buffer pool LRU list (moved to the head of sublist of "new" pages).
Pages made not young
The total number of pages not made young in the buffer pool LRU list (pages that have remained in the "old" sublist without being made young).
youngs/s
The per second average of accesses to old pages in the buffer pool LRU list that have resulted in making pages young.
non-youngs/s
The per second average of accesses to old pages in the buffer pool LRU list that have resulted in not making pages young.
Pages read
The total number of pages read from the buffer pool.
Pages created
The total number of pages created within the buffer pool.
Pages written
The total number of pages written from the buffer pool.
reads/s
The per second average number of buffer pool page reads per second.
creates/s
The per second average number of buffer pool pages created per second.
writes/s
The per second average number of buffer pool page writes per second.
Buffer pool hit rate
The buffer pool page hit rate for pages read from the buffer pool memory vs from disk storage.
young-making rate
The average hit rate at which page accesses have resulted in making pages young.
not (young-making rate)
The average hit rate at which page accesses have not resulted in making pages young.
Pages read ahead
The per second average of read ahead operations.
Pages evicted without access
The per second average of the pages evicted without being accessed from the buffer pool.
Random read ahead
The per second average of random read ahead operations.
LRU len
The total size in pages of the buffer pool LRU list.
unzip_LRU len
The total size in pages of the buffer pool unzip_LRU list.
I/O sum
The total number of buffer pool LRU list pages accessed, for the last 50 seconds.
I/O cur
The total number of buffer pool LRU list pages accessed.
I/O unzip sum
The total number of buffer pool unzip_LRU list pages accessed.
I/O unzip cur
The total number of buffer pool unzip_LRU list pages accessed.
4. 脚本说明
1). 准备条件
模块 - MySQLDB
Python版本 >= 2.6.x (3.x版本不支持)
2). 使用方法
Usage:
./mysql_innodb_status.py
-h : database ip address/domain name
-u : username
-p : password
-k : print specified items(section.key1,section.key2) or section.*
腾讯云数据库 MySQL(TencentDB for MySQL)为用户提供安全可靠,性能卓越、易于维护的企业级云数据库服务。其具备6大企业级特性,包括企业级定制内核、企业级高可用、企业级高可靠、企业级安全、企业级扩展以及企业级智能运维。通过使用腾讯云数据库 MySQL,可实现分钟级别的数据库部署、弹性扩展以及全自动化的运维管理,不仅经济实惠,而且稳定可靠,易于运维。