<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lycdf的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lycdf</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lycdf]]></copyright><item><title><![CDATA[linux常见性能监控工具]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/141037357</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/141037357</guid><author>lycdf</author><pubDate>Thu, 08 Aug 2024 22:07:41 +0800</pubDate><description><![CDATA[性能监控常用命令]]></description><category></category></item><item><title><![CDATA[7 postgresql 10版本 分区表使用场景、创建删除、注意事项]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140939264</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140939264</guid><author>lycdf</author><pubDate>Mon, 05 Aug 2024 23:08:25 +0800</pubDate><description><![CDATA[分区表注意事项]]></description><category></category></item><item><title><![CDATA[6 postgresql事务与并发控制]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140859337</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140859337</guid><author>lycdf</author><pubDate>Thu, 01 Aug 2024 22:46:54 +0800</pubDate><description><![CDATA[pg表膨胀原理]]></description><category></category></item><item><title><![CDATA[5 postgresql 并行查询]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140859316</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140859316</guid><author>lycdf</author><pubDate>Thu, 01 Aug 2024 22:44:54 +0800</pubDate><description><![CDATA[max_parallel_workers_per_gather的值设置为机器内核数据比较妥当，设置再多，查询效率没有明显提高。max_parallel_workers_per_gather：允许启用并行进程的进程数，默认为2，0表示禁用并行。min_parallel_table_scan_size：表大小小于这个值时，不会开启并行（8Mb）min_parallel_index_scan_size:并行索引扫描，只会扫描索引数据块。max_parallel_workers：系统支持的并行查询进程数默认为8。]]></description><category></category></item><item><title><![CDATA[4、postgresql拓展表空间]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140832740</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140832740</guid><author>lycdf</author><pubDate>Wed, 31 Jul 2024 21:43:19 +0800</pubDate><description><![CDATA[表空间：pg最大的逻辑存储单元，表索引数据库都分配到对应表空间，创建数据库时会默认创建表空间，pg_default和pg_global两个表空间。数据库的oid在pg_database中，表，索引，序列等OID存储在pg_class中。数据块在磁盘中叫page[读写的最小单位默认大小8kb],在内存中叫buffer。还可以自定义表空间，分配在不同性能的磁盘上。OID：对象标识符，无符号4字节整数，表和索引叫relation。base是数据保存目录，在新的表空间上创建表。]]></description><category></category></item><item><title><![CDATA[docker安装过程中出现的问题]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140819402</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140819402</guid><author>lycdf</author><pubDate>Wed, 31 Jul 2024 12:11:35 +0800</pubDate><description><![CDATA[重启失败，原因在处理/etc/docker/daemon.json的时候没有缩进，重新配置缩进之后，重启成功。]]></description><category></category></item><item><title><![CDATA[01.docker安装、配置、常用命令、dockerfile、镜像上传下载和Harbor仓库搭建]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140819226</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140819226</guid><author>lycdf</author><pubDate>Wed, 31 Jul 2024 12:08:15 +0800</pubDate><description><![CDATA[如果想使用/etc/docker/daemon.json管理docker daemon，默认情况下，/etc/docker目录中并没有daemon.json。在Dockerfile定义所要执行的命令，使用docker build创建镜像，过程中会按照Dockerfile所定义的内容打开临时性容。Docker 的容器镜像和容器本身的数据都存放在服务器的 /var/lib/docker/ 这个路径下。从图中可以看出除了最上面的一层为读写层之外，下面的其他的层都是只读的镜像层，并且除了最下面的一层外，其。]]></description><category></category></item><item><title><![CDATA[3、postgresql中递归\CTE\WITH\INSERT\COPY]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140810294</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140810294</guid><author>lycdf</author><pubDate>Wed, 31 Jul 2024 00:49:50 +0800</pubDate><description><![CDATA[postgresql中递归、with、insert、copy常见使用方法和分析]]></description><category></category></item><item><title><![CDATA[pg之pgsql导入sql文件]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140783734</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140783734</guid><author>lycdf</author><pubDate>Mon, 29 Jul 2024 23:31:44 +0800</pubDate><description><![CDATA[导入数据（也可以指定库，用户），加上参数q之后可以不在显示具体信息。pg之pgsql导入sql文件。]]></description><category></category></item><item><title><![CDATA[2、postgresql运行架构]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140754659</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140754659</guid><author>lycdf</author><pubDate>Sun, 28 Jul 2024 19:02:27 +0800</pubDate><description><![CDATA[WAL记录了数据库的所有更改，使得在系统崩溃后可以从日志中恢复数据。WAL Writer进程（通常称为bgwriter，即后台写入器）是负责将这些事务日志写入磁盘的后台进程。先写日志后写库，如果崩溃了，可以通过该日志恢复数据，减小了磁盘读写次数，为啥？pg后端进程：由pg服务器启动，通过单个TCP和数据库连接，多个客户端连接时，设置max_connections可以控制客户端连接数量。：在重启数据库之前,可以执行这个命令，加快后续数据库的恢复。检查点进程，主要是缩短数据库实例恢复的时间。]]></description><category></category></item><item><title><![CDATA[1、postgresql的基础安装与部署]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140747240</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140747240</guid><author>lycdf</author><pubDate>Sun, 28 Jul 2024 10:18:19 +0800</pubDate><description><![CDATA[postgresql安装部署]]></description><category></category></item><item><title><![CDATA[git版本升级]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140368395</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140368395</guid><author>lycdf</author><pubDate>Fri, 12 Jul 2024 08:24:33 +0800</pubDate><description><![CDATA[git版本升级]]></description><category></category></item><item><title><![CDATA[vmware虚拟机局域网内访问互通]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/140364824</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/140364824</guid><author>lycdf</author><pubDate>Thu, 11 Jul 2024 23:53:58 +0800</pubDate><description><![CDATA[有两台电脑，平时使用win工具远程连接起来的，实际使用也只是使用xshell,不如直接互同，通过xshell连接。]]></description><category></category></item><item><title><![CDATA[公有云知识问答]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/137060816</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/137060816</guid><author>lycdf</author><pubDate>Tue, 26 Mar 2024 23:00:06 +0800</pubDate><description><![CDATA[一般是数据库跨区部署，服务备区少量资源备份。应用层面怎么做高可用，数据层面怎么做高可用。了解下云上高可用方案，同城双活，异地双活。计算网络存储知道基础知识就好。高可用，从服务和数据层面讲。]]></description><category></category></item><item><title><![CDATA[前端不使用async下载数据]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/135246622</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/135246622</guid><author>lycdf</author><pubDate>Wed, 27 Dec 2023 15:06:14 +0800</pubDate><description><![CDATA[/ 这里你可以添加一些错误处理代码，比如设置一个 state 来展示错误信息。console.error(‘发生错误:’, error);throw new Error(“网络请求失败”);]]></description><category></category></item><item><title><![CDATA[七牛云+picgo+typora，typora图片不显示问题]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/125172307</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/125172307</guid><author>lycdf</author><pubDate>Tue, 07 Jun 2022 20:07:29 +0800</pubDate><description><![CDATA[七牛云+picgo+typora，typora图片不显示问题]]></description><category></category></item><item><title><![CDATA[centos小记]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/81837350</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/81837350</guid><author>lycdf</author><pubDate>Sun, 19 Aug 2018 13:31:57 +0800</pubDate><description><![CDATA[interface eth0
static ip_address=192.168.1.12/24
static routers=192.168.1.1
static domain_name_servers=192.168.1.1 8.8.8.8

interface wlan0
static ip_address=192.168.1.13/24

raspberry

设置开机自启动ssh
sud...]]></description><category></category></item><item><title><![CDATA[Ubuntu下Hadoop的安装与使用]]></title><link>https://blog.youkuaiyun.com/lycdf/article/details/80092842</link><guid>https://blog.youkuaiyun.com/lycdf/article/details/80092842</guid><author>lycdf</author><pubDate>Thu, 26 Apr 2018 13:53:23 +0800</pubDate><description><![CDATA[1、创建hadoop用户打开终端sudo useradd -m hadoop -s /bin/bashsudo passwd hadoop//为hadoop设置密码sudo adduser hadoop sudo//为 hadoop 用户增加管理员权限2、更新apt并安装vimsudo apt-get update3、安装SSH、配置SSH无密码登陆集群、单节点模式都需要用到 SSH 登陆，Ubu...]]></description><category></category></item></channel></rss>