10bet网址
MySQL8.0参考手册
10bet官方网站相关文档 下载手册
PDF(USLTR)-41.1Mb
PDF(A4)-412Mb
PDF(RPM)-39.8Mb
html下载-9.5Mb
html下载-9.6Mb
html下载8.1Mb
曼页260.5Kb
曼页s- 371.7Kb
Info(Gzip)-3.9Mb
Info(Zip)-3.9Mb
摘自手册

MySQL8.0参考手册/ ./ 快速引用:NDB集群SQL语句

23.5.16快速参考:NDB集群SQL语句

本节讨论数个SQL语句,这些语句可证明对管理监控 MySQL服务器有用,该服务器连接NDB集群,并在某些情况下提供集群本身信息

  • 显示引擎数据库状态,显示引擎数据库状态

    本语句输出包含服务器集群连接信息,NDB集群对象创建使用信息,NDB集群复制二进制日志信息

    看吧第13.7.15节,SHOW工程语句中用例和更详细的信息

  • 显示网络

    语句可用于判定MySQL服务器是否启动聚类支持,如果启动,它是否活动

    看吧第13.7.16节,'SHOWENGINS声明'详细信息

    注解

    语句不支持喜欢条款可使用喜欢过滤查询对INFORMATION_SCHEMA.ENGINES表格下项讨论

  • sect*Inforce_SCHEMA.Engines

    等值显示网络中使用ENGINES系统表格中INFORMATION_SCHEMA数据库中不同于案例显示网络语句中可用a过滤结果喜欢并选择特定的列获取脚本中可能使用的信息例举 下查询显示服务器是否搭建NDB系统支持,如果有的话,它是否被激活

    mysql sect工程支持信息schema.engines-++++支持+++++++

    ifNDB系统未启动支持, 前置查询返回空集看吧26.3.13节“Inforce_SCHEMAENGINSE表”详解

  • showVablips像NDB%

    本语句提供服务器系统变量列表NDB系统存储引擎和值显示如下

    mysqlshowVaribers像'NDB%'+--------------------------------------+---------------------------------------+ | Variable_name                        | Value                                 | +--------------------------------------+---------------------------------------+ | ndb_allow_copying_alter_table        | ON                                    | | ndb_autoincrement_prefetch_sz        | 512                                   | | ndb_batch_size                       | 32768                                 | | ndb_blob_read_batch_bytes            | 65536                                 | | ndb_blob_write_batch_bytes           | 65536                                 | | ndb_clear_apply_status               | ON                                    | | ndb_cluster_connection_pool          | 1                                     | | ndb_cluster_connection_pool_nodeids  |                                       | | ndb_connectstring                    | 127.0.0.1                             | | ndb_data_node_neighbour              | 0                                     | | ndb_default_column_format            | FIXED                                 | | ndb_deferred_constraints             | 0                                     | | ndb_distribution                     | KEYHASH                               | | ndb_eventbuffer_free_percent         | 20                                    | | ndb_eventbuffer_max_alloc            | 0                                     | | ndb_extra_logging                    | 1                                     | | ndb_force_send                       | ON                                    | | ndb_fully_replicated                 | OFF                                   | | ndb_index_stat_enable                | ON                                    | | ndb_index_stat_option                | loop_enable=1000ms,loop_idle=1000ms, loop_busy=100ms,update_batch=1,read_batch=4,idle_batch=32,check_batch=8, check_delay=10m,delete_batch=8,clean_delay=1m,error_batch=4,error_delay=1m, evict_batch=8,evict_delay=1m,cache_limit=32M,cache_lowpct=90,zero_total=0      | | ndb_join_pushdown                    | ON                                    | | ndb_log_apply_status                 | OFF                                   | | ndb_log_bin                          | OFF                                   | | ndb_log_binlog_index                 | ON                                    | | ndb_log_empty_epochs                 | OFF                                   | | ndb_log_empty_update                 | OFF                                   | | ndb_log_exclusive_reads              | OFF                                   | | ndb_log_orig                         | OFF                                   | | ndb_log_transaction_id               | OFF                                   | | ndb_log_update_as_write              | ON                                    | | ndb_log_update_minimal               | OFF                                   | | ndb_log_updated_only                 | ON                                    | | ndb_metadata_check                   | ON                                    | | ndb_metadata_check_interval          | 60                                    | | ndb_metadata_sync                    | OFF                                   | | ndb_mgmd_host                        | 127.0.0.1                             | | ndb_nodeid                           | 0                                     | | ndb_optimization_delay               | 10                                    | | ndb_optimized_node_selection         | 3                                     | | ndb_read_backup                      | ON                                    | | ndb_recv_thread_activation_threshold | 8                                     | | ndb_recv_thread_cpu_mask             |                                       | | ndb_report_thresh_binlog_epoch_slip  | 10                                    | | ndb_report_thresh_binlog_mem_usage   | 10                                    | | ndb_row_checksum                     | 1                                     | | ndb_schema_dist_lock_wait_timeout    | 30                                    | | ndb_schema_dist_timeout              | 120                                   | | ndb_schema_dist_upgrade_allowed      | ON                                    | | ndb_show_foreign_key_mock_tables     | OFF                                   | | ndb_slave_conflict_role              | NONE                                  | | ndb_table_no_logging                 | OFF                                   | | ndb_table_temporary                  | OFF                                   | | ndb_use_copying_alter_table          | OFF                                   | | ndb_use_exact_count                  | OFF                                   | | ndb_use_transactions                 | ON                                    | | ndb_version                          | 524308                                | | ndb_version_string                   | ndb-8.0.26                            | | ndb_wait_connected                   | 30                                    | | ndb_wait_setup                       | 30                                    | | ndbinfo_database                     | ndbinfo                               | | ndbinfo_max_bytes                    | 0                                     | | ndbinfo_max_rows                     | 10                                    | | ndbinfo_offline                      | OFF                                   | | ndbinfo_show_hidden                  | OFF                                   | | ndbinfo_table_prefix                 | ndb$                                  | | ndbinfo_version                      | 524308                                | +--------------------------------------+---------------------------------------+

    看吧5.1.8节,服务员系统变量详解

  • select*从性能_schema.global

    本语句等量显示视频上项描述语句并提供几乎完全相同的输出,如下表所示:

    mysql/SELECT*从性能_schema.global_Vible-+--------------------------------------+---------------------------------------+ | VARIABLE_NAME                        | VARIABLE_VALUE                        | +--------------------------------------+---------------------------------------+ | ndb_allow_copying_alter_table        | ON                                    | | ndb_autoincrement_prefetch_sz        | 512                                   | | ndb_batch_size                       | 32768                                 | | ndb_blob_read_batch_bytes            | 65536                                 | | ndb_blob_write_batch_bytes           | 65536                                 | | ndb_clear_apply_status               | ON                                    | | ndb_cluster_connection_pool          | 1                                     | | ndb_cluster_connection_pool_nodeids  |                                       | | ndb_connectstring                    | 127.0.0.1                             | | ndb_data_node_neighbour              | 0                                     | | ndb_default_column_format            | FIXED                                 | | ndb_deferred_constraints             | 0                                     | | ndb_distribution                     | KEYHASH                               | | ndb_eventbuffer_free_percent         | 20                                    | | ndb_eventbuffer_max_alloc            | 0                                     | | ndb_extra_logging                    | 1                                     | | ndb_force_send                       | ON                                    | | ndb_fully_replicated                 | OFF                                   | | ndb_index_stat_enable                | ON                                    | | ndb_index_stat_option                | loop_enable=1000ms,loop_idle=1000ms, loop_busy=100ms,update_batch=1,read_batch=4,idle_batch=32,check_batch=8, check_delay=10m,delete_batch=8,clean_delay=1m,error_batch=4,error_delay=1m, evict_batch=8,evict_delay=1m,cache_limit=32M,cache_lowpct=90,zero_total=0      | | ndb_join_pushdown                    | ON                                    | | ndb_log_apply_status                 | OFF                                   | | ndb_log_bin                          | OFF                                   | | ndb_log_binlog_index                 | ON                                    | | ndb_log_empty_epochs                 | OFF                                   | | ndb_log_empty_update                 | OFF                                   | | ndb_log_exclusive_reads              | OFF                                   | | ndb_log_orig                         | OFF                                   | | ndb_log_transaction_id               | OFF                                   | | ndb_log_update_as_write              | ON                                    | | ndb_log_update_minimal               | OFF                                   | | ndb_log_updated_only                 | ON                                    | | ndb_metadata_check                   | ON                                    | | ndb_metadata_check_interval          | 60                                    | | ndb_metadata_sync                    | OFF                                   | | ndb_mgmd_host                        | 127.0.0.1                             | | ndb_nodeid                           | 0                                     | | ndb_optimization_delay               | 10                                    | | ndb_optimized_node_selection         | 3                                     | | ndb_read_backup                      | ON                                    | | ndb_recv_thread_activation_threshold | 8                                     | | ndb_recv_thread_cpu_mask             |                                       | | ndb_report_thresh_binlog_epoch_slip  | 10                                    | | ndb_report_thresh_binlog_mem_usage   | 10                                    | | ndb_row_checksum                     | 1                                     | | ndb_schema_dist_lock_wait_timeout    | 30                                    | | ndb_schema_dist_timeout              | 120                                   | | ndb_schema_dist_upgrade_allowed      | ON                                    | | ndb_show_foreign_key_mock_tables     | OFF                                   | | ndb_slave_conflict_role              | NONE                                  | | ndb_table_no_logging                 | OFF                                   | | ndb_table_temporary                  | OFF                                   | | ndb_use_copying_alter_table          | OFF                                   | | ndb_use_exact_count                  | OFF                                   | | ndb_use_transactions                 | ON                                    | | ndb_version                          | 524308                                | | ndb_version_string                   | ndb-8.0.26                            | | ndb_wait_connected                   | 30                                    | | ndb_wait_setup                       | 30                                    | | ndbinfo_database                     | ndbinfo                               | | ndbinfo_max_bytes                    | 0                                     | | ndbinfo_max_rows                     | 10                                    | | ndbinfo_offline                      | OFF                                   | | ndbinfo_show_hidden                  | OFF                                   | | ndbinfo_table_prefix                 | ndb$                                  | | ndbinfo_version                      | 524308                                | +--------------------------------------+---------------------------------------+

    不同于案例显示视频语句中可选择单列例举 :

    mysql/selectVaible_send+----------------+ | VARIABLE_VALUE | +----------------+ | ON             | +----------------+

    更多实用查询显示于此 :

    mysql/SELECTVAY_NAME As Name/VAIEBLEVAULEVERUE值+++++++++++++++++++++++++++++++++

    更多信息见第27.12.15节,“性能Schema状态变量表”。5.1.8节,服务员系统变量.

  • show状态像'NDB%'

    This statement shows at a glance whether or not the MySQL server is acting as a cluster SQL node, and if so, it provides the MySQL server's cluster node ID, the host name and port for the cluster management server to which it is connected, and the number of data nodes in the cluster, as shown here:

    mysqlshow状态像'NDB%'+----------------------------------------------+-------------------------------+ | Variable_name                                | Value                         | +----------------------------------------------+-------------------------------+ | Ndb_metadata_detected_count                  | 0                             | | Ndb_cluster_node_id                          | 100                           | | Ndb_config_from_host                         | 127.0.0.1                     | | Ndb_config_from_port                         | 1186                          | | Ndb_number_of_data_nodes                     | 2                             | | Ndb_number_of_ready_data_nodes               | 2                             | | Ndb_connect_count                            | 0                             | | Ndb_execute_count                            | 0                             | | Ndb_scan_count                               | 0                             | | Ndb_pruned_scan_count                        | 0                             | | Ndb_schema_locks_count                       | 0                             | | Ndb_api_wait_exec_complete_count_session     | 0                             | | Ndb_api_wait_scan_result_count_session       | 0                             | | Ndb_api_wait_meta_request_count_session      | 1                             | | Ndb_api_wait_nanos_count_session             | 163446                        | | Ndb_api_bytes_sent_count_session             | 60                            | | Ndb_api_bytes_received_count_session         | 28                            | | Ndb_api_trans_start_count_session            | 0                             | | Ndb_api_trans_commit_count_session           | 0                             | | Ndb_api_trans_abort_count_session            | 0                             | | Ndb_api_trans_close_count_session            | 0                             | | Ndb_api_pk_op_count_session                  | 0                             | | Ndb_api_uk_op_count_session                  | 0                             | | Ndb_api_table_scan_count_session             | 0                             | | Ndb_api_range_scan_count_session             | 0                             | | Ndb_api_pruned_scan_count_session            | 0                             | | Ndb_api_scan_batch_count_session             | 0                             | | Ndb_api_read_row_count_session               | 0                             | | Ndb_api_trans_local_read_row_count_session   | 0                             | | Ndb_api_adaptive_send_forced_count_session   | 0                             | | Ndb_api_adaptive_send_unforced_count_session | 0                             | | Ndb_api_adaptive_send_deferred_count_session | 0                             | | Ndb_trans_hint_count_session                 | 0                             | | Ndb_sorted_scan_count                        | 0                             | | Ndb_pushed_queries_defined                   | 0                             | | Ndb_pushed_queries_dropped                   | 0                             | | Ndb_pushed_queries_executed                  | 0                             | | Ndb_pushed_reads                             | 0                             | | Ndb_last_commit_epoch_server                 | 37632503447571                | | Ndb_last_commit_epoch_session                | 0                             | | Ndb_system_name                              | MC_20191126162038             | | Ndb_api_event_data_count_injector            | 0                             | | Ndb_api_event_nondata_count_injector         | 0                             | | Ndb_api_event_bytes_count_injector           | 0                             | | Ndb_api_wait_exec_complete_count_slave       | 0                             | | Ndb_api_wait_scan_result_count_slave         | 0                             | | Ndb_api_wait_meta_request_count_slave        | 0                             | | Ndb_api_wait_nanos_count_slave               | 0                             | | Ndb_api_bytes_sent_count_slave               | 0                             | | Ndb_api_bytes_received_count_slave           | 0                             | | Ndb_api_trans_start_count_slave              | 0                             | | Ndb_api_trans_commit_count_slave             | 0                             | | Ndb_api_trans_abort_count_slave              | 0                             | | Ndb_api_trans_close_count_slave              | 0                             | | Ndb_api_pk_op_count_slave                    | 0                             | | Ndb_api_uk_op_count_slave                    | 0                             | | Ndb_api_table_scan_count_slave               | 0                             | | Ndb_api_range_scan_count_slave               | 0                             | | Ndb_api_pruned_scan_count_slave              | 0                             | | Ndb_api_scan_batch_count_slave               | 0                             | | Ndb_api_read_row_count_slave                 | 0                             | | Ndb_api_trans_local_read_row_count_slave     | 0                             | | Ndb_api_adaptive_send_forced_count_slave     | 0                             | | Ndb_api_adaptive_send_unforced_count_slave   | 0                             | | Ndb_api_adaptive_send_deferred_count_slave   | 0                             | | Ndb_slave_max_replicated_epoch               | 0                             | | Ndb_api_wait_exec_complete_count             | 4                             | | Ndb_api_wait_scan_result_count               | 7                             | | Ndb_api_wait_meta_request_count              | 172                           | | Ndb_api_wait_nanos_count                     | 1083548094028                 | | Ndb_api_bytes_sent_count                     | 4640                          | | Ndb_api_bytes_received_count                 | 109356                        | | Ndb_api_trans_start_count                    | 4                             | | Ndb_api_trans_commit_count                   | 1                             | | Ndb_api_trans_abort_count                    | 1                             | | Ndb_api_trans_close_count                    | 4                             | | Ndb_api_pk_op_count                          | 2                             | | Ndb_api_uk_op_count                          | 0                             | | Ndb_api_table_scan_count                     | 1                             | | Ndb_api_range_scan_count                     | 1                             | | Ndb_api_pruned_scan_count                    | 0                             | | Ndb_api_scan_batch_count                     | 1                             | | Ndb_api_read_row_count                       | 3                             | | Ndb_api_trans_local_read_row_count           | 2                             | | Ndb_api_adaptive_send_forced_count           | 1                             | | Ndb_api_adaptive_send_unforced_count         | 5                             | | Ndb_api_adaptive_send_deferred_count         | 0                             | | Ndb_api_event_data_count                     | 0                             | | Ndb_api_event_nondata_count                  | 0                             | | Ndb_api_event_bytes_count                    | 0                             | | Ndb_metadata_excluded_count                  | 0                             | | Ndb_metadata_synced_count                    | 0                             | | Ndb_conflict_fn_max                          | 0                             | | Ndb_conflict_fn_old                          | 0                             | | Ndb_conflict_fn_max_del_win                  | 0                             | | Ndb_conflict_fn_epoch                        | 0                             | | Ndb_conflict_fn_epoch_trans                  | 0                             | | Ndb_conflict_fn_epoch2                       | 0                             | | Ndb_conflict_fn_epoch2_trans                 | 0                             | | Ndb_conflict_trans_row_conflict_count        | 0                             | | Ndb_conflict_trans_row_reject_count          | 0                             | | Ndb_conflict_trans_reject_count              | 0                             | | Ndb_conflict_trans_detect_iter_count         | 0                             | | Ndb_conflict_trans_conflict_commit_count     | 0                             | | Ndb_conflict_epoch_delete_delete_count       | 0                             | | Ndb_conflict_reflected_op_prepare_count      | 0                             | | Ndb_conflict_reflected_op_discard_count      | 0                             | | Ndb_conflict_refresh_op_count                | 0                             | | Ndb_conflict_last_conflict_epoch             | 0                             | | Ndb_conflict_last_stable_epoch               | 0                             | | Ndb_index_stat_status                        | allow:1,enable:1,busy:0, loop:1000,list:(new:0,update:0,read:0,idle:0,check:0,delete:0,error:0,total:0), analyze:(queue:0,wait:0),stats:(nostats:0,wait:0),total:(analyze:(all:0,error:0), query:(all:0,nostats:0,error:0),event:(act:0,skip:0,miss:0),cache:(refresh:0, clean:0,pinned:0,drop:0,evict:0)),cache:(query:0,clean:0,drop:0,evict:0, usedpct:0.00,highpct:0.00)                                                     | | Ndb_index_stat_cache_query                   | 0                             | | Ndb_index_stat_cache_clean                   | 0                             | +----------------------------------------------+-------------------------------+

    MySQL服务器搭建NDB系统支持,但目前它不连接集群,本语句输出中的每一行都含有0或空字符串值传列内

    并见第13.7.37节,“show状态说明”。.

  • select*从性能_schema.global_status

    语句提供相似输出showstatus上项中讨论的语句与案例不同showstatus中,它有可能使用安全选择语句提取SQL值用于脚本监控自动化

    更多信息见第27.12.15节,“性能Schema状态变量表”。.

  • sect*Inforce_SCHEMA.PLUGINS中PLUGINE像NDB%

    本语句显示信息INFORMATION_SCHEMA.PLUGINS插件表NDB集群相关联,例如版本、作者和许可,如下表显示:

    mysql/select *来自Inforce_SCHEMA.PLUGINS > PLUGINE像NDB%/G########row ***************************            PLUGIN_NAME: ndbcluster         PLUGIN_VERSION: 1.0          PLUGIN_STATUS: ACTIVE            PLUGIN_TYPE: STORAGE ENGINE    PLUGIN_TYPE_VERSION: 80027.0         PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL          PLUGIN_AUTHOR: Oracle Corporation     PLUGIN_DESCRIPTION: Clustered, fault-tolerant tables         PLUGIN_LICENSE: GPL            LOAD_OPTION: ON *************************** 2.row ***************************            PLUGIN_NAME: ndbinfo         PLUGIN_VERSION: 0.1          PLUGIN_STATUS: ACTIVE            PLUGIN_TYPE: STORAGE ENGINE    PLUGIN_TYPE_VERSION: 80027.0         PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL          PLUGIN_AUTHOR: Oracle Corporation     PLUGIN_DESCRIPTION: MySQL Cluster system information storage engine         PLUGIN_LICENSE: GPL            LOAD_OPTION: ON *************************** 3.row ***************************            PLUGIN_NAME: ndb_transid_mysql_connection_map         PLUGIN_VERSION: 0.1          PLUGIN_STATUS: ACTIVE            PLUGIN_TYPE: INFORMATION SCHEMA    PLUGIN_TYPE_VERSION: 80027.0         PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL          PLUGIN_AUTHOR: Oracle Corporation     PLUGIN_DESCRIPTION: Map between MySQL connection ID and NDB transaction ID         PLUGIN_LICENSE: GPL            LOAD_OPTION: ON

    您也可以使用显示平台语句显示此信息,但语句输出无法轻易过滤并见MySQL插件API描述信息在哪里和如何PLUGINS大全表格获取

中表查询dbinfo信息数据库实时数据多NDB集群操作看吧第23.5.14节,ndbinfo:NDB集群信息数据库.