Log pages read = 0 Log read time (sec.ns) = 0.000000000 Log pages written = 0 Log write time (sec.ns) = 0.000000000 Number write log IOs = 0 Number read log IOs = 0 Number partial page log IOs = 0 Number log buffer full = 0 Log data found in buffer = 0 Log to be redone for recovery (Bytes) = 0
get snapshot for tablespaces 能看到表空间的读写
Buffer pool data logical reads = 1064 Buffer pool data physical reads = 162 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Asynchronous pool data page reads = 15 Buffer pool data writes = 0 Asynchronous pool data page writes = 0 Buffer pool index logical reads = 778 Buffer pool index physical reads = 323 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Asynchronous pool index page reads = 0 Buffer pool index writes = 0 Asynchronous pool index page writes = 0 Buffer pool xda logical reads = 0 Buffer pool xda physical reads = 0 Buffer pool temporary xda logical reads = 0 Buffer pool temporary xda physical reads = 0 Asynchronous pool xda page reads = 0 Buffer pool xda writes = 0 Asynchronous pool xda page writes = 0 Total buffer pool read time (millisec) = 686 Total buffer pool write time (millisec) = 0 Total elapsed asynchronous read time = 15 Total elapsed asynchronous write time = 0 Asynchronous data read requests = 6 Asynchronous index read requests = 0 Asynchronous xda read requests = 0 No victim buffers available = 0 Direct reads = 484 Direct writes = 0 Direct read requests = 38 Direct write requests = 0 Direct reads elapsed time (ms) = 55 Direct write elapsed time (ms) = 0 Number of files closed = 0