<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cleanfield的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cleanfield</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cleanfield]]></copyright><item><title><![CDATA[mysql单表过亿数据，怎样优化查询速度，且不停服]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/155783309</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/155783309</guid><author>cleanfield</author><pubDate>Wed, 10 Dec 2025 15:33:51 +0800</pubDate><description><![CDATA[面对单表1亿多条数据导致的访问缓慢问题，要在不停机的情况下进行优化，确实是个挑战。下面梳理了一套从到，再到的完整方案。]]></description><category></category></item><item><title><![CDATA[基于特征码实现的游戏战斗验证机制]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/153696035</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/153696035</guid><author>cleanfield</author><pubDate>Tue, 21 Oct 2025 18:23:50 +0800</pubDate><description><![CDATA[完美解决了战斗录像验证的性能问题，使校验时间从线性增长变为常数时间，同时通过关键帧机制保留了快速定位差异的能力]]></description><category></category></item><item><title><![CDATA[记一次logtail锁死/tmp目录]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/135990592</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/135990592</guid><author>cleanfield</author><pubDate>Fri, 02 Feb 2024 12:26:26 +0800</pubDate><description><![CDATA[记录一次logtail导致的目录锁死经历]]></description><category></category></item><item><title><![CDATA[netlink学习]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/135952862</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/135952862</guid><author>cleanfield</author><pubDate>Wed, 31 Jan 2024 14:32:57 +0800</pubDate><description><![CDATA[从inotify引出auditd，从auditd引出netlink，从netlink引出libnl和libmnl]]></description><category></category></item><item><title><![CDATA[inotify学习]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/135940139</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/135940139</guid><author>cleanfield</author><pubDate>Tue, 30 Jan 2024 19:46:20 +0800</pubDate><description><![CDATA[inotify的原理与使用]]></description><category></category></item><item><title><![CDATA[rsyslog学习]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/134576663</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/134576663</guid><author>cleanfield</author><pubDate>Thu, 23 Nov 2023 14:40:51 +0800</pubDate><description><![CDATA[rsyslog的消息流是从输入模块->预处理模块->主队列->过滤模块->执行队列->输出模块。]]></description><category></category></item><item><title><![CDATA[文件描述符与锁定状态在系统层面的表示]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/134550403</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/134550403</guid><author>cleanfield</author><pubDate>Wed, 22 Nov 2023 12:10:14 +0800</pubDate><description><![CDATA[实际上，在父子进程共享文件锁时，锁表项中的锁定进程 ID 只包含创建并持有该锁的原始进程（通常是父进程）的 ID。然而，在锁表项中，锁定进程 ID 仅指向原始创建并持有锁的进程（父进程）的 ID。当子进程继承父进程的文件描述符时，子进程实际上继承了指向同一文件表项的引用，这意味着父子进程共享该锁，而不是每个进程拥有其自己的锁表项。在上面的示意图中，Process A（父进程）和 Process B（子进程）共享同一个文件描述符表项，这意味着它们实际上指向同一个文件表项，而不是内容相同的两个文件表项。]]></description><category></category></item><item><title><![CDATA[实现脚本单例运行的两种方案]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/134538954</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/134538954</guid><author>cleanfield</author><pubDate>Tue, 21 Nov 2023 19:13:34 +0800</pubDate><description><![CDATA[加注：在多进程或跨脚本场景中，简单地判断锁文件是否存在可能导致竞争条件。若多个进程或脚本实例在几乎相同的时间点检查并尝试创建锁文件，这样一来，就可能让多个实例同时获得锁并运行。由于此种情况下的检查和创建锁文件并不是原子性操作（无法保证在一个不可分割的操作中完成），因此可能导致竞争条件的发生。简单地判断锁文件是否存在是一种简单易懂的方法，但可能导致竞争条件、锁未释放等问题，不如。如果文件不存在，就创建一个锁文件，获得锁。综上，简单地判断锁文件是否存在的方案同样可以应用于跨进程和跨脚本场景，但相较于。]]></description><category></category></item><item><title><![CDATA[flock使用文件描述符和使用文件的区别]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/134536836</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/134536836</guid><author>cleanfield</author><pubDate>Tue, 21 Nov 2023 17:22:23 +0800</pubDate><description><![CDATA[flock有两种使用方式，本文分析了两者之间的优劣]]></description><category></category></item><item><title><![CDATA[xargs如何保留文本中的引号]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/132755129</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/132755129</guid><author>cleanfield</author><pubDate>Fri, 08 Sep 2023 10:38:12 +0800</pubDate><description><![CDATA[文本中如果有引号，直接用xargs处理会丢失，本文展示一种比较方便灵巧的办法，实现引号正常传递]]></description><category></category></item><item><title><![CDATA[linux下sz命令不能传输超过4g文件的解决办法]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/131332587</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/131332587</guid><author>cleanfield</author><pubDate>Wed, 21 Jun 2023 18:25:30 +0800</pubDate><description><![CDATA[通过分割与合并文件，解决sz超过4g无法传输的问题]]></description><category></category></item><item><title><![CDATA[redis中sort妙用，实现动态生成排行榜]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/131251588</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/131251588</guid><author>cleanfield</author><pubDate>Fri, 16 Jun 2023 18:08:28 +0800</pubDate><description><![CDATA[sort命令可以实现多string，多hash的联合查询，不用lua就可以实现原子操作]]></description><category></category></item><item><title><![CDATA[shell教程]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/129091805</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/129091805</guid><author>cleanfield</author><pubDate>Fri, 17 Feb 2023 18:14:18 +0800</pubDate><description><![CDATA[记录shell必备基础知识，大家可以收藏，方便查阅]]></description><category></category></item><item><title><![CDATA[linux下程序占用内存只涨不降原因追查]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/128312395</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/128312395</guid><author>cleanfield</author><pubDate>Wed, 14 Dec 2022 15:42:38 +0800</pubDate><description><![CDATA[linux下进程占用内存只增不减，如何定位问题，这里给出了一次追查过程]]></description><category></category></item><item><title><![CDATA[解决cscript打开excel时宏互不可见的问题]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/127928472</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/127928472</guid><author>cleanfield</author><pubDate>Fri, 18 Nov 2022 19:49:33 +0800</pubDate><description><![CDATA[巧妙解决cscript解决打开多个excel文件时，后面文件看不到前面文件中定义的宏]]></description><category></category></item><item><title><![CDATA[基于awk实现的表格检查框架]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/127422454</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/127422454</guid><author>cleanfield</author><pubDate>Thu, 20 Oct 2022 11:07:24 +0800</pubDate><description><![CDATA[awk天生就是处理表格数据的，本文实现了一种基于awk的表格检查框架，已经在实际生产环境应用，希望对大家有帮助]]></description><category></category></item><item><title><![CDATA[如何实现select * exclude column]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/127319574</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/127319574</guid><author>cleanfield</author><pubDate>Fri, 14 Oct 2022 14:17:58 +0800</pubDate><description><![CDATA[实现mysql中的insert into B select * exclude from，]]></description><category></category></item><item><title><![CDATA[shell中pipeline的运行探秘]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/127223902</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/127223902</guid><author>cleanfield</author><pubDate>Sun, 09 Oct 2022 12:40:05 +0800</pubDate><description><![CDATA[介绍shell中的pipeline的实现机制以及运行解析，可以理解shell中的子进程以及管道的应用]]></description><category></category></item><item><title><![CDATA[shell的前世今生]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/127204188</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/127204188</guid><author>cleanfield</author><pubDate>Sat, 08 Oct 2022 11:06:46 +0800</pubDate><description><![CDATA[shell是什么，为什么有shell，它如何工作，怎样认识shell]]></description><category></category></item><item><title><![CDATA[bat中实现从配置文件中加载变量]]></title><link>https://blog.youkuaiyun.com/cleanfield/article/details/127017052</link><guid>https://blog.youkuaiyun.com/cleanfield/article/details/127017052</guid><author>cleanfield</author><pubDate>Fri, 23 Sep 2022 19:55:46 +0800</pubDate><description><![CDATA[将逻辑代码与配置信息分离，这样可以更好的隔离]]></description><category></category></item></channel></rss>