informix监控篇.docVIP

informix监控篇 可以使用onstat -g选项监控虚拟处理器的使用：athgloioqreaonstat -g ath：显示了有关线程和虚拟处理器类的信息。onstat -g glo：显示了当前正在运行的每个虚拟处理器的信息以及有关每个处理器类的累计的统计信息。类似的输出：MT global info:sessions threads vps lngspins1 15 8 0Virtual processor summary:class vps usercpu syscpu totalcpu 3 479.77 190.42 670.18aio 1 0.83 0.23 1.07pio 1 0.42 0.10 0.52lio 1 0.27 0.22 0.48soc 0 0.00 0.00 0.00tli 0 0.00 0.00 0.00shm 0 0.00 0.00 0.00adm 1 0.10 0.45 0.55opt 0 0.00 0.00 0.00msc 1 0.28 0.52 0.80adt 0 0.00 0.00 0.00total 8 481.67 191.93 673.60Individual virtual processors:vp pid class usercpu syscpu total1 1776 cpu 165.18 40.50 205.682 1777 adm 0.10 0.45 0.553 1778 cpu 157.83 98.68 256.524 1779 cpu 156.75 51.23 207.985 1780 lio 0.27 0.22 0.486 1781 pio 0.42 0.10 0.527 1782 aio 0.83 0.23 1.078 1783 msc 0.28 0.52 0.80tot 481.67 191.93 673.60其中，sessions表示当前总的活动session数，threads表示当前总的活动的线程数，vps表示当前总的活动的vp数。onstat -g ioq：这也是一个比较重要的命令。显示了列len下的I/O队列的长度。onstat -g ioqAIO I/O queues:q name/id len maxlen totalops dskread dskwrite dskcopyadt 0 0 0 0 0 0 0msc 0 0 1 12 0 0 0aio 0 0 4 89 68 0 0pio 0 0 1 1 0 1 0lio 0 0 1 17 0 17 0kio 0 0 0 0 0 0 0gfd 3 0 3 254 242 12 0gfd 4 0 17 614 261 353 0对于queue name，一般有以下几类：sqli_dbg? ? Handles I/O for IBM Technical Supports SQL Interface Debugging feature fifo? ? Handles I/O for FIFO VPs adt? ? Handles auditing I/O msc? ? Handles miscellaneous I/O aio? ? Handles IBM Informix asynchronous I/O kio? ? Handles kernel AIO pio? ? Handles physical logging I/O lio? ? Handles logical logging I/O gfd? ? Global File Descriptor - Each primary and mirror chunk is given a separate global file descriptor. Individual gfd queues are used depending on whether kaio is on and the associated chunk is cooked or raw. len? ? The number of pending I/O requests in the queue maxlen? ? The largest number of I/O requests that have been in the queue at the same time totalops? ? The total number of I/O operations that have been completed f