dtm_worker_detail

2016-09-03 14:27:01   0  举报





仅支持查看

dtm_worker_detail 是一个用于记录和管理数据挖掘工作者详细信息的系统。它可以帮助组织更好地了解每个工作者的技能、经验和项目参与情况，从而优化资源分配和提高工作效率。通过 dtm_worker_detail，管理者可以方便地查看工作者的基本信息、教育背景、工作经历、技能特长等，以便为他们分配合适的任务和项目。此外，该系统还可以跟踪工作者的工作进度和成果，为绩效评估和激励提供有力支持。总之，dtm_worker_detail 是一个实用的工具，有助于提高数据挖掘团队的整体表现和竞争力。

作者其他创作

大纲/内容

if out of order

keep OUT/HUP

GLOBAL_XA_STATE_COMMIT

signal BUILD

if NOT AUTOCOMMIT

insert/push_backnode-vecto perserver query order within server

STATE_READ_AUTH_RESULT

client cache_cmds

[save_global_trx_id]LSET dgtid:global_trx_id 1 2(commit)

push_back send_buf

set IN/HUP

if COMMIT

send handshake

STATE_SEND_QUERY

send result

OUT

[save_global_status]EXISTS PREPARE_LOCKLSET xid_status:cur_xid 3 modify_time 4 affected_sids(curr servers) 0 1(prepare)

clear()

LOCAL_XA_STATE_PREPARING

LOCAL_XA_STATE_STARTED

epoll

IN/HUP

wakeup_fdsinsert client-pvs

STATE_READ_QUERY

if prepare lock(todo)

original query

set 0

read query

build(todo)

server Ap_vec_self_buf

STATE_CONNECTED_CLIENT

if QUERYof MULTI QUERY

STATE_READ_HANDSHAKE

commit_wait_build

XA ENDXA PREPARE

if MULTI QUERY

clientp_vec_last_query_servers

client pvs

[load_consistent_view]GET cur_checkpointHGETALL innodb_gid:checkpoint_xidSETEX checkpoint_xid:cur_xid 5 load[del_occupy_list]DEL checkpoint_xid:cur_xid

worker main

if all prepared

set OUT/HUP

LOCAL_XA_STATE_STARTING

send QUERY

check user/pwd

client sock

STATE_READ_AUTH_RESULTconn_pool_add

setview_map[server's sid] = gtid from db reply(in case of write sql)

if all committed

send XA COMMIT

client pvi

server A sock

send XA START

STATE_SEND_HANDSHAKE

read auth resultdirectly

clientp_map_multi_query

reset

if not all committed

read query result

STATE_CONNECTED_SERVER

GLOBAL_XA_STATE_START

BEFORE LAST QUERY

OUT/HUP

client tranx state

1.SET NAMES2.USE DB

add READVIEW for SELECT

LOCAL_XA_STATE_COMMITTED

insert/push_backserver(redundant)to perserver query order across server

FOLLOWING SERVERS

1.SET NAMES2.USE DB3. XA START

handle DDL(todo)

STATE_SEND_AUTH_RESULT

[save_global_status]LSET xid_status:cur_xid 3 modify_time 4 affected_sids(curr servers) 0 1(prepare)

SQL_XA_START_NUM

server A tranx state

if XA START

STATE_READ_QUERY_RESULT

central redis

read auth

loop wakeup_fds

incrclient-query result cntserver-recv query num

getview_map[server]

if all local started

LOCAL_XA_STATE_COMMITTING

nothing

if START TRANSACTION

cache set charset

send auth result

set b_c_xid/view_map[this server's sid] from pvi

setview_map[this server's sid] from pvi

[save_global_trx_id]INCR global_trx_idRPUSH dgtid:global_trx_id cur_xid 1(prepare)

XA COMMIT

server A query

p_vec_last_query_servers[client-query result cnt]perserve query order

STATE_SEND_AUTH

if AUTOCOMMIT

if not all prepared

FIRST SERVER

LOCAL_XA_STATE_PREPARED

send auth

read handshake

worker redis

every loop

STATE_READ_AUTH

GLOBAL_XA_STATE_PREPARE

send XA END/PREPARE

LAST QUERY

[save_global_status]RPUSH xid_status:cur_xid 0(start) 0 b_c_xid modify_time affected_sids(first server)INCR ref_count:b_c_xidSADD ref_count_set:b_c_xid cur_xid

append all server's vec_self_buf to client-send_bufand then free()

load view_mapbase_checkpoint_xid from central redis

client query

lock redis

cache use db