/!40111 SET SQL_NOTES=@OLD_SQL_NOTES/;

核心机制总结

在结构化Block入库中，入库字段如下：。

* puidworker_idworker_full_namejob_idheighthash

#-l指定日志目录

//比特币节点

{

rpc_addr = ""; //rpc地址

}

;

//kafka群集

kafka = {

};

//mysql配置，用于存储检测到的块

pooldb = {

host = "";

port = 3306;

dbname = "";

};

found_块数据库结构

-- ------------------------------------------------------

/!40101 SET NAMES utf8/;

/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE/;

/!40103 SET TIME_ZONE='+00:00'/;

/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0/;

/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'/;

/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0/;

--

DROP TABLE IF EXISTS found_blocks;

CREATE TABLE found_blocks

puid int NOT NULL,

worker_id bigint NOT NULL,

height int NOT NULL,

hash char NOT NULL,

size int NOT NULL,

prev_hash char NOT NULL,

UNIQUE KEY hash ,

KEY height

--

DROP TABLE IF EXISTS found_nmc_blocks;

CREATE TABLE found_nmc_blocks

aux_block_hash char NOT NULL,

aux_pow text NOT NULL,

UNIQUE KEY aux_block_hash

--

worker_id bigint NOT NULL,

puid int NOT NULL,

group_id int NOT NULL,

UNIQUE KEY puid_worker_id ,

KEY puid_group_id

--

worker_id bigint NOT NULL,

puid int NOT NULL,

group_id int NOT NULL,

UNIQUE KEY puid_worker_id ,

KEY puid_group_id

/!40103 SET TIME_ZONE=@OLD_TIME_ZONE/;

/!40101 SET SQL_MODE=@OLD_SQL_MODE/;

/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS/;

/!40111 SET SQL_NOTES=@OLD_SQL_NOTES/;

CREATE TABLE `found_blocks`

`puid` int NOT NULL,

`worker_id` bigint NOT NULL,

`height` int NOT NULL,

`hash` char NOT NULL,

`size` int NOT NULL,

`prev_hash` char NOT NULL,

UNIQUE KEY `hash` ,

KEY `height`

[新闻资讯]