[gbasedbt@devsvr ~]$ onstat -g bth
Your evaluation license will expire on 2022-06-18 00:00:00
On-Line -- Up 2 days 22:20:59 -- 597864 Kbytes
This command attempts to identify any blocking threads.
No blocking thread identified.
Threads waiting on resources
tid name blocking resource blocker
51 readahead_0 Condition (ReadAhead) -
166 bf_priosweep() Condition (bp_cond) -
191 sqlexec Condition (netnorm) -
[gbasedbt@devsvr ~]$
列
描述
tid
线程 ID
name
线程名称
blocking resource
列出的等待线程的资源类型
blocker
列出的阻塞线程的线程 ID
打印缓冲池的概要文件信息
onstat -g buf
[gbasedbt@devsvr ~]$ onstat -g buf
Your evaluation license will expire on 2022-06-18 00:00:00
On-Line -- Up 2 days 22:55:32 -- 597864 Kbytes
Profile
Buffer pool page size: 2048
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
336 859 5072 93.38 1485 3837 298 0.00
bufwrits_sinceckpt bufwaits ovbuff flushes
0 0 0 284
Fg Writes LRU Writes Avg. LRU Time Chunk Writes Total Mem
0 0 -nan 288 76Mb
Bufferpool Segments
id segment size # buffs
0 0x4af75000 76Mb 35001
----------------------------------
Buffer pool page size: 16384
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
118 984 1738 93.21 107 856 222 51.80
bufwrits_sinceckpt bufwaits ovbuff flushes
0 2 0 6
Fg Writes LRU Writes Avg. LRU Time Chunk Writes Total Mem
0 0 -nan 91 395Mb
Bufferpool Segments
id segment size # buffs
0 0x4fbe9000 395Mb 25000
----------------------------------
Fast Cache Stats
gets hits %hits puts
498 367 73.69 1955
[gbasedbt@devsvr ~]$
字段
说明
Buffer pool page size
缓冲池中页面的字节数
dskreads
将页面带入缓冲池的已执行你的磁盘读操作数。每次读操作读取一个或多个页面。
pagreads
从磁盘读入缓冲池的页面数
bufreads
从该缓冲池读取的页面内存映象次数
%cached
为满足高速缓存页面映象的该缓冲池读取的页面百分比(而不是执行磁盘读取)。计算为 (bufreads - dskreads) / bufreads x 100。更高的百分比说明有更好的高速缓存性能。
dskwrits
将更改的页面从缓冲池写回磁盘所执行的磁盘写入操作数。每次写入操作撰写一个或多个页面。
pagwrits
从缓冲池写入磁盘的页面数
bufwrits
写入该缓冲池的页面内存映象次数
%cached
为满足高速缓存页面映象的该缓冲池写入的页面百分比(而不是执行磁盘写入)。计算为 (bufwrits - dskwrits) / bufwrits x 100 。