| column | description
|
| profile_dskreads | total disk read operations |
| profile_pagreads | number of pages read from disk |
| profile_bufreads | number of buffers read |
| profile_cacheread | percentage of reads from cache |
| profile_dskwrites | total disk write operations |
| profile_bufwrites | total number of biuffers written |
| profile_cachewrite | percentages of writes to cache |
| | |
| profile_ isamtot | total number of isam calls |
| profile_open | isam open calls |
| profile_start | isam start calls |
| profile_read | isam read calls |
| profile_write | isam write calls |
| profile_rewrite | isam re-write calls |
| profile_delete | isam delete calls |
| profile_commit | isam commit calls |
| profile_rollbk | isam rollback calls |
| | |
| profile_gp_read | generic page reads |
| profile_gp_write | generic page writes |
| profile gp_rewrt | generic page updates |
| profile_gp_del | generic page deletes |
| profile_gp_alloc | generic page allocations |
| profile_gp_free | generic pages freed |
| profile_gp_curs | cursors on generic pages |
| | |
| profile_ovlock | number of times unable to allocate locks |
| profile_ovuserthread | attempts to exceed maximum user threads |
| profile_ovbuff | failed to find a free buffer |
| proflie_usercpu | total user cpu time for the engine, seconds |
| profile_syscpu | total sys cpu time for the engine, seconds |
| profile_numckpts | the number of checkpoints performed |
| profile_flushes | the number of buffer pool flushes |
| | |
| profile_bufwaits | number of times a session waited for a buffer |
| profile_lokwaits | number of times a session waited for a lock |
| profile_lockreqs | number of locks requested |
| profile_deadlks | number of times a dead lock occurred |
| profile_dltouts | number of times dead locks timed out |
| profile_ckpwaits | number of times a session waited for a checkpoint to complete |
| profile_compress | number of times a data page was compressed |
| profile_seqscans | number of times tables were sequentially scanned |
| | |
| profile_ ixda_ra | read ahead from index leaves to data pages |
| profile_idx_ra | read ahead index leaves |
| profile_da_ra | read ahead data only |
| profile_ra_pgsused | read ahead pages that were used |
| profile_lchwaits | number of times a thread waited for a shared memory latch |
| | |
| profile_rautil | percentage of pages used vs pages read |
| profile_rautil_pages | total number of read ahead pages used |
| | |
| | |