<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[xiewen99的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/xiewen99</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; xiewen99]]></copyright><item><title><![CDATA[MySQL innodb_flush_method/innodb_use_fdatasync]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/124270725</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/124270725</guid><author>xiewen99</author><pubDate>Tue, 19 Apr 2022 12:42:44 +0800</pubDate><description><![CDATA[结论
8.0.26+ 配置 innodb_flush_method=O_DIRECT，innodb_use_fdatasync=ON
8.0.26- 配置 innodb_flush_method=O_DIRECT
环境
host1 Percona Server 8.0.26-16
host2 Percona Server 8.0.25-15
host3 sysbench 1.0.20

EL 7.6 4.14.35
ssd &amp; ext4

sysbench:
--tables=30 --table_]]></description><category></category></item><item><title><![CDATA[MySQL Authentications]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/124194894</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/124194894</guid><author>xiewen99</author><pubDate>Fri, 15 Apr 2022 14:57:49 +0800</pubDate><description><![CDATA[认证方法
1. mysql 320 password(3.20)             32-bit hash
2. mysql_old_password(3.21-4.0)         16-byte MD5 hash(aka. mysql323) 无盐
3. mysql_native_password(4.1)           41-byte double-SHA1 hash 无盐
4. sha256_password(5.6.6)               SHA-256 hash
5. ]]></description><category></category></item><item><title><![CDATA[MySQL 8.0 Terminology Updates]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/124194771</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/124194771</guid><author>xiewen99</author><pubDate>Fri, 15 Apr 2022 14:52:05 +0800</pubDate><description><![CDATA[MySQL/Percona
Variables
版本      旧术语                                    新术语                                        参考
----      ------                                    ------                                        ----
8.0.22+   group_replication_ip_white]]></description><category></category></item><item><title><![CDATA[IP 别名和辅助 IP 地址]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/54729112</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/54729112</guid><author>xiewen99</author><pubDate>Wed, 25 Jan 2017 12:05:13 +0800</pubDate><description><![CDATA[概述IP 别名（IP Alias），辅助ip地址（Secondary IP Address）]]></description><category></category></item><item><title><![CDATA[Lets Encrypt]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/54729084</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/54729084</guid><author>xiewen99</author><pubDate>Wed, 25 Jan 2017 11:59:20 +0800</pubDate><description><![CDATA[Let’s Encrypt 是国外一个公共的免费 SSL 项目，目的就是向网站自动签发和管理免费证书，以便加速互联网由 HTTP 过渡到 HTTPS]]></description><category></category></item><item><title><![CDATA[常用 YUM 源]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/54729076</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/54729076</guid><author>xiewen99</author><pubDate>Wed, 25 Jan 2017 11:57:56 +0800</pubDate><description><![CDATA[常用 YUM 源]]></description><category></category></item><item><title><![CDATA[双端队列、随机队列、蓄水池抽样算法]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/54092255</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/54092255</guid><author>xiewen99</author><pubDate>Thu, 05 Jan 2017 13:39:31 +0800</pubDate><description><![CDATA[双端队列、随机队列、蓄水池抽样算法]]></description><category></category></item><item><title><![CDATA[Coursera - 计算机组成 - W3 - MIPS汇编程序设计]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/53931029</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/53931029</guid><author>xiewen99</author><pubDate>Thu, 29 Dec 2016 17:55:21 +0800</pubDate><description><![CDATA[Coursera - 计算机组成 - W3 - MIPS汇编程序设计]]></description><category></category></item><item><title><![CDATA[Coursera.Algorithms.Part.I.Week.1.Percolation]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52864123</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52864123</guid><author>xiewen99</author><pubDate>Tue, 20 Dec 2016 16:06:09 +0800</pubDate><description><![CDATA[Coursera.Algorithms.Part.I.Week.1.Percolation]]></description><category></category></item><item><title><![CDATA[Percolation 渗透算法]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52476368</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52476368</guid><author>xiewen99</author><pubDate>Tue, 20 Dec 2016 11:42:07 +0800</pubDate><description><![CDATA[Percolation 渗透算法]]></description><category></category></item><item><title><![CDATA[GitLab]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/53507507</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/53507507</guid><author>xiewen99</author><pubDate>Wed, 07 Dec 2016 16:09:47 +0800</pubDate><description><![CDATA[GitLab 是一个利用 Ruby on Rails 开发的开源应用程序，实现一个自托管的 Git 项目仓库，可通过 Web 界面进行访问公开的或者私人项目]]></description><category></category></item><item><title><![CDATA[Jenkins 2.0]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/53443650</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/53443650</guid><author>xiewen99</author><pubDate>Sat, 03 Dec 2016 12:00:46 +0800</pubDate><description><![CDATA[Jenkins 2.0 最大的三个卖点分别是 Pipeline as Code，全新的开箱体验和 1.x 兼容性]]></description><category></category></item><item><title><![CDATA[程序设计与算法 第十周测验]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52913659</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52913659</guid><author>xiewen99</author><pubDate>Mon, 24 Oct 2016 17:31:49 +0800</pubDate><description><![CDATA[程序设计与算法 第十周测验]]></description><category></category></item><item><title><![CDATA[An Introduction to Interactive Programming in Python (Part 1) - Week 1]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52677379</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52677379</guid><author>xiewen99</author><pubDate>Mon, 10 Oct 2016 13:33:28 +0800</pubDate><description><![CDATA[An Introduction to Interactive Programming in Python (Part 1) - Week 1]]></description><category></category></item><item><title><![CDATA[程序设计与算法 第八、九周测验]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52681998</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52681998</guid><author>xiewen99</author><pubDate>Tue, 27 Sep 2016 17:56:34 +0800</pubDate><description><![CDATA[程序设计与算法 第八、九周测验]]></description><category></category></item><item><title><![CDATA[Coursera Machine Learning Week 7 - Support Vector Machines]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52677376</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52677376</guid><author>xiewen99</author><pubDate>Tue, 27 Sep 2016 07:36:45 +0800</pubDate><description><![CDATA[Coursera Machine Learning Week 7 - Support Vector Machines]]></description><category></category></item><item><title><![CDATA[MooseFS Master main 函数代码简单学习]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52641647</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52641647</guid><author>xiewen99</author><pubDate>Fri, 23 Sep 2016 19:09:30 +0800</pubDate><description><![CDATA[MooseFS Master main 函数代码简单学习]]></description><category></category></item><item><title><![CDATA[An Introduction to Interactive Programming in Python (Part 1) - Week 0]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52615008</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52615008</guid><author>xiewen99</author><pubDate>Thu, 22 Sep 2016 00:16:46 +0800</pubDate><description><![CDATA[An Introduction to Interactive Programming in Python (Part 1) - Week 0 - Statements, expressions, variables]]></description><category></category></item><item><title><![CDATA[MongoDB 并发机制]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52607007</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52607007</guid><author>xiewen99</author><pubDate>Wed, 21 Sep 2016 13:47:32 +0800</pubDate><description><![CDATA[MongoDB 并发机制]]></description><category></category></item><item><title><![CDATA[程序设计与算法 第七周测验]]></title><link>https://blog.youkuaiyun.com/xiewen99/article/details/52585253</link><guid>https://blog.youkuaiyun.com/xiewen99/article/details/52585253</guid><author>xiewen99</author><pubDate>Mon, 19 Sep 2016 15:00:20 +0800</pubDate><description><![CDATA[程序设计与算法 第七周测验]]></description><category></category></item></channel></rss>