<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[MasterLeon的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/MasterLeon</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; MasterLeon]]></copyright><item><title><![CDATA[emonitor]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/160958869</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/160958869</guid><author>MasterLeon</author><pubDate>Sun, 10 May 2026 17:59:06 +0800</pubDate><description><![CDATA[│  │ EBase DB    │  │ 系统命令     │  │ 日志文件     │              │。│  │ 性能监控     │  │ 告警管理     │  │ 诊断引擎     │  │ 系统检查 │ │。│ 数据源      │───▶│ 数据处理     │───▶│ WebSocket   │。- 网络I/O (network_rx_bytes, network_tx_bytes)│ 系统指标     │───▶│ 数据采集     │───▶│ 数据处理     │。]]></description><category></category></item><item><title><![CDATA[VSCode生产工具详细配置]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/127940385</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/127940385</guid><author>MasterLeon</author><pubDate>Sat, 19 Nov 2022 19:04:56 +0800</pubDate><description><![CDATA[VSCode生产工具详细配置]]></description><category></category></item><item><title><![CDATA[gpMgmt如何新增python依赖库]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/123239212</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/123239212</guid><author>MasterLeon</author><pubDate>Wed, 02 Mar 2022 20:18:01 +0800</pubDate><description><![CDATA[gpMgmt如何新增python依赖库
背景
如果新增1个管理工具实现某些功能，如gpload_xxxx，该新增工具依赖第三方python依赖库ruamel.yaml、ptyprocess、pycrypto （而GP源码中没有包含这些依赖库），该如何解决
解决方案
1、首先，下载python第三方依赖库
https://pypi.org/project/ruamel.yaml/0.16.13/
https://pypi.org/project/ptyprocess/0.6.0/
https://pypi.o]]></description><category></category></item><item><title><![CDATA[bin.gppylib.mainUtils]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/123238881</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/123238881</guid><author>MasterLeon</author><pubDate>Wed, 02 Mar 2022 20:06:32 +0800</pubDate><description><![CDATA[bin.gppylib.mainUtils
mainUtils.py文件提供了一个基本框架来支持gp实用程序的顶级选项解析、初始化和清理逻辑。
主要的接口函数是simple_main。请参阅 gprecoverseg。
随着gp实用程序的常用功能不断扩展，该文件的功能也会增长。请记住这一点，并尽量避免在此处放置特定实用程序的逻辑。
导包
import errno, os, sys, shutil

gProgramName = os.path.split(sys.argv[0])[-1]
if sys.ve]]></description><category></category></item><item><title><![CDATA[重命名文件]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/110841996</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/110841996</guid><author>MasterLeon</author><pubDate>Mon, 07 Dec 2020 21:16:31 +0800</pubDate><description><![CDATA[#!/usr/bin/env python
"""
#!/usr/bin/env python
"""
@Filename: rename_file_by_sort.py
"""
import os
import sys
import getopt

def main(argv):
    config_file = ""
    try:
        opts, args = getopt.getopt(sys.argv[1:], 'f:', ['file='])
    except getopt.]]></description><category></category></item><item><title><![CDATA[Greenplum的Hash Join]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/106002754</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/106002754</guid><author>MasterLeon</author><pubDate>Fri, 08 May 2020 17:57:15 +0800</pubDate><description><![CDATA[Greenplum的Hash Join
在介绍HashJoin实现之前，首先了解下什么是 JOIN。根据维基百科（WIKIPedia），JOIN是关系数据库中组合一个或者多个表中的columns的算子。

而JOIN 有多种类型， SQL 标准中定义了 INNER JOIN、LEFT JOIN、RIGHT JOIN、FULL OUTER JOIN 等四种类型，用集合论里的操作非常容易理解。 我们在下图直观的解释了这四种JOIN类型的效用。
此外还有其中JOIN类型，譬如 SEMI JOIN和 ANTI JO]]></description><category></category></item><item><title><![CDATA[Greenplum数据分布和分区]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/105945175</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/105945175</guid><author>MasterLeon</author><pubDate>Wed, 06 May 2020 10:48:48 +0800</pubDate><description><![CDATA[Greenplum数据分布和分区数据分布分区策略
数据分布
https://yq.aliyun.com/articles/57822
https://segmentfault.com/a/1190000022005788
http://www.dbdream.com.cn/2016/01/greenplum%E6%95%B0%E6%8D%AE%E5%BA%93%E5%88%9B%E5%BB%BA%...]]></description><category></category></item><item><title><![CDATA[Greenplum常用SQL总结]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/105864849</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/105864849</guid><author>MasterLeon</author><pubDate>Thu, 30 Apr 2020 16:42:29 +0800</pubDate><description><![CDATA[Greenplum常用SQL总结查看各个节点数据的分布
查看各个节点数据的分布
SELECT gp_segment_id,count(*) FROM table_name GROUP BY gp_segment_id;


]]></description><category></category></item><item><title><![CDATA[《GPDB学习笔记》GPCC安装笔记]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/105007840</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/105007840</guid><author>MasterLeon</author><pubDate>Sat, 21 Mar 2020 12:40:52 +0800</pubDate><description><![CDATA[部署GP集群
postgres=# select * from gp_segment_configuration order by 1;
 dbid | content | role | preferred_role | mode | status | port  | hostname | address |                  datadir
------+---------+--...]]></description><category></category></item><item><title><![CDATA[Greenplum去除表中重复项]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/104636755</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/104636755</guid><author>MasterLeon</author><pubDate>Tue, 03 Mar 2020 17:20:10 +0800</pubDate><description><![CDATA[AO表无法创建主键约束避免重复数据，GP6官方手册描述如下：

由于无法轻易识别源数据的重复项，可以通过加载完所有内容，然后利用唯一标识行的primary key id删除重复项的方式，来去除AO表中的重复项。
数据表分布在不同的节点上，每个节点的ctid是唯一的，但是不同的节点就有ctid重复的可能，因此GP必须借助gp_segment_id来进行去重复处理。
SQL1：不适用于同一条记录的重复...]]></description><category></category></item><item><title><![CDATA[《GPDB学习笔记》版本升级]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/103634664</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/103634664</guid><author>MasterLeon</author><pubDate>Fri, 20 Dec 2019 16:39:08 +0800</pubDate><description><![CDATA[小版本手动升级与回退（6.0.0 &lt;==&gt; 6.1.0）
小版本升级
准备6.0和6.1版本包，如下：
[gpadmin@cgsl51 ~]$ ll
total 198512
drwxrwxr-x 2 gpadmin gpadmin      4096 12月 20 15:26 gpAdminLogs
drwxrwxr-x 2 gpadmin gpadmin       100 12月...]]></description><category></category></item><item><title><![CDATA[《GPDB学习笔记》资源管理]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/103617968</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/103617968</guid><author>MasterLeon</author><pubDate>Thu, 19 Dec 2019 17:14:16 +0800</pubDate><description><![CDATA[resource group
资源组（resource group）是资源队列（resource queue）的新设计和重写。
使用
创建Greenplum数据库cgroups配置文件/etc/cgconfig.d/gpdb.conf。用户必须是超级用户或具有sudo访问权限才能创建此文件：
sudo vi /etc/cgconfig.d/gpdb.conf

group gpdb {
     ...]]></description><category></category></item><item><title><![CDATA[《GPDB学习笔记》Greenplum6.1.0编译]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/103234855</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/103234855</guid><author>MasterLeon</author><pubDate>Mon, 25 Nov 2019 11:33:08 +0800</pubDate><description><![CDATA[ORCA优化器编译及安装
cmake
https://github.com/Kitware/CMake/releases?after=v3.9.3

su - greenplum
tar -zvxf cmake-3.8.2.tar.gz

cd cmake-3.8.2
./configure --prefix=/home/greenplum/cmake
make
make install

vi ...]]></description><category></category></item><item><title><![CDATA[expect脚本交互返回退出码]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/102572483</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/102572483</guid><author>MasterLeon</author><pubDate>Tue, 15 Oct 2019 18:46:40 +0800</pubDate><description><![CDATA[#/bin/bash
expect 2&gt;&amp;1 &lt;&lt;'END_OF_EXPECT'
spawn ssh -o NumberOfPasswordPrompts=1 10.46.178.51 -T "sudo sh /tmp/install_command.sh"
set timeout 180
expect {
    "yes/no" { send "yes\r"; exp...]]></description><category></category></item><item><title><![CDATA[linux磁盘开机挂载]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/102518642</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/102518642</guid><author>MasterLeon</author><pubDate>Sat, 12 Oct 2019 13:18:54 +0800</pubDate><description><![CDATA[查询磁盘UUID
[root@cgsl57 ~]# blkid /dev/sdd | awk '{for(col=1;col&lt;=NF;col+=1){if($col ~ /UUID/){print $col}}}'
UUID="83015a5d-43ca-4c82-abdf-29430905f5ee"


]]></description><category></category></item><item><title><![CDATA[python字符串Unicode和String互相转换]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/102496695</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/102496695</guid><author>MasterLeon</author><pubDate>Fri, 11 Oct 2019 10:40:15 +0800</pubDate><description><![CDATA[问题一：
将u'\u810f\u4e71'转换为'\u810f\u4e71'
 
方法：
s_unicode = u'\u810f\u4e71'
s_str = s_unicode.encode('unicode-escape').decode('string_escape')
 
问题二：
将'\u810f\u4e71'转换为u'\u810f\u4e71'
方法：s_str = '\u810f\...]]></description><category></category></item><item><title><![CDATA[《Postgresql学习笔记》之查询处理]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/101755126</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/101755126</guid><author>MasterLeon</author><pubDate>Mon, 30 Sep 2019 10:11:32 +0800</pubDate><description><![CDATA[查询处理概要Parser
本章概述了查询处理，尤其是查询优化。
本章包括以下三个部分：

3.1节概述Postgresql中的查询处理
本部分解释了获得单表查询的最优计划所遵循的步骤。在3.2和3.3节中，分别解释了估算成本和创建计划树的过程。3.4节简要描述了执行操作
本部分阐述了多表查询的最优方案的获取过程。在3.5节中，描述了3种连接方法：嵌套循环、合并和散列连接。在3.6节中，解释了创建多...]]></description><category></category></item><item><title><![CDATA[《Postgresql学习笔记》——数据库集群、数据库和表]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/101699444</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/101699444</guid><author>MasterLeon</author><pubDate>Sun, 29 Sep 2019 16:37:33 +0800</pubDate><description><![CDATA[1.1 数据库集群的逻辑结构
1.2 物理结构

]]></description><category></category></item><item><title><![CDATA[Postgresql TOAST]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/100741940</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/100741940</guid><author>MasterLeon</author><pubDate>Wed, 11 Sep 2019 17:24:36 +0800</pubDate><description><![CDATA[Postgresql TOAST
TOAST (The Oversized-Attribute Storage Technique，)超大尺寸字段存储技术）主要用于存储大字段的值。
PostgreSQL 页面（page）大小是固定的（通常为8KB），且不允许tuples跨多个页面存储。因此不能存储非常大的字段值。为了克服这个限制，大字段值通常被压缩甚至切片成多个物理行存储到TOSAT表，这就是TO...]]></description><category></category></item><item><title><![CDATA[Postgresql安装]]></title><link>https://blog.youkuaiyun.com/MasterLeon/article/details/100739091</link><guid>https://blog.youkuaiyun.com/MasterLeon/article/details/100739091</guid><author>MasterLeon</author><pubDate>Wed, 11 Sep 2019 15:55:21 +0800</pubDate><description><![CDATA[Postgresql安装
解压安装包
[root@dhss206 ~]# useradd liyang
[root@dhss206 ~]# chown -R liyang. /home/liyang/rdbpg64_linux.Z
[root@dhss206 ~]# su - liyang
[liyang@dhss206 ~]$ chmod 744 rdbpg64_linux.Z
[liyang@...]]></description><category></category></item></channel></rss>