^Weak Consistency: A Generalized Theory and Optimistic Implementations for Distributed Transactionshttp:/...
2019-07-11 20:11:43.520 [0-0-0-reader] INFO ReaderTask - exe sql: select /*+READ_CONSISTENCY(WEAK)*/ id,k,c,pad from sbtest1 partition(p0) where (id) > (?) order by id asc limit 100000 Thu Jul 11 20:11:43 GMT+08:00 2019 INFO: success to create connection, ip=11.***....
《weak consistency: A Generalized Theory and Optimistic Implementations for Distributed Transactions》:定义了读写依赖,通过读写依赖表明不可串行化必须是多版本可串行化图(MVSG multivertion serialization graphc)存在两条读写依赖边形成的环。 《Making snapshot isolation serializable》:定义读写依赖的扩展形式,表...
SHOW CREATE TABLE db_bin.t_parttable; SELECT /*+read_consistency(weak)*/ * FROM db_bin.t_parttable ORDER BY id ; # 查看租户的资源单元(Unit)分布 SELECT tenant_name, unit_id,zone,svr_ip,max_cpu,round(max_memory/1024/1024/1024) max_mem_gb FROM gv$unit; # 查看租户的负载均衡历史 S...
1 select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ zone, name, value, time_to_usec(now()) as current from __all_zone 2 select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ __all_tenant.tenant_id, tenant_name, cache_name, cache_size from __all_virtual_kvcache_info, __all_tenan...
同时,读写分离改造涉及到增加 SQL Hint /*+READ_CONSISTENCY(WEAK) */ 的问题 。SQL Hint 在传统的关系型数据库中是一种通过注释的方式改写 SQL 执行计划的设计,而在 OceanBase 中它同样有类似功能,并且提供了 SQL 选择副本访问策略的能力。为了使弱一致性读生效,需要对有读写分离需求应用中的 SQL 做如下改造...
enable_read_write_split enable_server_ssl enable_transaction_split enable_weak_reroute mysql_version ob_max_read_stale_time obproxy_force_parallel_query_dop obproxy_read_consistency obproxy_read_only observer_query_timeout_delta observer_sys_password observer_sys_password1 proxy_idc_name proxy_primary...
shall_collect() : Session_consistency_gtids_ctxshall_compress() : Binlog_cache_compressorshall_ignore_server_id() : Master_infoshall_skip() : Log_eventshall_skip_transaction() : Binlog_iterator_ctxshallow_explain() : anonymous_namespace{opt_explain.cc}::Explain, anonymous_namespace{opt_...
handle_read_result() : net::tls::SyncActionhandle_records_error() : handlerhandle_recovery_message() : Plugin_gcs_events_handlerhandle_recovery_metadata() : Certification_handler, Plugin_gcs_events_handlerhandle_remote_prepare() : Transaction_consistency_info, Transaction_consistency_manager...
(Bug #37339) • For a MyISAM table with CHECKSUM = 1 and ROW_FORMAT = DYNAMIC table options, a data consistency check (maximum record length) could fail and cause the table to be marked as corrupted. (Bug #37310) • The max_length result set metadata value was calculated ...