<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[grantv5的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/grantv5</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; grantv5]]></copyright><item><title><![CDATA[Linux白屏部署OceanBase集群版]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/138388351</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/138388351</guid><author>grantv5</author><pubDate>Thu, 02 May 2024 10:39:47 +0800</pubDate><description><![CDATA[预检查遇到报错，按照提示做相应的修改。返回上一步，继续预检查，如此反复检查，调整，直至检查没有错误提示。本次将部署三个节点，将介质OceanBase All in One传到一个节点上即可。#预检查各个节点的服务器资源配置是否满足OB集群部署需求。#设置密码，也可使用默认密码。后面可通过OCP Web管理集群。#选择OceanBase及配套工具。#记住连接信息及账号密码。#可以直接使用默认配置。]]></description><category></category></item><item><title><![CDATA[OceanBase单机版重新部署提示[ERROR] Deploy “demo“ is running. You could not deploy an running cluster.]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/138383489</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/138383489</guid><author>grantv5</author><pubDate>Thu, 02 May 2024 00:27:47 +0800</pubDate><description><![CDATA[这是由于Demo还在运行，并没有被删除。因此只需要将其删除干净，即可重新安装部署。]]></description><category></category></item><item><title><![CDATA[Linux如何完全卸载OceanBase单机版]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/138383374</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/138383374</guid><author>grantv5</author><pubDate>Thu, 02 May 2024 00:22:24 +0800</pubDate><description><![CDATA[4. 删除OB部署介质及环境变量。1. 查看OB集群信息。2. 停止demo库。]]></description><category></category></item><item><title><![CDATA[Linux上OcenBase单机版部署及基本信息查询]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/138382539</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/138382539</guid><author>grantv5</author><pubDate>Wed, 01 May 2024 23:47:55 +0800</pubDate><description><![CDATA[OceanBase单机版部署可以通过在线和离线两种方式部署。在线部署可以通过yum源或者apt源部署，直接拉取官方源码即可。实际使用中，大部分环境连不了外网，本文介绍离线方式安装。4. 查询数据库版本、字符集等基本信息。2. 一键部署并添加到系统环境变量。]]></description><category></category></item><item><title><![CDATA[Linux服务器安装GaussDB 100及安装过程中常见问题解决]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/108756735</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/108756735</guid><author>grantv5</author><pubDate>Wed, 23 Sep 2020 16:58:16 +0800</pubDate><description><![CDATA[******************************** Gaussdb100安装 ********************************

1. 创建安装包目录

　　mkdir -p /opt/gaussdb100

2. 上传安装包到服务器（本地是windows系统）

　　rz

　　

3. 解压安装包

　　/opt/gaussdb100

　　tar -xvf GaussDB_100_1.0.1-DATABASE-CENTOS-64bit.tar.gz

4.创建用户、...]]></description><category></category></item><item><title><![CDATA[DB2查找最耗时SQL]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/108638961</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/108638961</guid><author>grantv5</author><pubDate>Thu, 17 Sep 2020 12:04:15 +0800</pubDate><description><![CDATA[两种方法：db2top和snapshot for dynamic sql

1. db2top -d &lt;dbname&gt;



按D，进入动态SQL监控

按z，倒序排序，然后输入需倒序排序的是第几列（序号是从0开始）



按L，输入SQL的序列号，查看SQL明细



2. db2 get snapshot for dynamic sql on &lt;dbname&gt;

db2 get snapshot for dynamic sql on db2test &gt; dynamicsql]]></description><category></category></item><item><title><![CDATA[DB2 High CPU Usage]]></title><link>https://blog.youkuaiyun.com/grantv5/article/details/108618233</link><guid>https://blog.youkuaiyun.com/grantv5/article/details/108618233</guid><author>grantv5</author><pubDate>Wed, 16 Sep 2020 13:11:57 +0800</pubDate><description><![CDATA[前提：

实例级快照开关都打开：



思路：

1. 判断CPU使用率高的进程是否是DB2进程

vmstat1 5 #关注sy，us列用量是否高

iostat #关注%user列是否高

ps-elf | sort -k 5 -rn | more #根据memory用量排序

2. 找到占用高CPU时间的DB2代理进程/线程

db2pd -edus -interval=3 #查看USR列高的向，记下EDU ID

db2pd -eve &gt; db2pd_eve.out #结合上面EDU I...]]></description><category></category></item></channel></rss>