38. I just wrote and published an essay on Multi-Paxos and
发布了一篇关于Multi-Paxos及分布式数据库共识机制的技术文章。

39. Paxos has to be one of the trickiest, but also
Paxos算法虽难懂,但直觉理解可简化其共识机制。

40. Uber open-sourced their M3 metrics platform, and while skimming through
Uber开源M3指标平台,其LTTB降采样算法高效保留数据视觉特征。

41. Here's something interesting about LIKE in SQL - it is
SQL中LIKE通配符未转义可致数据库全表扫描,引发拒绝服务攻击。

42. If protobuf is already a compact binary format, should we
Uber M3用Snappy压缩protobuf以平衡速度与压缩率。

43. I do not remember shell commands :) and I needed
开发者创建了名为x的bash工具,用自然语言生成并确认后执行shell命令。

44. Time series databases are extremely good at compression, and most
时序数据库通过增量增量压缩将时间戳存储降至1-4位,压缩率最高64倍。

45. Wrote an essay on how MySQL binlog replication actually works
详解MySQL binlog复制机制及生产实践要点。

46. I was exploring MySQL internals and found something clever called
MySQL的change buffer优化通过延迟合并索引更新,减少随机磁盘I/O,提升写密集负载性能。

47. Looks like filesystems are the next big thing in AI
文件系统正成为AI智能体的新趋势,通过虚拟文件系统赋予模型操作数据的能力。

48. Most of us assume that stored procedures are cached globally,
MySQL和PostgreSQL的存储过程缓存是会话级的,短连接频繁调用会重复解析。

49. Redis heavily uses Circular Buffers in its replication implementation to
Redis用环形缓冲区实现主从复制,断线重连时支持部分同步。

50. everybody loves it when a database just works
稳定可预测的数据库比高效但不稳定的更受欢迎。