-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathindex.html
228 lines (224 loc) · 33.5 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta name="generator" content="Hugo 0.90.0-DEV" />
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="robots" content="noodp" />
<meta http-equiv="X-UA-Compatible" content="IE=edge, chrome=1">
<title>深白色9527</title><meta name="Description" content="深白色9527"><meta property="og:title" content="深白色9527" />
<meta property="og:description" content="深白色9527" />
<meta property="og:type" content="website" />
<meta property="og:url" content="https://shenbaise9527.com/" /><meta property="og:image" content="https://shenbaise9527.com/logo.png"/>
<meta name="twitter:card" content="summary_large_image"/>
<meta name="twitter:image" content="https://shenbaise9527.com/logo.png"/>
<meta name="twitter:title" content="深白色9527"/>
<meta name="twitter:description" content="深白色9527"/>
<meta name="application-name" content="深白色9527">
<meta name="apple-mobile-web-app-title" content="深白色9527"><meta name="theme-color" content="#ffffff"><meta name="msapplication-TileColor" content="#da532c"><link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" />
<link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png"><link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png"><link rel="mask-icon" href="/safari-pinned-tab.svg" color="#5bbad5"><link rel="manifest" href="/site.webmanifest"><link rel="canonical" href="https://shenbaise9527.com/" /><link rel="alternate" href="/index.xml" type="application/rss+xml" title="深白色9527">
<link rel="feed" href="/index.xml" type="application/rss+xml" title="深白色9527"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/normalize.min.css"><link rel="stylesheet" href="/css/style.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fortawesome/[email protected]/css/all.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/animate.min.css"><script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "WebSite",
"url": "https:\/\/shenbaise9527.com\/","inLanguage": "zh-CN","author": {
"@type": "Person",
"name": "深白色"
},"description": "深白色9527","image": "https:\/\/shenbaise9527.com\/images\/Apple-Devices-Preview.png","thumbnailUrl": "https:\/\/shenbaise9527.com\/images\/screenshot.png","license": "This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.","name": "深白色9527"
}
</script></head>
<body header-desktop="fixed" header-mobile="auto"><script type="text/javascript">(window.localStorage && localStorage.getItem('theme') ? localStorage.getItem('theme') === 'dark' : ('auto' === 'auto' ? window.matchMedia('(prefers-color-scheme: dark)').matches : 'auto' === 'dark')) && document.body.setAttribute('theme', 'dark');</script>
<div id="mask"></div><div class="wrapper"><header class="desktop" id="header-desktop">
<div class="header-wrapper">
<div class="header-title">
<a href="/" title="深白色9527"><span class="header-title-pre"><i class='far fa-kiss-wink-heart fa-fw'></i></span>深白色9527</a>
</div>
<div class="menu">
<div class="menu-inner"><a class="menu-item" href="/posts/"> 所有文章 </a><a class="menu-item" href="/tags/"> 标签 </a><a class="menu-item" href="/categories/"> 分类 </a><a class="menu-item" href="/about/"> 关于 </a><a class="menu-item" href="https://github.com/shenbaise9527" title="GitHub" rel="noopener noreffer" target="_blank"><i class='fab fa-github fa-fw'></i> </a><span class="menu-item delimiter"></span><span class="menu-item search" id="search-desktop">
<input type="text" placeholder="搜索文章标题或内容..." id="search-input-desktop">
<a href="javascript:void(0);" class="search-button search-toggle" id="search-toggle-desktop" title="搜索">
<i class="fas fa-search fa-fw"></i>
</a>
<a href="javascript:void(0);" class="search-button search-clear" id="search-clear-desktop" title="清空">
<i class="fas fa-times-circle fa-fw"></i>
</a>
<span class="search-button search-loading" id="search-loading-desktop">
<i class="fas fa-spinner fa-fw fa-spin"></i>
</span>
</span><a href="javascript:void(0);" class="menu-item theme-switch" title="切换主题">
<i class="fas fa-adjust fa-fw"></i>
</a>
</div>
</div>
</div>
</header><header class="mobile" id="header-mobile">
<div class="header-container">
<div class="header-wrapper">
<div class="header-title">
<a href="/" title="深白色9527"><span class="header-title-pre"><i class='far fa-kiss-wink-heart fa-fw'></i></span>深白色9527</a>
</div>
<div class="menu-toggle" id="menu-toggle-mobile">
<span></span><span></span><span></span>
</div>
</div>
<div class="menu" id="menu-mobile"><div class="search-wrapper">
<div class="search mobile" id="search-mobile">
<input type="text" placeholder="搜索文章标题或内容..." id="search-input-mobile">
<a href="javascript:void(0);" class="search-button search-toggle" id="search-toggle-mobile" title="搜索">
<i class="fas fa-search fa-fw"></i>
</a>
<a href="javascript:void(0);" class="search-button search-clear" id="search-clear-mobile" title="清空">
<i class="fas fa-times-circle fa-fw"></i>
</a>
<span class="search-button search-loading" id="search-loading-mobile">
<i class="fas fa-spinner fa-fw fa-spin"></i>
</span>
</div>
<a href="javascript:void(0);" class="search-cancel" id="search-cancel-mobile">
取消
</a>
</div><a class="menu-item" href="/posts/" title="">所有文章</a><a class="menu-item" href="/tags/" title="">标签</a><a class="menu-item" href="/categories/" title="">分类</a><a class="menu-item" href="/about/" title="">关于</a><a class="menu-item" href="https://github.com/shenbaise9527" title="GitHub" rel="noopener noreffer" target="_blank"><i class='fab fa-github fa-fw'></i></a><a href="javascript:void(0);" class="menu-item theme-switch" title="切换主题">
<i class="fas fa-adjust fa-fw"></i>
</a></div>
</div>
</header>
<div class="search-dropdown desktop">
<div id="search-dropdown-desktop"></div>
</div>
<div class="search-dropdown mobile">
<div id="search-dropdown-mobile"></div>
</div>
<main class="main">
<div class="container"><div class="page home" posts><div class="home-profile"><div class="home-avatar"><a href="/posts/" title="所有文章"><img
class="lazyload"
src="/svg/loading.min.svg"
data-src="/images/avatar.png"
data-srcset="/images/avatar.png, /images/avatar.png 1.5x, /images/avatar.png 2x"
data-sizes="auto"
alt="/images/avatar.png"
title="/images/avatar.png" /></a></div><h1 class="home-title">深白色9527</h1><h2 class="home-subtitle"><div id="id-1" class="typeit"></div></h2><div class="links"><a href="https://github.com/shenbaise9527" title="GitHub" target="_blank" rel="noopener noreffer me"><i class="fab fa-github-alt fa-fw"></i></a><a href="https://twitter.com/shenbaise9527" title="Twitter" target="_blank" rel="noopener noreffer me"><i class="fab fa-twitter fa-fw"></i></a><a href="mailto:[email protected]" title="Email" rel=" me"><i class="far fa-envelope fa-fw"></i></a><a href="/index.xml" title="RSS" target="_blank" rel="noopener noreffer me"><i class="fas fa-rss fa-fw"></i></a></div></div>
<article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2021/11/20/golang-private-mod/">Golang Private Mod</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2021-11-20">2021-11-20</time></span> <span class="post-category">收录于 <a href="/categories/golang/"><i class="far fa-folder fa-fw"></i>Golang</a></span></div><div class="content">前言 目前使用go的工程越来越多,每个工程都有很多重复的逻辑,需要把重复的进行提炼统一起来,就在bitbucket上新建了一个新的仓库fram</div><div class="post-footer">
<a href="/2021/11/20/golang-private-mod/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2021/07/24/golang-c-call/">Golang与C语言相互调用</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2021-07-24">2021-07-24</time></span> <span class="post-category">收录于 <a href="/categories/golang/"><i class="far fa-folder fa-fw"></i>Golang</a></span></div><div class="content">主要是描述Go语言调用易盛行情API的动态库过程中，一些需要注意的地方。 类型对应关系 C类型 调用方法 Go类型 字节数 char C.char byte 1 signed char C.schar int8 1 unsigned char C.uchar uint8 1</div><div class="post-footer">
<a href="/2021/07/24/golang-c-call/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a>, <a href="/tags/cgo/">cgo</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2021/07/24/golang-string/">golang字符串解析</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2021-07-24">2021-07-24</time></span> <span class="post-category">收录于 <a href="/categories/golang/"><i class="far fa-folder fa-fw"></i>Golang</a></span></div><div class="content">字符编码 计算机世界中只能识别二进制,所有的信息最终都会表示成一个二进制的字符串,每一个二进制位有0和1两种状态. 当在计算机中存储字符&rsq</div><div class="post-footer">
<a href="/2021/07/24/golang-string/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2021/01/05/raft-consensus-algorithm/">分布式一致性算法:Raft</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2021-01-05">2021-01-05</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">简介 一致性算法允许一个集群作为一个整体来工作,并允许集群中的某些节点发生故障,而不影响集群的整体运作.因此一致性算法在构建可靠的大型软件系统</div><div class="post-footer">
<a href="/2021/01/05/raft-consensus-algorithm/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/raft/">raft</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/23/etcd-operation-guide/">Etcd操作指南</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-23">2020-12-23</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">简介 etcd是强一致性的,分布式KV存储,为分布式系统或集群提供可靠的数据存储.底层基于raft共识算法,可以在网络分区情况下正常进行lea</div><div class="post-footer">
<a href="/2020/12/23/etcd-operation-guide/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a>, <a href="/tags/etcd/">etcd</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/21/etcd-application-start-warn/">服务启动时连接etcd集群的告警分析</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-21">2020-12-21</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">问题起因 通过docker-compose部署了3个节点的etcd集群,服务在启动时会随机报0个、1个或2个告警信息,信息如下: 1 2 3 4 5 6 7</div><div class="post-footer">
<a href="/2020/12/21/etcd-application-start-warn/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a>, <a href="/tags/etcd/">etcd</a>, <a href="/tags/grpc/">grpc</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/19/etcd-configure-error/">Etcd配置错误后的分析</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-19">2020-12-19</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">问题起因 在采用开源框架go-zero开发的过程中,服务在启动一段时间后控制台一直在报如下警告信息: 1 2 3 4 5 6 7 8 9 { "level": "warn", "ts": "2020-12-15T16:43:21.709+0800", "caller": "clientv3/retry_interceptor.go:62", "msg": "retrying of unary invoker</div><div class="post-footer">
<a href="/2020/12/19/etcd-configure-error/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a>, <a href="/tags/etcd/">etcd</a>, <a href="/tags/grpc/">grpc</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/17/opentracing-jaeger-action/">Jaeger实战</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-17">2020-12-17</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">部署 基于Docker 所有组件基于Docker,后端存储采用Elasticsearch.docker-compose.yml文件如下: 1 2 3 4</div><div class="post-footer">
<a href="/2020/12/17/opentracing-jaeger-action/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/opentracing/">OpenTracing</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/14/opentracing-jaeger-guide/">Jaeger指南</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-14">2020-12-14</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">系统架构 组件 jaeger即可以作为单体应用来部署(所有jaeger后台组件全部运行在一个进程内),也可以作为一个可扩展的分布式系统来部署.如</div><div class="post-footer">
<a href="/2020/12/14/opentracing-jaeger-guide/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/opentracing/">OpenTracing</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/10/opentracing-zipkin-guide/">Zipkin指南</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-10">2020-12-10</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">快速启动 可以通过http://your_host:9411去访问zipkin UI. Docker docker run -d -p 9411:9411 openzipkin/zipkin Java 需要Java8或更高版本. 1 2 curl -sSL https://zipkin.io/quickstart.sh | bash -s java -jar</div><div class="post-footer">
<a href="/2020/12/10/opentracing-zipkin-guide/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/opentracing/">OpenTracing</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/10/opentracing-best-practices/">OpenTracing最佳实践</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-10">2020-12-10</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">回顾: OpenTracing的目标是什么? OpenTracing是一个位于应用程序/库代码和追踪系统之间的一个标准中间层.结构如下: 1 2 3 4</div><div class="post-footer">
<a href="/2020/12/10/opentracing-best-practices/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/opentracing/">OpenTracing</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/12/10/opentracing-distributed/">OpenTracing分布式链路追踪</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-12-10">2020-12-10</time></span> <span class="post-category">收录于 <a href="/categories/microservice/"><i class="far fa-folder fa-fw"></i>Microservice</a></span></div><div class="content">概述 简介 虽然微服务是一种强大的系统架构,但也伴随着新的问题,就是当微服务数量众多且调用链条过长时,在复杂的网络环境下是很难调试和观察分布式事</div><div class="post-footer">
<a href="/2020/12/10/opentracing-distributed/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/opentracing/">OpenTracing</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/28/cmake-description/">CMake语法说明</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-28">2020-11-28</time></span> <span class="post-category">收录于 <a href="/categories/c++/"><i class="far fa-folder fa-fw"></i>C++</a></span></div><div class="content">预定义变量 PROJECT_SOURCE_DIR 工程的根目录 PROJECT_BINARY_DIR 运行cmake命令的目录,通常是${PROJECT_SOURCE_DIR}/build CMAKE_INCLUDE_PATH 环境变量,非CMake变量</div><div class="post-footer">
<a href="/2020/11/28/cmake-description/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/cmake/">cmake</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/28/makefile-description/">makefile语法说明</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-28">2020-11-28</time></span> <span class="post-category">收录于 <a href="/categories/c++/"><i class="far fa-folder fa-fw"></i>C++</a></span></div><div class="content">CFLAGS 表示用于C编译器的选项. 指定头文件的路径. 1 2 3 4 5 6 INCLUDES := -I./ INCLUDES += -I/usr/include INCLUDES += -I/usr/local/include INCLUDES += -I../../../3rd/curl-7.65.0/include INCLUDES += -I../../../3rd/mimetic-0.9.8/include CFLAGS := -m64 -std=c++11 -g -Wall -O3 $(INCLUDES) CXXFLAGS 表示用于C++编译器的选项,基本同C</div><div class="post-footer">
<a href="/2020/11/28/makefile-description/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/makefile/">makefile</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/24/mysql-orderby/">MySQL的orderby分析</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-24">2020-11-24</time></span> <span class="post-category">收录于 <a href="/categories/mysql/"><i class="far fa-folder fa-fw"></i>MySQL</a></span></div><div class="content">数据准备 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 /*mysql版本*/Serverversion:5.7.27-logMy</div><div class="post-footer">
<a href="/2020/11/24/mysql-orderby/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/mysql/">mysql</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/24/mysql-lock/">MySQL锁机制分析</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-24">2020-11-24</time></span> <span class="post-category">收录于 <a href="/categories/mysql/"><i class="far fa-folder fa-fw"></i>MySQL</a></span></div><div class="content">全局锁 全局锁就是对整个数据库实例加锁.MySQL提供了命令Flush tables with read lock(FTWRL),可使整库处于只读状态,其它线程的数据更新语</div><div class="post-footer">
<a href="/2020/11/24/mysql-lock/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/mysql/">mysql</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/24/mysql-join/">MySQL的join分析</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-24">2020-11-24</time></span> <span class="post-category">收录于 <a href="/categories/mysql/"><i class="far fa-folder fa-fw"></i>MySQL</a></span></div><div class="content">问题 使用join时驱动表、被驱动表是如何选择的?影响因素有哪些? 如何优化? 数据准备 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29</div><div class="post-footer">
<a href="/2020/11/24/mysql-join/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/mysql/">mysql</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/24/mysql-index/">MySQL索引(InnoDB引擎)</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-24">2020-11-24</time></span> <span class="post-category">收录于 <a href="/categories/mysql/"><i class="far fa-folder fa-fw"></i>MySQL</a></span></div><div class="content">B+树 基于N叉树(每个父节点有N个子节点,子节点的值从左到右按照从小到大的顺序排列),非叶子节点只存储索引值,叶子节点储存索引值和数据,所有</div><div class="post-footer">
<a href="/2020/11/24/mysql-index/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/mysql/">mysql</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/22/golang-data-type/">golang数据类型</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-22">2020-11-22</time></span> <span class="post-category">收录于 <a href="/categories/golang/"><i class="far fa-folder fa-fw"></i>Golang</a></span></div><div class="content">主要包含基本的内建类型(布尔类型、数值类型和字符串类型)和复合类型(array、slice、map、channel、function、str</div><div class="post-footer">
<a href="/2020/11/22/golang-data-type/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/go/">go</a></div></div>
</article><article class="single summary" itemscope itemtype="http://schema.org/Article"><h1 class="single-title" itemprop="name headline">
<a href="/2020/11/09/mysql-gtid/">MySQL基于GTID复制</a>
</h1><div class="post-meta"><span class="post-author"><a href="https://shenbaise9527.com" title="Author" target="_blank" rel="noopener noreffer author" class="author"><i class="fas fa-user-circle fa-fw"></i>深白色</a></span> <span class="post-publish">发布于 <time datetime="2020-11-09">2020-11-09</time></span> <span class="post-category">收录于 <a href="/categories/mysql/"><i class="far fa-folder fa-fw"></i>MySQL</a></span></div><div class="content">开启GTID. 1 2 3 4 5 6 7 8 9 10 11 12 # 启用gtid模式,每个事务有个唯一的id,全局事务ID,事务提交时分配,基于gtid来复制. gtid_mode=ON # 开启</div><div class="post-footer">
<a href="/2020/11/09/mysql-gtid/">阅读全文</a><div class="post-tags">
<i class="fas fa-tags fa-fw"></i> <a href="/tags/mysql/">mysql</a></div></div>
</article><ul class="pagination"><li class="page-item active">
<span class="page-link">
<a href="/">1</a>
</span>
</li><li class="page-item ">
<span class="page-link">
<a href="/page/2/">2</a>
</span>
</li></ul></div></div>
</main><footer class="footer">
<div class="footer-container"><div class="footer-line">由 <a href="https://gohugo.io/" target="_blank" rel="noopener noreffer" title="Hugo 0.90.0-DEV">Hugo</a> 强力驱动 | 主题 - <a href="https://github.com/dillonzq/LoveIt" target="_blank" rel="noopener noreffer" title="LoveIt 0.2.10"><i class="far fa-kiss-wink-heart fa-fw"></i> LoveIt</a>
</div><div class="footer-line"><i class="far fa-copyright fa-fw"></i><span itemprop="copyrightYear">2020 - 2021</span><span class="author" itemprop="copyrightHolder"> <a href="https://shenbaise9527.com" target="_blank">深白色</a></span> | <span class="license"><a rel="license external nofollow noopener noreffer" href="https://creativecommons.org/licenses/by-nc/4.0/" target="_blank">CC BY-NC 4.0</a></span></div>
</div>
</footer></div>
<div id="fixed-buttons"><a href="#" id="back-to-top" class="fixed-button" title="回到顶部">
<i class="fas fa-arrow-up fa-fw"></i>
</a><a href="#" id="view-comments" class="fixed-button" title="查看评论">
<i class="fas fa-comment fa-fw"></i>
</a>
</div><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/dist/smooth-scroll.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/dist/autocomplete.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/dist/algoliasearch-lite.umd.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/lazysizes.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/dist/clipboard.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/sharer.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/[email protected]/dist/typeit.min.js"></script><script type="text/javascript">window.config={"code":{"copyTitle":"复制到剪贴板","maxShownLines":100},"data":{"id-1":"Pain is inevitable,Suffering is optional"},"search":{"algoliaAppID":"PASDMWALPK","algoliaIndex":"index.zh-cn","algoliaSearchKey":"b42948e51daaa93df92381c8e2ac0f93","highlightTag":"em","maxResultLength":10,"noResultsFound":"没有找到结果","snippetLength":50,"type":"algolia"},"typeit":{"cursorChar":"|","cursorSpeed":1000,"data":{"id-1":["id-1"]},"duration":-1,"speed":100}};</script><script type="text/javascript" src="/js/theme.min.js"></script><script type="text/javascript">
window.dataLayer=window.dataLayer||[];function gtag(){dataLayer.push(arguments);}gtag('js', new Date());
gtag('config', 'G-R1HW7DNZ94', { 'anonymize_ip': true });
</script><script type="text/javascript" src="https://www.googletagmanager.com/gtag/js?id=G-R1HW7DNZ94" async></script></body>
</html>