2.161 DUMP 14002

Code

14002

Symbol

DbinfoListColumns

Kernel Block

DBINFO

Description.  Writes a list of all columns in all ndbinfo tables to the data node log. Each column is listed in the format table_id, column_id, column_name, column_typecode. Table IDs are those obtained from ALL DUMP 14001. Column type codes are shown in the following table:

Table 2.10 DUMP 14002 Column Types

Code	Type
1	String
2	Integer
3	Decimal

Sample Output. 

--- BEGIN NDB$INFO.COLUMNS ---
0,0,table_id,2
0,1,table_name,1
0,2,comment,1
1,0,table_id,2
1,1,column_id,2
1,2,column_name,1
1,3,column_type,2
1,4,comment,1
2,0,node_id,2
2,1,block_number,2
2,2,block_instance,2
2,3,counter,2
2,4,counter2,3
3,0,node_id,2
3,1,block_number,2
3,2,block_instance,2
3,3,pool_name,1
3,4,used,3
3,5,total,3
3,6,high,3
3,7,entry_size,3
3,8,config_param1,2
3,9,config_param2,2
3,10,config_param3,2
3,11,config_param4,2
3,12,resource_id,2
3,13,type_id,2
4,0,node_id,2
4,1,remote_node_id,2
4,2,connection_status,2
4,3,remote_address,1
4,4,bytes_sent,3
4,5,bytes_received,3
4,6,connect_count,2
4,7,overloaded,2
4,8,overload_count,2
4,9,slowdown,2
4,10,slowdown_count,2
5,0,node_id,2
5,1,log_type,2
5,2,log_id,2
5,3,log_part,2
5,4,total,3
5,5,used,3
5,6,high,3
6,0,node_id,2
6,1,log_type,2
6,2,log_id,2
6,3,log_part,2
6,4,total,3
6,5,used,3
6,6,high,3
7,0,node_id,2
7,1,resource_id,2
7,2,reserved,2
7,3,used,2
7,4,max,2
7,5,high,2
7,6,spare,2
8,0,node_id,2
8,1,block_number,2
8,2,block_instance,2
8,3,counter_id,2
8,4,val,3
9,0,node_id,2
9,1,uptime,3
9,2,status,2
9,3,start_phase,2
9,4,config_generation,2
10,0,node_id,2
10,1,block_instance,2
10,2,pages_written,3
10,3,pages_written_lcp,3
10,4,pages_read,3
10,5,log_waits,3
10,6,page_requests_direct_return,3
10,7,page_requests_wait_queue,3
10,8,page_requests_wait_io,3
11,0,node_id,2
11,1,thr_no,2
11,2,block_number,2
11,3,block_instance,2
12,0,node_id,2
12,1,thr_no,2
12,2,thr_nm,1
12,3,c_loop,3
12,4,c_exec,3
12,5,c_wait,3
12,6,c_l_sent_prioa,3
12,7,c_l_sent_priob,3
12,8,c_r_sent_prioa,3
12,9,c_r_sent_priob,3
12,10,os_tid,3
12,11,os_now,3
12,12,os_ru_utime,3
12,13,os_ru_stime,3
12,14,os_ru_minflt,3
12,15,os_ru_majflt,3
12,16,os_ru_nvcsw,3
12,17,os_ru_nivcsw,3
13,0,node_id,2
13,1,block_instance,2
13,2,objid,2
13,3,apiref,2
13,4,transid0,2
13,5,transid1,2
13,6,state,2
13,7,flags,2
13,8,c_ops,2
13,9,outstanding,2
13,10,timer,2
14,0,node_id,2
14,1,block_instance,2
14,2,objid,2
14,3,tcref,2
14,4,apiref,2
14,5,transid0,2
14,6,transid1,2
14,7,tableid,2
14,8,fragmentid,2
14,9,op,2
14,10,state,2
14,11,flags,2
15,0,node_id,2
15,1,group_id,2
15,2,left_node,2
15,3,right_node,2
15,4,president,2
15,5,successor,2
15,6,dynamic_id,2
15,7,arbitrator,2
15,8,arb_ticket,1
15,9,arb_state,2
15,10,arb_connected,2
15,11,conn_rank1_arbs,1
15,12,conn_rank2_arbs,1
16,0,type,2
16,1,id,2
16,2,version,2
16,3,state,2
16,4,parent_obj_type,2
16,5,parent_obj_id,2
16,6,fq_name,1
17,0,node_id,2
17,1,block_instance,2
17,2,table_id,2
17,3,fragment_num,2
17,4,rows,3
17,5,fixed_elem_alloc_bytes,3
17,6,fixed_elem_free_bytes,3
17,7,fixed_elem_count,3
17,8,fixed_elem_size_bytes,2
17,9,var_elem_alloc_bytes,3
17,10,var_elem_free_bytes,3
17,11,var_elem_count,3
17,12,tuple_l2pmap_alloc_bytes,3
17,13,hash_index_l2pmap_alloc_bytes,3
17,14,hash_index_alloc_bytes,3
18,0,node_id,2
18,1,thr_no,2
18,2,millis_ago,3
18,3,millis_passed,3
18,4,backup_lcp_bytes_written,3
18,5,redo_bytes_written,3
18,6,target_disk_write_speed,3
19,0,node_id,2
19,1,thr_no,2
19,2,backup_lcp_speed_last_sec,3
19,3,redo_speed_last_sec,3
19,4,backup_lcp_speed_last_10sec,3
19,5,redo_speed_last_10sec,3
19,6,std_dev_backup_lcp_speed_last_10sec,3
19,7,std_dev_redo_speed_last_10sec,3
19,8,backup_lcp_speed_last_60sec,3
19,9,redo_speed_last_60sec,3
19,10,std_dev_backup_lcp_speed_last_60sec,3
19,11,std_dev_redo_speed_last_60sec,3
19,12,slowdowns_due_to_io_lag,3
19,13,slowdowns_due_to_high_cpu,3
19,14,disk_write_speed_set_to_min,3
19,15,current_target_disk_write_speed,3
20,0,node_id,2
20,1,block_instance,2
20,2,table_id,2
20,3,fragment_num,2
20,4,tot_key_reads,3
20,5,tot_key_inserts,3
20,6,tot_key_updates,3
20,7,tot_key_writes,3
20,8,tot_key_deletes,3
20,9,tot_key_refs,3
20,10,tot_key_attrinfo_bytes,3
20,11,tot_key_keyinfo_bytes,3
20,12,tot_key_prog_bytes,3
20,13,tot_key_inst_exec,3
20,14,tot_key_bytes_returned,3
20,15,tot_frag_scans,3
20,16,tot_scan_rows_examined,3
20,17,tot_scan_rows_returned,3
20,18,tot_scan_bytes_returned,3
20,19,tot_scan_prog_bytes,3
20,20,tot_scan_bound_bytes,3
20,21,tot_scan_inst_exec,3
20,22,tot_qd_frag_scans,3
20,23,conc_frag_scans,2
20,24,conc_qd_plain_frag_scans,2
20,25,conc_qd_tup_frag_scans,2
20,26,conc_qd_acc_frag_scans,2
20,27,tot_commits,3
21,0,node_id,2
21,1,node_restart_status,1
21,2,node_restart_status_int,2
21,3,secs_to_complete_node_failure,2
21,4,secs_to_allocate_node_id,2
21,5,secs_to_include_in_heartbeat_protocol,2
21,6,secs_until_wait_for_ndbcntr_master,2
21,7,secs_wait_for_ndbcntr_master,2
21,8,secs_to_get_start_permitted,2
21,9,secs_to_wait_for_lcp_for_copy_meta_data,2
21,10,secs_to_copy_meta_data,2
21,11,secs_to_include_node,2
21,12,secs_starting_node_to_request_local_recovery,2
21,13,secs_for_local_recovery,2
21,14,secs_restore_fragments,2
21,15,secs_undo_disk_data,2
21,16,secs_exec_redo_log,2
21,17,secs_index_rebuild,2
21,18,secs_to_synchronize_starting_node,2
21,19,secs_wait_lcp_for_restart,2
21,20,secs_wait_subscription_handover,2
21,21,total_restart_secs,2
22,0,node_id,2
22,1,block_number,2
22,2,block_instance,2
22,3,comm_node_id,2
22,4,upper_bound,3
22,5,scans,3
22,6,scan_errors,3
22,7,scan_fragments,3
22,8,scan_fragment_errors,3
22,9,transactions,3
22,10,transaction_errors,3
22,11,read_key_ops,3
22,12,write_key_ops,3
22,13,index_key_ops,3
22,14,key_op_errors,3
23,0,node_id,2
23,1,config_param,2
23,2,config_value,1
24,0,node_id,2
24,1,thr_no,2
24,2,thread_name,1
24,3,thread_description,1
25,0,node_id,2
25,1,thr_no,2
25,2,OS_user_time,2
25,3,OS_system_time,2
25,4,OS_idle_time,2
25,5,exec_time,2
25,6,sleep_time,2
25,7,spin_time,2
25,8,send_time,2
25,9,buffer_full_time,2
25,10,elapsed_time,2
26,0,node_id,2
26,1,thr_no,2
26,2,OS_user_time,2
26,3,OS_system_time,2
26,4,OS_idle_time,2
26,5,exec_time,2
26,6,sleep_time,2
26,7,spin_time,2
26,8,send_time,2
26,9,buffer_full_time,2
26,10,elapsed_time,2
27,0,node_id,2
27,1,thr_no,2
27,2,OS_user_time,2
27,3,OS_system_time,2
27,4,OS_idle_time,2
27,5,exec_time,2
27,6,sleep_time,2
27,7,spin_time,2
27,8,send_time,2
27,9,buffer_full_time,2
27,10,elapsed_time,2
28,0,node_id,2
28,1,thr_no,2
28,2,OS_user,2
28,3,OS_system,2
28,4,OS_idle,2
28,5,thread_exec,2
28,6,thread_sleeping,2
28,7,thread_spinning,2
28,8,thread_send,2
28,9,thread_buffer_full,2
28,10,elapsed_time,2
29,0,node_id,2
29,1,block_instance,2
29,2,table_id,2
29,3,fragment_num,2
29,4,ex_req,3
29,5,ex_imm_ok,3
29,6,ex_wait_ok,3
29,7,ex_wait_fail,3
29,8,sh_req,3
29,9,sh_imm_ok,3
29,10,sh_wait_ok,3
29,11,sh_wait_fail,3
29,12,wait_ok_millis,3
29,13,wait_fail_millis,3
30,0,node_id,2
30,1,block_instance,2
30,2,tableid,2
30,3,fragmentid,2
30,4,rowid,3
30,5,transid0,2
30,6,transid1,2
30,7,acc_op_id,2
30,8,op_flags,2
30,9,prev_serial_op_id,2
30,10,next_serial_op_id,2
30,11,prev_parallel_op_id,2
30,12,next_parallel_op_id,2
30,13,duration_millis,2
30,14,user_ptr,2
31,0,node_id,2
31,1,table_id,2
31,2,tab_copy_status,2
31,3,tab_update_status,2
31,4,tab_lcp_status,2
31,5,tab_status,2
31,6,tab_storage,2
31,7,tab_type,2
31,8,tab_partitions,2
31,9,tab_fragments,2
31,10,current_scan_count,2
31,11,scan_count_wait,2
31,12,is_reorg_ongoing,2
32,0,node_id,2
32,1,table_id,2
32,2,partition_id,2
32,3,fragment_id,2
32,4,partition_order,2
32,5,log_part_id,2
32,6,no_of_replicas,2
32,7,current_primary,2
32,8,preferred_primary,2
32,9,current_first_backup,2
32,10,current_second_backup,2
32,11,current_third_backup,2
32,12,num_alive_replicas,2
32,13,num_dead_replicas,2
32,14,num_lcp_replicas,2
33,0,node_id,2
33,1,table_id,2
33,2,fragment_id,2
33,3,initial_gci,2
33,4,replica_node_id,2
33,5,is_lcp_ongoing,2
33,6,num_crashed_replicas,2
33,7,last_max_gci_started,2
33,8,last_max_gci_completed,2
33,9,last_lcp_id,2
33,10,prev_lcp_id,2
33,11,prev_max_gci_started,2
33,12,prev_max_gci_completed,2
33,13,last_create_gci,2
33,14,last_replica_gci,2
33,15,is_replica_alive,2
34,0,node_id,2
34,1,table_id,2
34,2,tab_copy_status,2
34,3,tab_update_status,2
34,4,tab_lcp_status,2
34,5,tab_status,2
34,6,tab_storage,2
34,7,tab_type,2
34,8,tab_partitions,2
34,9,tab_fragments,2
34,10,current_scan_count,2
34,11,scan_count_wait,2
34,12,is_reorg_ongoing,2
35,0,node_id,2
35,1,table_id,2
35,2,partition_id,2
35,3,fragment_id,2
35,4,partition_order,2
35,5,log_part_id,2
35,6,no_of_replicas,2
35,7,current_primary,2
35,8,preferred_primary,2
35,9,current_first_backup,2
35,10,current_second_backup,2
35,11,current_third_backup,2
35,12,num_alive_replicas,2
35,13,num_dead_replicas,2
35,14,num_lcp_replicas,2
36,0,node_id,2
36,1,table_id,2
36,2,fragment_id,2
36,3,initial_gci,2
36,4,replica_node_id,2
36,5,is_lcp_ongoing,2
36,6,num_crashed_replicas,2
36,7,last_max_gci_started,2
36,8,last_max_gci_completed,2
36,9,last_lcp_id,2
36,10,prev_lcp_id,2
36,11,prev_max_gci_started,2
36,12,prev_max_gci_completed,2
36,13,last_create_gci,2
36,14,last_replica_gci,2
36,15,is_replica_alive,2
37,0,node_id,2
37,1,table_id,2
37,2,logged_table,2
37,3,row_contains_gci,2
37,4,row_contains_checksum,2
37,5,temporary_table,2
37,6,force_var_part,2
37,7,read_backup,2
37,8,fully_replicated,2
37,9,extra_row_gci,2
37,10,extra_row_author,2
37,11,storage_type,2
37,12,hashmap_id,2
37,13,hashmap_version,2
37,14,table_version,2
37,15,fragment_type,2
37,16,partition_balance,2
37,17,create_gci,2
37,18,backup_locked,2
37,19,single_user_mode,2
38,0,reporting_node_id,2
38,1,node_id,2
38,2,node_type,2
38,3,node_version,1
38,4,process_id,2
38,5,angel_process_id,2
38,6,process_name,1
38,7,service_URI,1
39,0,reporting_node_id,2
39,1,node_id,2
39,2,node_type,2
39,3,node_hostname,1
--- END NDB$INFO.COLUMNS ---

Additional Information.  [N/A]