10bet官方网站文档家里
NDB集群内部
下载本手册
PDF(美国LTR)- 1.2 mb
PDF (A4)- 1.2 mb
HTML下载(TGZ)- 381.6 kb
HTML下载(ZIP)- 392.3 kb


2.159转储14002.

代码

14002

象征

DbinfoListColumns

内核块

DBINFO

描述。在all中写入所有列的列表ndbinfo数据节点日志的表。每列以格式列出table_idcolumn_idcolumn_namecolumn_typecode.。表id是从转储14001。列类型代码如下表所示:

表2.10 DUMP 14002列类型

代码 类型
1 细绳
2 整数
3. 十进制

示例输出。

---开始ndb $ info.columns --- 0,0,table_id,2 0,1,table_name,1 0,2,注释,1,0,table_id,2 1,1,column_id,2 1,2那column_name那11那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 ---

附加信息。(N / A)