Movatterモバイル変換

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

Sample Output. 

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

Additional Information.  [N/A]