<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Xiaoyi_CES的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Xiaoyi_CES</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Xiaoyi_CES]]></copyright><item><title><![CDATA[postgresql运维问题解决：PG集群主节点发生脑裂处理办法]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150496489</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150496489</guid><author>Xiaoyi_CES</author><pubDate>Tue, 19 Aug 2025 09:30:00 +0800</pubDate><description><![CDATA[数据库集群出现脑裂问题，排查因corosync进程异常导致VIP资源冲突。通过强制重启故障节点或云平台虚拟机重启，并重建异常备库后问题解决。]]></description><category></category></item><item><title><![CDATA[postgresql运维问题解决：PG集群备节点状态异常告警处理]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150351859</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150351859</guid><author>Xiaoyi_CES</author><pubDate>Thu, 14 Aug 2025 09:30:00 +0800</pubDate><description><![CDATA[PostgreSQL集群备节点状态异常，排查因心跳超时导致节点状态为stop/alone。通过集群状态检查与恢复命令resourcecleanup或深度日志分析/重构备节点解决。]]></description><category></category></item><item><title><![CDATA[postgresql运维问题解决：PG数据库状态会话过多处理]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150214449</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150214449</guid><author>Xiaoyi_CES</author><pubDate>Tue, 12 Aug 2025 09:30:00 +0800</pubDate><description><![CDATA[PostgreSQL数据库出现资源告警问题，排查因idle/idle in transaction会话堆积。通过SQL筛选非活跃会话并终止相关进程后问题解决。]]></description><category></category></item><item><title><![CDATA[postgresql运维问题解决：PG集群无主节点恢复指南]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150002225</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/150002225</guid><author>Xiaoyi_CES</author><pubDate>Thu, 07 Aug 2025 13:19:49 +0800</pubDate><description><![CDATA[pg数据库集群定位系统故障困难，排查因缺乏标准化操作指南。通过实施系统日志收集与CPU/IO资源监控解决。]]></description><category></category></item><item><title><![CDATA[Linux应急手册第四期]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149906117</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149906117</guid><author>Xiaoyi_CES</author><pubDate>Tue, 05 Aug 2025 09:23:44 +0800</pubDate><description><![CDATA[十年深耕运维行业，小亦知识库Linux应急手册为运维人员定位系统故障，排查故障原因提供标准化操作指南。]]></description><category></category></item><item><title><![CDATA[Linux应急手册第三期]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149768738</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149768738</guid><author>Xiaoyi_CES</author><pubDate>Thu, 31 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[二十年深耕运维行业，小亦知识库Linux应急手册为运维人员定位系统故障，排查故障原因提供标准化操作指南。]]></description><category></category></item><item><title><![CDATA[Linux应急手册第二期]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149708564</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149708564</guid><author>Xiaoyi_CES</author><pubDate>Tue, 29 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[二十年深耕运维行业，小亦知识库Linux应急手册为运维人员定位系统故障，排查故障原因提供标准化操作指南。]]></description><category></category></item><item><title><![CDATA[Linux应急手册第一期]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149577432</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149577432</guid><author>Xiaoyi_CES</author><pubDate>Thu, 24 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[二十年深耕运维行业，小亦知识库Linux应急手册为运维人员定位系统故障，排查故障原因提供标准化操作指南。]]></description><category></category></item><item><title><![CDATA[mysql运维问题解决：MySQL主从延迟（无主键表）]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149506890</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149506890</guid><author>Xiaoyi_CES</author><pubDate>Tue, 22 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[MySQL主从复制出现延迟问题，排查因无主键表导致全表扫描及大事务操作影响。通过重建延迟节点、添加缺失主键并拆分大事务后问题解决。]]></description><category></category></item><item><title><![CDATA[mysql运维问题解决：MySQL主从延迟(锁阻塞与读写分离)]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149387972</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149387972</guid><author>Xiaoyi_CES</author><pubDate>Thu, 17 Jul 2025 12:06:38 +0800</pubDate><description><![CDATA[数据库从库出现主从延迟告警，排查因从库查询锁阻塞复制线程。通过收集线程信息、优化慢SQL及分散跑批任务负载后问题解决。]]></description><category></category></item><item><title><![CDATA[mysql运维问题解决：MySQL参数配置与部署环境优化]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149324000</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149324000</guid><author>Xiaoyi_CES</author><pubDate>Tue, 15 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[关键参数配置不当、MySQL数据存储于NFS性能隐患及资源竞争导致工单系统访问异常。
通过修改参数至安全值、迁移MySQL至本地SSD磁盘并部署独立服务器解决。]]></description><category></category></item><item><title><![CDATA[mysql运维问题解决：数仓mysql异常重启]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149226131</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149226131</guid><author>Xiaoyi_CES</author><pubDate>Thu, 10 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[MySQL主节点异常重启，排查后通过升级版本、调整系统资源限制与参数优化及修复表文件后问题解决。]]></description><category></category></item><item><title><![CDATA[Oracle应急处理：ORACLE XA 交易挂起]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149173148</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149173148</guid><author>Xiaoyi_CES</author><pubDate>Tue, 08 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[Oracle数据库出现XA交易挂起问题，排查因两阶段提交协调器故障导致交易滞留PREPARE状态。通过CICS端PURGE交易或数据库端强制提交/回滚后清理残留记录解决。]]></description><category></category></item><item><title><![CDATA[Oracle应急处理：Oracle 内存泄漏但系统可telnet登陆]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149063840</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149063840</guid><author>Xiaoyi_CES</author><pubDate>Thu, 03 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[Oracle数据库出现内存泄漏问题，排查因PGA/SGA泄漏导致内存换页异常。通过收集进程信息或查询内存占用SQL后，采取终止进程或重启实例解决。]]></description><category></category></item><item><title><![CDATA[Oracle应急处理：Oracle RAC 集群节点进程通信出现报错]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149027682</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/149027682</guid><author>Xiaoyi_CES</author><pubDate>Tue, 01 Jul 2025 09:30:00 +0800</pubDate><description><![CDATA[Oracle RAC集群出现IPCSENDTimeout错误，排查因节点间IPC通信故障。通过检查资源状态、重启节点服务及收集诊断信息后问题解决。]]></description><category></category></item><item><title><![CDATA[Oracle应急处理：IO等待严重，数据库业务响应慢]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148893942</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148893942</guid><author>Xiaoyi_CES</author><pubDate>Thu, 26 Jun 2025 09:30:00 +0800</pubDate><description><![CDATA[Oracle数据库业务响应缓慢，排查因高IO负载导致系统延迟。通过iostat、AWR/ASH报告定位高IO会话后终止问题会话解决。]]></description><category></category></item><item><title><![CDATA[GaussDB 运维问题解决：Broken pipe连接中断]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148850137</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148850137</guid><author>Xiaoyi_CES</author><pubDate>Tue, 24 Jun 2025 09:30:00 +0800</pubDate><description><![CDATA[GaussDB数据库使用gs_dump出现Broken pipe连接中断，排查因事务空闲超时。调整参数idle_in_transaction_timeout并通过gs_gucreload生效后问题解决。]]></description><category></category></item><item><title><![CDATA[GaussDB 运维问题解决：Ustore 并发更新报错]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148733118</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148733118</guid><author>Xiaoyi_CES</author><pubDate>Thu, 19 Jun 2025 09:30:00 +0800</pubDate><description><![CDATA[GaussDB 5.0.3 Ustore引擎高并发UPDATE报错，因BEFORE UPDATE触发器限制。通过删除触发器迁移逻辑至应用代码、改用astore存储模式（官方推荐Ustore）后问题解决]]></description><category></category></item><item><title><![CDATA[GaussDB运维问题解决：高并发下内存不足]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148690330</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148690330</guid><author>Xiaoyi_CES</author><pubDate>Tue, 17 Jun 2025 09:30:00 +0800</pubDate><description><![CDATA[GaussDB数据库高并发下内存不足，排查因max_dynamic_memory动态内存溢出。通过扩容硬件至32C128G并优化max_process_memory参数后问题解决。]]></description><category></category></item><item><title><![CDATA[GaussDB运维问题解决：服务器扩容后监控与调度决策错误]]></title><link>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148564320</link><guid>https://blog.youkuaiyun.com/Xiaoyi_CES/article/details/148564320</guid><author>Xiaoyi_CES</author><pubDate>Thu, 12 Jun 2025 09:30:00 +0800</pubDate><description><![CDATA[DN节点内存扩容至256G后tpops仍显示128G，导致监控与调度决策错误，排查因core.dbs_host_specification_info表配置未自动更新。手动执行SQL更新内存值后问题解决。]]></description><category></category></item></channel></rss>