<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[yangBiBiya的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/yangBiBiya</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yangBiBiya]]></copyright><item><title><![CDATA[Actor 模型在 Actix 中的应用]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/154125063</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/154125063</guid><author>yangBiBiya</author><pubDate>Thu, 30 Oct 2025 13:58:57 +0800</pubDate><description><![CDATA[Actor 模型强调状态与行为的封装，Actix 在 Rust 世界通过强类型、消息驱动、生命周期管理、并发调度把这一理念落地为可实战的工具。理解ActorMessageContextSupervisor等概念，同时掌握 mailbox 调优、异步 Handler、与actix-web整合等技巧，能帮助你构建出既高并发又可维护的服务。面对复杂的业务逻辑、并发访问、错误容错，Actor 模型提供了一个更符合人类直觉的“角色与消息”视角。]]></description><category></category></item><item><title><![CDATA[Tokio 与其他 Rust 异步运行时的深度比较]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/154125012</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/154125012</guid><author>yangBiBiya</author><pubDate>Thu, 30 Oct 2025 13:57:07 +0800</pubDate><description><![CDATA[Tokio 使能了一整套 mini-ecosystemhypertonicsqlxmetricstracing都构建在它之上。若你在团队中推动 Rust，上 Tok io 的生态与社区支持最强。async-std 值得关注：对初学者友好；统一 style（std完整替代）有吸引力；在 Edged 和 CLI 脚本场景运营良好。smol、async-global-executor 提供了“可组装”的 lego：适合小型独立项目。glommio/monoio 面向极限。]]></description><category></category></item><item><title><![CDATA[Tokio 应用的监控与调优]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/154124927</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/154124927</guid><author>yangBiBiya</author><pubDate>Thu, 30 Oct 2025 13:55:06 +0800</pubDate><description><![CDATA[gauge!；histogram!；阻塞池占用：通过返回值统计；sleep监测 drift。这些指标是后续定位问题的重要依据。Tokio 的性能监控与调优是一条长线工作，需要从运行时、业务、操作系统三个维度精细配合。知道如何捕捉任务与资源的实时状态；在出现吞吐下降、延迟飙升时迅速定位问题；合理设置 runtime 参数、锁定 CPU 使用率；构建 ab test 与测试环境验证性能改动；在大规模服务场景中持续迭代、保持鲁棒。]]></description><category></category></item><item><title><![CDATA[Tokio 资源管理与清理的系统实践]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/154124855</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/154124855</guid><author>yangBiBiya</author><pubDate>Thu, 30 Oct 2025 13:53:06 +0800</pubDate><description><![CDATA[Tokio 带来了极具表现力的异步编程模式，但也对资源管理提出了更高要求。任务、通道、锁、I/O、运行时本身都需要精心设计的生命周期与清理策略。]]></description><category></category></item><item><title><![CDATA[Tokio 异步通道（mpsc、oneshot）原理与实践]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/154124749</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/154124749</guid><author>yangBiBiya</author><pubDate>Thu, 30 Oct 2025 13:50:17 +0800</pubDate><description><![CDATA[Tokio 的异步通道是很多异步架构的血管。从oneshot的轻量握手，到mpsc的消息流，通道内部封装了 waker、无锁队列、背压控制等复杂机制，却在外部呈现出简洁易懂的 API。熟悉它们的设计原理、错误处理路径和性能特性，就能在实践中高效构建流水线、actor 系统、任务协调逻辑。]]></description><category></category></item><item><title><![CDATA[sql mark]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/93736738</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/93736738</guid><author>yangBiBiya</author><pubDate>Wed, 26 Jun 2019 14:16:54 +0800</pubDate><description><![CDATA[# 查询" 01 "课程比" 02 "课程成绩高的学生的信息及课程分数
select  student.*,a.score'C01',b.score'C02'
       from (select score ,SId from sc where sc.CId='01') as a,(select score ,SId from sc where sc.CId='02') as b,studen...]]></description><category></category></item><item><title><![CDATA[SQL mark]]></title><link>https://blog.youkuaiyun.com/yangBiBiya/article/details/93735612</link><guid>https://blog.youkuaiyun.com/yangBiBiya/article/details/93735612</guid><author>yangBiBiya</author><pubDate>Wed, 26 Jun 2019 14:05:05 +0800</pubDate><description><![CDATA[SQL 按天、周、月、季度、年汇总
工单量报表（by 日期，工单处理人，工单类型，SLA解决）
// 天
select a.day,sum(a.new) as 'new',sum(a.close) as 'close',a.ServiceStaff_2,a.servicetype
from(
        select cast(createtime as date) as day,count(...]]></description><category></category></item></channel></rss>