The Magic of Programming

February 2024

• 从高精度时钟服务看国内云计算厂商的差距 (2024-02-15) [ Time ]

January 2024

• Software Bill of Materials (2024-01-20) [ SBOM ]

April 2023

• GB18030-2022 字符集标准对数据库的影响 (2023-04-17) [ GB18030 ]

March 2023

• Vector Search and Vector Database (2023-03-01) [ Vector , DBMS , Search ]

February 2023

• Composable Data Management System (2023-02-14) [ Composable System , DBMS ]

November 2022

• Visual Studio Code Remote SSH (2022-11-22) [ vscode ]
• DuckDB - An OLAP Database System (2022-11-20) [ DuckDB , DBMS ]
• Random Thoughts AC (2022-11-01) [ random ]

July 2022

• Shell and SQL Make Friends (2022-07-21) [ SQL , Shell ]

May 2022

• Tips for Microsoft PowerPoint (2022-05-30) [ PowerPoint ]

January 2022

• Hadoop NameNode and Checkpoint (2022-01-31) [ Hadoop ]
• SQL Rules The World (2022-01-21) [ SQL ]

November 2021

• The Lexer and Parser of InfluxDB (2021-11-24) [ InfluxDB , DBMS ]

October 2021

• Debugging the Infinite Loop of Scanf (2021-10-16) [ C ]
• Random Thoughts AB (2021-10-01) [ random ]

September 2021

• VMware Fusion Player for macOS (2021-09-24) [ VM , macOS ]
• Random Thoughts AA (2021-09-01) [ random ]

April 2021

• Perf for WSL2 (2021-04-30) [ WSL , perf ]

September 2020

• 高校分数和名次（针对北京考生） (2020-09-01) [ Misc ]

February 2020

• CTE in MySQL 8.0 (2020-02-14) [ MySQL , SQL ]

December 2019

• An Introduction to SQL Standard (UPDATED) (2019-12-24) [ SQL ]

November 2019

• GNUplot and Python/Plot (2019-11-27) [ plot ]

October 2019

• Overview of OLAP products (2019-10-24) [ OLAP , DBMS ]

September 2019

• MATLAB memo (2019-09-28) [ matlab ]

July 2019

• Performance, tips and traps (2019-07-13) [ perf , DBMS ]

June 2019

• An Introduction to HTAP (2019-06-30) [ HTAP , DBMS ]
• CAP and Database System (2019-06-22) [ DBMS , CAP ]
• 数据库与新硬件技术 (2019-06-15) [ DBMS ]
• 漫谈 Oracle 兼容 (2019-06-07) [ Oracle ]
• SAP HANA 和非易失性存储 (2019-06-01) [ PMDK , SAP HANA ]

May 2019

• Serverless 数据库服务 (2019-05-12) [ Serverless , DBMS ]
• Efficient IO with io_uring (2019-05-11) [ io-uring ]
• PMDK 和 SNIA 标准 (2019-05-03) [ PMDK ]

April 2019

• PMDK 及其应用场景 (2019-04-27) [ PMDK ]
• PMDK和CACHE FLUSH (2019-04-21) [ PMDK ]
• 内存暴涨的分析方法和工具 (2019-04-18) [ memory ]
• MMAP and PMDK (2019-04-15) [ PMDK ]

March 2019

• PMDK FAQ (2019-03-22) [ PMDK ]
• QEMU Tips (2019-03-20) [ VM , QEMU ]

February 2019

• 数据库系统设计的 N 种套路 (2019-02-08) [ DBMS ]
• A Try on PMDK (2019-02-03) [ PMDK ]
• Early Lock Release (2019-02-01) [ MySQL , InnoDB ]

January 2019

• An Introduction to SQL Standard（SQL标准简介） (2019-01-30) [ SQL ]
• Windows Subsystem for Linux (2019-01-28) [ WSL ]
• 数据库和存储领域一些容易混淆的概念和术语 (2019-01-18) [ DBMS ]

December 2017

• The RISC-V Memory Consistency Model (2017-12-31) [ RISC-V ]

October 2016

• MySQL 8.0 直方图的实现与分析 (2016-10-09) [ MySQL , Histogram ]

March 2016

• 嵌套查询的查询优化 (2016-03-31) [ SQL , DBMS ]

March 2015

• 文件系统和数据库的对比 (2015-03-31) [ File System , DBMS ]
• 说说FoundationDB (2015-03-29) [ FoundationDB , DBMS ]

January 2015

• ACID (2015-01-10) [ SQL , ACID ]
• 重读A Critique of ANSI SQL Isolation Levels (2015-01-04) [ SQL , ACID ]

December 2014

• SQL标准简介 (2014-12-11) [ SQL ]

June 2014

• 回顾一下著名的BigTable论文 (2014-06-30) [ BigTable ]
• 回顾一下著名的GFS论文 (2014-06-22) [ GFS ]
• MySQL的词法分析漫谈 (2014-06-11) [ MySQL , DBMS ]

April 2014

• 从FusionIO的NVM压缩接口谈起 (2014-04-03) [ SSD ]
• 我的Vim为什么不变色了 (2014-04-01) [ Linux , vim ]

March 2014

• Facebook, Google, Twitter, Linkedin推出了WebScaleSQL (2014-03-28) [ MySQL ]
• VMware Virtual Volume - vVol (2014-03-28) [ VM , vVol ]
• NVMe终于有产品支持了 (2014-03-27) [ SSD ]
• 优雅的cancel一个pthread线程 (2014-03-26) [ thread , C , cplusplus ]
• 久违的SQL标准 (2014-03-25) [ SQL ]
• 试试Fedora 20里头的File System on File (2014-03-23) [ Linux , FSoF , File System ]
• 打洞（Punch a hole）：回收存储空间（File、Block以及其他） (2014-03-21) [ Linux , Punch hole , File System ]
• Different ways to get the symbol name and … (2014-03-02) [ cplusplus , C ]

February 2014

• Collection of debates on O_DIRECT (2014-02-28) [ Linux , O_DIRECT , File System ]
• 读《The End of an Architectural Era (It’s Time for a Complete Rewrite)》 (2014-02-24) [ DBMS ]

January 2014

• MySQL thread pool (2014-01-29) [ MySQL ]
• 娱乐版TPC测试 (2014-01-27) [ TPC-C ]
• MySQL嵌入式版本的小程序例子 (2014-01-27) [ MySQL ]

December 2012

• 给SPECfs2008的数据画个图（图中少了个字母s） (2012-12-16) [ dot , SPECfs , File System ]

August 2012

• Berkeley DB设计经验 (2012-08-15) [ Berkeley DB , DBMS ]

February 2012

• NAND闪存的黯淡未来 (2012-02-25) [ SSD ]
• Disk Corruption以及它们对DBMS的影响 (2012-02-17) [ DBMS ]
• 有关Splay Tree的一点感想 (2012-02-12) [ Splay Tree ]
• Weaving Relations for Cache Performance (2012-02-11) [ DBMS ]
• State Machine and Event Processing (2012-02-11) [ State Machine ]
• How to install NetWorker on Linux? (2012-02-11) [ Linux , NetWorker ]

August 2011

• 有关系统性能优化的一点思考 (2011-08-07) [ perf ]

June 2011

• 状态转换图和目录结构图 (2011-06-01) [ dot ]

April 2011

• 可移植性真的很重要：on shell and tr (2011-04-09) [ Shell ]

March 2011

• Bloom Filter in Oracle Database (2011-03-07) [ Oracle , DBMS ]
• Collections of Data Deduplication Links (2011-03-05) [ Dedup ]

February 2011

• DLL hell again - this time on Linux (2011-02-16) [ Linux ]

January 2011

• Optimizing the Linux kernel for Database? (2011-01-29) [ Linux , DBMS ]
• Build distcc from source code (2011-01-19) [ C , cplusplus ]
• Notes on deduplication (2011-01-05) [ Dedup ]

September 2010

• Quick reference for Fedora Core 13’s installation on VMware 6.5 (2010-09-21) [ Linux , VM ]
• heap mgmt and multi-threaded. (2010-09-05) [ C ]

August 2010

• Again, Notes on Alignment (2010-08-27) [ C ]

July 2010

• 最近遇到的几个有趣的工具 (2010-07-01) [ Misc ]

May 2010

• 进程之间的互操作 (2010-05-13) [ Misc ]

April 2010

• A short puzzle about heap expansion (2010-04-30) [ memory ]
• Oracle与MySQL中“可串行化”的对比测试 (2010-04-26) [ MySQL , Oracle , ACID ]
• 自治事务（Autonomous Transaction） (2010-04-23) [ SQL ]

March 2010

• 软件可靠性——从2003年北美大停电说起 (2010-03-30) [ Misc ]
• 表达式的求值顺序 (2010-03-11) [ SQL ]

December 2009

• Oracle Makes Commitments to Customers, Developers and Users of MySQL (2009-12-30) [ MySQL ]
• 介绍Stonebraker和DeWitt教授的文章 (2009-12-29) [ DBMS , MapReduce ]
• ODBC重新焕发生机 (2009-12-26) [ ODBC ]
• “木桶原理”到底源自哪里？ (2009-12-25) [ Misc ]
• Google Public DNS (2009-12-23) [ Misc ]
• MySQL将会像BSD、Linux那样弄出不同的分支和发行版？ (2009-12-16) [ MySQL ]
• 微软的数据访问技术（From MDAC to Windows DAC） (2009-12-01) [ Misc ]

July 2007

• 用尽量少的语句和C语言关键字实现一个函数 (2007-07-11) [ C ]

August 2006

• What’s stack overflow? (2006-08-10) [ Stack Overflow ]

July 2006

• 各种语言写就的“hello world”程序 (2006-07-17) [ Hello World ]
• Ambiguous call to overloaded function (2006-07-10) [ cplusplus ]

June 2006

• 在Linux下产生并调试core文件 (2006-06-30) [ coredump ]

May 2006

• 符号链接、硬链接、快捷方式和Junctions (2006-05-18) [ File System ]
• 从给查询结果集增加行号说起 (2006-05-18) [ SQL , Shell ]
• 此NULL非彼NULL (2006-05-18) [ SQL , NULL ]

October 2005

• GNU gprof 的使用以及常见问题 (2005-10-14) [ gprof , perf ]

August 2005

• tpmC per Warehouse in TPC-C (2005-08-31) [ TPC-C , tpmC ]
• 事务的隔离级别（Transaction Isolation Level） (2005-08-05) [ SQL , ACID ]

February 2005

• SQL 数据类型辨析 (2005-02-16) [ SQL ]

July 2004

• 在SourceInsight中集成版本管理工具 (2004-07-01) [ SourceInsight ]

June 2004

• 用SQL找出前N名 (2004-06-01) [ SQL ]
• 数据库中的数据类型 (2004-06-01) [ SQL ]

April 2003

• 可更新视图 (2003-04-04) [ SQL , VIEW ]

March 2003

• 空值的问题 (2003-03-04) [ SQL ]