reordered what should be added...
The following based on XtraDB-5.5.8. Are they enough?
"Innodb_" is omitted.
BACKGROUND THREAD############ ulint master_thread_1_second_loops srv_main_1_second_loops master_thread_sleeps srv_main_sleeps master_thread_10_second_loops srv_main_10_second_loops master_thread_background_loops srv_main_background_loops master_thread_main_flush_loops srv_main_flush_loops background_log_sync srv_log_writes_and_flush
SEMAPHORES################### ib_int64_t mutex_spin_waits mutex_spin_wait_count mutex_spin_rounds mutex_spin_round_count mutex_os_waits mutex_os_wait_count s_lock_spin_waits rw_s_spin_wait_count s_lock_spin_rounds rw_s_spin_round_count s_lock_os_waits rw_s_os_wait_count x_lock_spin_waits rw_x_spin_wait_count x_lock_spin_rounds rw_x_spin_round_count x_lock_os_waits rw_x_os_wait_count
INSERT BUFFER AND ADAPTIVE HASH INDEX########## ulint ibuf_size ibuf->size ibuf_free_list ibuf->free_list_len ibuf_segment_size ibuf->seg_size ibuf_merges ibuf->n_merges ibuf_merged_inserts ibuf->n_merged_ops[IBUF_OP_INSERT] ibuf_merged_delete_marks ibuf->n_merged_ops[IBUF_OP_DELETE_MARK] ibuf_merged_deletes ibuf->n_merged_ops[IBUF_OP_DELETE] ibuf_discarded_inserts ibuf->n_discarded_ops[IBUF_OP_INSERT] ibuf_discarded_delete_marks ibuf->n_discarded_ops[IBUF_OP_DELETE_MARK] ibuf_discarded_deletes ibuf->n_discarded_ops[IBUF_OP_DELETE]
[summed (i = 0; i < btr_search_index_num; i++)] hash_table_t* table = btr_search_get_hash_index((index_id_t)i); adaptive_hash_cells += hash_get_n_cells(table) adaptive_hash_heap_buffers += (UT_LIST_GET_LEN(table->heap->base) - 1)
adaptive_hash_hash_searches btr_cur_n_sea adaptive_hash_non_hash_searches btr_cur_n_non_sea
LOG############################ ib_uint64_t lsn_current log_sys->lsn lsn_flushed log_sys->flushed_to_disk_lsn lsn_last_checkpoint log_sys->last_checkpoint_lsn
ulint checkpoint_max_age log_sys->max_checkpoint_age checkpoint_target_age log_max_checkpoint_age_async()
###checkpoint_modified_age "dangerous without mutex": impossible not to affect performance much
checkpoint_age (log_sys->lsn - log_sys->last_checkpoint_lsn)
BUFFER POOL AND MEMORY############### innodb_mem_total ut_total_allocated_memory innodb_mem_adaptive_hash if (btr_search_sys && btr_search_sys->hash_index[0]->heap) { btr_search_sys_subtotal = mem_heap_get_size(btr_search_sys->hash_index[0]->heap); } else { btr_search_sys_subtotal = 0; for (i=0; i < btr_search_sys->hash_index[0]->n_mutexes; i++) { btr_search_sys_subtotal += mem_heap_get_size(btr_search_sys->hash_index[0]->heaps[i]); } } btr_search_sys_subtotal *= btr_search_index_num; += (btr_search_sys ? (btr_search_sys->hash_index[0]->n_cells * btr_search_index_num * sizeof(hash_cell_t)) : 0)
innodb_mem_dictionary (dict_sys ? ((dict_sys->table_hash->n_cells + dict_sys->table_id_hash->n_cells ) * sizeof(hash_cell_t) + dict_sys->size) : 0)
for (i = 0; i < srv_buf_pool_instances; i++) { buf_pool_t* buf_pool = buf_pool_from_array(i); buffer_pool_pages_old += buf_pool->LRU_old_len
buffer_pool_pages_made_young stat.n_pages_made_young buffer_pool_pages_made_not_young stat.n_pages_not_made_young buffer_pool_pages_read_ahead !!! already exist "buffer_pool_read_ahead" buffer_pool_pages_evicted_without_access !!! already exist "buffer_pool_read_ahead_evicted"
TRANSACTIONS########################### ib_uint64_t max_trx_id trx_sys->max_trx_id purge_trx_id purge_sys->purge_trx_no purge_undo_no purge_sys->purge_undo_no
ulint history_list_length trx_sys->rseg_history_len
ETC######################## lock_numbers lock_sys->rec_num ####should be added to count#### oldest_view_low_limit_trx_id read_view_t* view = UT_LIST_GET_LAST(trx_sys->view_list); view ? view->low_limit_id : 0
reordered what should be added...
The following based on XtraDB-5.5.8.
Are they enough?
"Innodb_" is omitted.
BACKGROUND THREAD############ thread_ 1_second_ loops srv_main_ 1_second_ loops thread_ sleeps srv_main_sleeps thread_ 10_second_ loops srv_main_ 10_second_ loops thread_ background_ loops srv_main_ background_ loops thread_ main_flush_ loops srv_main_ flush_loops writes_ and_flush
ulint
master_
master_
master_
master_
master_
background_log_sync srv_log_
SEMAPHORES# ####### ####### #### wait_count round_count wait_count round_count wait_count round_count
ib_int64_t
mutex_spin_waits mutex_spin_
mutex_spin_rounds mutex_spin_
mutex_os_waits mutex_os_wait_count
s_lock_spin_waits rw_s_spin_
s_lock_spin_rounds rw_s_spin_
s_lock_os_waits rw_s_os_wait_count
x_lock_spin_waits rw_x_spin_
x_lock_spin_rounds rw_x_spin_
x_lock_os_waits rw_x_os_wait_count
INSERT BUFFER AND ADAPTIVE HASH INDEX########## merged_ ops[IBUF_ OP_INSERT] delete_ marks ibuf->n_ merged_ ops[IBUF_ OP_DELETE_ MARK] merged_ ops[IBUF_ OP_DELETE] inserts ibuf->n_ discarded_ ops[IBUF_ OP_INSERT] delete_ marks ibuf->n_ discarded_ ops[IBUF_ OP_DELETE_ MARK] deletes ibuf->n_ discarded_ ops[IBUF_ OP_DELETE]
ulint
ibuf_size ibuf->size
ibuf_free_list ibuf->free_list_len
ibuf_segment_size ibuf->seg_size
ibuf_merges ibuf->n_merges
ibuf_merged_inserts ibuf->n_
ibuf_merged_
ibuf_merged_deletes ibuf->n_
ibuf_discarded_
ibuf_discarded_
ibuf_discarded_
[summed (i = 0; i < btr_search_ index_num; i++)]
hash_table_ t* table = btr_search_ get_hash_ index(( index_id_ t)i); n_cells( table) hash_heap_ buffers += (UT_LIST_ GET_LEN( table-> heap->base) - 1)
adaptive_hash_cells += hash_get_
adaptive_
adaptive_ hash_hash_ searches btr_cur_n_sea hash_non_ hash_searches btr_cur_n_non_sea
adaptive_
LOG#### ####### ####### ####### ### >flushed_ to_disk_ lsn >last_checkpoin t_lsn
ib_uint64_t
lsn_current log_sys->lsn
lsn_flushed log_sys-
lsn_last_checkpoint log_sys-
ulint >max_checkpoint _age target_ age log_max_ checkpoint_ age_async( )
checkpoint_max_age log_sys-
checkpoint_
###checkpoint_ modified_ age "dangerous without mutex": impossible not to affect performance much
checkpoint_age (log_sys->lsn - log_sys- >last_checkpoin t_lsn)
BUFFER POOL AND MEMORY# ####### ####### allocated_ memory mem_adaptive_ hash sys->hash_ index[0] ->heap) {
btr_search_ sys_subtotal = mem_heap_ get_size( btr_search_ sys->hash_ index[0] ->heap) ;
btr_search_ sys_subtotal = 0; sys->hash_ index[0] ->n_mutexes; i++) {
btr_ search_ sys_subtotal += mem_heap_ get_size( btr_search_ sys->hash_ index[0] ->heaps[ i]);
btr_search_ sys_subtotal *= btr_search_ index_num; sys->hash_ index[0] ->n_cells * btr_search_ index_num * sizeof( hash_cell_ t)) : 0)
innodb_mem_total ut_total_
innodb_
if (btr_search_sys && btr_search_
} else {
for (i=0; i < btr_search_
}
}
+= (btr_search_sys
? (btr_search_
innodb_ mem_dictionary sys->table_ hash->n_ cells
+ dict_sys- >table_ id_hash- >n_cells
) * sizeof(hash_cell_t)
(dict_sys ? ((dict_
+ dict_sys->size) : 0)
for (i = 0; i < srv_buf_ pool_instances; i++) { from_array( i); pool_pages_ old += buf_pool- >LRU_old_ len
buf_pool_t* buf_pool = buf_pool_
buffer_
buffer_ pool_pages_ made_young stat.n_ pages_made_ young pool_pages_ made_not_ young stat.n_ pages_not_ made_young pool_pages_ read_ahead !!! already exist "buffer_ pool_read_ ahead" pool_pages_ evicted_ without_ access !!! already exist "buffer_ pool_read_ ahead_evicted"
buffer_
buffer_
buffer_
TRANSACTIONS# ####### ####### ####### ##### >purge_ trx_no >purge_ undo_no
ib_uint64_t
max_trx_id trx_sys->max_trx_id
purge_trx_id purge_sys-
purge_undo_no purge_sys-
ulint >rseg_history_ len
history_list_length trx_sys-
ETC#### ####### ####### ###### view_low_ limit_trx_ id read_view_t* view = UT_LIST_ GET_LAST( trx_sys- >view_list) ;
view
? view->low_limit_id
: 0
lock_numbers lock_sys->rec_num ####should be added to count####
oldest_