 运维上海2017-从理论到实践,深度解析MySQL Group Replication -徐春阳int handle(const uchar *data, ulong len)! 267 {! 268 this->incoming->push(new Data_packet(data, len));! 269 return 0;! 270 }! �:���process_notification������������� ������ Applier_module::applier_thread_handle! ��incoming������! ����(packet)�����������! Applier��! ���DATA_PACKET_TYPE���binlog�����apply_data_packet��! Certification_handler::handle_event ����! Certificati applier_thread_handle���� ! this->incoming->front(&packet); // blocking! ! switch (packet->get_packet_type())! {! case ACTION_PACKET_TYPE:! this->incoming->pop();! �0 码力 | 32 页 | 9.55 MB | 1 年前3 运维上海2017-从理论到实践,深度解析MySQL Group Replication -徐春阳int handle(const uchar *data, ulong len)! 267 {! 268 this->incoming->push(new Data_packet(data, len));! 269 return 0;! 270 }! �:���process_notification������������� ������ Applier_module::applier_thread_handle! ��incoming������! ����(packet)�����������! Applier��! ���DATA_PACKET_TYPE���binlog�����apply_data_packet��! Certification_handler::handle_event ����! Certificati applier_thread_handle���� ! this->incoming->front(&packet); // blocking! ! switch (packet->get_packet_type())! {! case ACTION_PACKET_TYPE:! this->incoming->pop();! �0 码力 | 32 页 | 9.55 MB | 1 年前3
 firebird wire protocolDescription Value Optional isc_dpb_version1 Version (must be first item!) isc_dpb_dummy_packet_interval Dummy packet interval 120 * isc_dpb_sql_dialect SQL dialect 3 Chapter 3. Databases 7 Parameter updated per each message), array of Int32, length is equal to "Number of update counters" field in packet. Buffer Detailed info about errors in batch (for each error server sends number of message (Int32) in op_response). Number of such pairs is equal to "Number of per-message error blocks" field in packet. Chapter 8. Batches 28 Buffer Simplified error blocks (for each error server sends number of0 码力 | 40 页 | 213.15 KB | 1 年前3 firebird wire protocolDescription Value Optional isc_dpb_version1 Version (must be first item!) isc_dpb_dummy_packet_interval Dummy packet interval 120 * isc_dpb_sql_dialect SQL dialect 3 Chapter 3. Databases 7 Parameter updated per each message), array of Int32, length is equal to "Number of update counters" field in packet. Buffer Detailed info about errors in batch (for each error server sends number of message (Int32) in op_response). Number of such pairs is equal to "Number of per-message error blocks" field in packet. Chapter 8. Batches 28 Buffer Simplified error blocks (for each error server sends number of0 码力 | 40 页 | 213.15 KB | 1 年前3
 The Vitess 7.0 Documentationmessages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 254 页 | 949.63 KB | 1 年前3 The Vitess 7.0 Documentationmessages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 254 页 | 949.63 KB | 1 年前3
 The Vitess 11.0 Documentationlc_time_names CheckAndIgnore 25 System variable Handled lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 481 页 | 3.14 MB | 1 年前3 The Vitess 11.0 Documentationlc_time_names CheckAndIgnore 25 System variable Handled lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 481 页 | 3.14 MB | 1 年前3
 The Vitess 10.0 Documentation
interactive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 455 页 | 3.07 MB | 1 年前3 The Vitess 10.0 Documentation
interactive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 455 页 | 3.07 MB | 1 年前3
 The Vitess 12.0 Documentationinteractive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest source (default “PRIMARY,REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 534 页 | 3.32 MB | 1 年前3 The Vitess 12.0 Documentationinteractive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest source (default “PRIMARY,REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 534 页 | 3.32 MB | 1 年前3
 TiDB v6.1 Documentationslow queries on the Grafana dashboard #33893 • Fix the issue that the system variable max_allowed_packet does not take effect #31422 • Fix the issue of memory leak in the TopSQL module #34525 #34502 • • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” 2.6.2 Features that are different from MySQL 2.6.2.1 Auto-increment ID • In TiDB, auto-incremental connections for keep-alive. If you often see the following error in your Java application: The last packet sent successfully to the server was 3600000 milliseconds ago �→ . The driver has not received any0 码力 | 4487 页 | 84.44 MB | 1 年前3 TiDB v6.1 Documentationslow queries on the Grafana dashboard #33893 • Fix the issue that the system variable max_allowed_packet does not take effect #31422 • Fix the issue of memory leak in the TopSQL module #34525 #34502 • • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” 2.6.2 Features that are different from MySQL 2.6.2.1 Auto-increment ID • In TiDB, auto-incremental connections for keep-alive. If you often see the following error in your Java application: The last packet sent successfully to the server was 3600000 milliseconds ago �→ . The driver has not received any0 码力 | 4487 页 | 84.44 MB | 1 年前3
 The Vitess 8.0 Documentationinteractive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 331 页 | 1.35 MB | 1 年前3 The Vitess 8.0 Documentationinteractive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest as a source (default “REPLICA”) -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 331 页 | 1.35 MB | 1 年前3
 TiDB v5.4 Documentationtoo high. – Check the TCP panel on the Grafana Node Exporter page to check whether there is any packet loss. 7.6 TiFlash Alert Rules This document introduces the alert rules of the TiFlash cluster. Examples. 9.1.1.1.3 BCC/bpftrace Starting from CentOS 7.6, the Linux kernel has supported Berkeley Packet Filter (BPF). Therefore, you can choose proper tools to conduct an in-depth analysis based on the the following aspects in the network packet processing might become the bottleneck and affect performance: • NIC hardware cache: To correctly observe the packet loss at the hardware level, use the ethtool0 码力 | 3650 页 | 52.72 MB | 1 年前3 TiDB v5.4 Documentationtoo high. – Check the TCP panel on the Grafana Node Exporter page to check whether there is any packet loss. 7.6 TiFlash Alert Rules This document introduces the alert rules of the TiFlash cluster. Examples. 9.1.1.1.3 BCC/bpftrace Starting from CentOS 7.6, the Linux kernel has supported Berkeley Packet Filter (BPF). Therefore, you can choose proper tools to conduct an in-depth analysis based on the the following aspects in the network packet processing might become the bottleneck and affect performance: • NIC hardware cache: To correctly observe the packet loss at the hardware level, use the ethtool0 码力 | 3650 页 | 52.72 MB | 1 年前3
 The Vitess 9.0 Documentationinteractive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest “REPLICA”) 157 Name Type Definition -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 417 页 | 2.96 MB | 1 年前3 The Vitess 9.0 Documentationinteractive_timeout CheckAndIgnore lc_time_names CheckAndIgnore lock_wait_timeout CheckAndIgnore max_allowed_packet CheckAndIgnore max_error_count CheckAndIgnore max_execution_time CheckAndIgnore max_join_size CheckAndIgnore messages that are older than 86400 seconds (1 day). • vt_batch_size=10: Send up to 10 messages per RPC packet. • vt_cache_size=10000: Store up to 10000 messages in the cache. If the demand is higher, the rest “REPLICA”) 157 Name Type Definition -vstream_packet_size int Suggested packet size for VReplication streamer. This is used only as a recommendation. The actual packet size may be more or less than this amount0 码力 | 417 页 | 2.96 MB | 1 年前3
共 131 条
- 1
- 2
- 3
- 4
- 5
- 6
- 14














