Recent Comments
Archives
- May 2017 (36)
- April 2017 (55)
- March 2017 (55)
- February 2017 (35)
- January 2017 (42)
- December 2016 (48)
- November 2016 (32)
- October 2016 (35)
- September 2016 (78)
- August 2016 (69)
- July 2016 (19)
- June 2016 (42)
- May 2016 (61)
- April 2016 (51)
- March 2016 (74)
- February 2016 (87)
- January 2016 (31)
- December 2015 (36)
- November 2015 (61)
- October 2015 (72)
- September 2015 (53)
- August 2015 (42)
- July 2015 (38)
- June 2015 (30)
- May 2015 (18)
- April 2015 (57)
- March 2015 (41)
- February 2015 (50)
- January 2015 (35)
- December 2014 (50)
- November 2014 (56)
- October 2014 (41)
- September 2014 (37)
- August 2014 (37)
- July 2014 (28)
- June 2014 (50)
- May 2014 (32)
- April 2014 (46)
- March 2014 (38)
- February 2014 (29)
- January 2014 (52)
- December 2013 (50)
- November 2013 (45)
- October 2013 (40)
- September 2013 (48)
- August 2013 (22)
- July 2013 (25)
- June 2013 (13)
- May 2013 (16)
- April 2013 (28)
- March 2013 (37)
- February 2013 (36)
- January 2013 (57)
- December 2012 (44)
- November 2012 (10)
- October 2012 (12)
- September 2012 (21)
- August 2012 (21)
- July 2012 (25)
- June 2012 (8)
- May 2012 (10)
- April 2012 (11)
- March 2012 (10)
- February 2012 (11)
- January 2012 (5)
- December 2011 (13)
- November 2011 (12)
- October 2011 (10)
- September 2011 (7)
- August 2011 (5)
- July 2011 (11)
- June 2011 (21)
- May 2011 (22)
- April 2011 (36)
- March 2011 (43)
- February 2011 (23)
- January 2011 (24)
- December 2010 (34)
- November 2010 (19)
- October 2010 (16)
- September 2010 (15)
- August 2010 (10)
- July 2010 (12)
- June 2010 (3)
- May 2010 (3)
- April 2010 (4)
- March 2010 (8)
- February 2010 (14)
- January 2010 (13)
- December 2009 (16)
- November 2009 (28)
- October 2009 (24)
- September 2009 (12)
- August 2009 (7)
- July 2009 (10)
- June 2009 (11)
- May 2009 (22)
- April 2009 (21)
- March 2009 (18)
- February 2009 (7)
- January 2009 (32)
- December 2008 (19)
- November 2008 (12)
- October 2008 (15)
- September 2008 (14)
- August 2008 (15)
- July 2008 (18)
- June 2008 (20)
- May 2008 (19)
- April 2008 (27)
- March 2008 (22)
- February 2008 (21)
- January 2008 (15)
- December 2007 (22)
- November 2007 (17)
- October 2007 (29)
- September 2007 (31)
- August 2007 (34)
- July 2007 (31)
- June 2007 (36)
- May 2007 (23)
- April 2007 (22)
- March 2007 (30)
- February 2007 (50)
- January 2007 (75)
- December 2006 (48)
- November 2006 (59)
- October 2006 (89)
- September 2006 (29)
- August 2006 (48)
- July 2006 (14)
- June 2006 (35)
- May 2006 (62)
- April 2006 (63)
- March 2006 (72)
- February 2006 (83)
- January 2006 (56)
- December 2005 (46)
- November 2005 (60)
- October 2005 (27)
- September 2005 (54)
- August 2005 (83)
Tags
Categories
- Anime (29)
- AWS (392)
- BBS (22)
- Blog (247)
- Book (31)
- Bridge (1)
- Browser (520)
- CDN (178)
- Cloud (533)
- CMS (58)
- Comic (19)
- Computer (4,337)
- Computer and Network Center (33)
- CSS (66)
- Database (403)
- DNS (124)
- Editor (23)
- Financial (88)
- Firefox (229)
- Food (14)
- FreeBSD (139)
- FTP (3)
- Game (59)
- GCP (3)
- GoogleChrome (162)
- Hardware (376)
- IE (96)
- Joke (159)
- Lab (3)
- Library (1)
- Linux (169)
- MacOS (30)
- Mail (117)
- MariaDB (19)
- Movie (32)
- Murmuring (4,475)
- Music (49)
- MySQL (285)
- NCTU (64)
- NetBSD (7)
- Network (3,166)
- OpenBSD (7)
- Opera (26)
- OS (385)
- P2P (130)
- Photo (72)
- Political (123)
- PostgreSQL (38)
- Programming (739)
- Recreation (529)
- RSS (78)
- Safari (38)
- Science (95)
- Search Engine (178)
- Security (1,014)
- SMS (10)
- Social (208)
- Software (2,295)
- Spam (107)
- Sport (10)
- Telephone (114)
- Television (59)
- Usenet (14)
- Vim (13)
- VPN (16)
- Wiki (48)
- Windows (73)
- WWW (1,593)
Blogroll
Meta
Tag Archives: performance
zetcd：用 etcd 跑 ZooKeeper 架構
在「zetcd: running ZooKeeper apps without ZooKeeper」這邊介紹了用 etcd 當作 ZooKeeper 伺服器。程式碼在「Serve the Apache Zookeeper API but back it with an etcd cluster」這邊可以看到。 不過可以看到有不少 overhead： 但 etcd 用 Go 寫 (省下 JVM tuning？)，可能是個不錯的誘因...
MySQL 8.0 對 4 bytes UTF-8 的效能改善
在「MySQL 8.0: When to use utf8mb3 over utf8mb4?」這邊提到了 MySQL 對 utf8 以及 utf8mb4 的故事，以及在 MySQL 8.0 預期的效能提昇： 可以看到 Oracle 的團隊花了不少力氣提昇 utf8mb4 的效能。另外提到了在 5.7 的時候將 row format 的預設值轉成 DYNAMIC： MySQL 5.7 (2015) added some optimizations such as a variable length sort … Continue reading
用 Go 寫的 Badger
Dgraph 在推銷自家發展出來的 Badger：「Introducing Badger: A fast key-value store written natively in Go」。 標靶是 RocksDB，號稱比 RocksDB 快好幾倍： Based on benchmarks, Badger is at least 3.5x faster than RocksDB when doing random reads. For value sizes between 128B to 16KB, data loading … Continue reading
InnoDB redo log 大小對效能的影響
在「Benchmark(et)ing with InnoDB redo log size」這邊看到在討論 InnoDB redo log 的大小對效能的影響 (也就是 innodb_log_file_size 與 innodb_log_files_in_group)。 開頭就有先提到重點，在新版 MySQL 裡，幾乎所有的情況比較大的 redo log 有比較好的效能 (平均值)： tl;dr - conclusions specific to my test A larger redo log improves throughput A larger redo log helps more … Continue reading
curl 的 refactor 減少 malloc() 的次數
curl 的作者 Daniel Stenberg 寫了一篇關於他 refactor 大幅改善了 curl 的效能：「Fewer mallocs in curl」。 藉由大幅減少 malloc() 次數，在抓大檔案時會有明顯的改善： 7.54.1-DEV repeatedly performed 30% faster! The 2200MB/sec in my build of the earlier release increased to over 2900 MB/sec with the current version. 另外如果對 localhost … Continue reading
Posted in Computer, Murmuring, Network, Programming, Software, WWW
Tagged curl, http, localhost, malloc, network, performance, refactor, speed
Leave a comment
各家 glob 的效能...
在「Glob Matching Can Be Simple And Fast Too」這邊看到在分析 (a.*)nb 這樣的 pattern 的效能 (像是 a.*a.*a.*b 這樣的東西)，第一波先測 shell，結果發現有趣的現象： 那個 csh 是怎麼了 XDDD Looking at the source code, it doesn’t attempt to perform glob expansion itself. Instead it calls the C library implementation … Continue reading
Posted in Computer, Murmuring, Programming, Security, Software
Tagged c, csh, fast, glob, match, matching, performance, programming, shell, speed
Leave a comment
超越線性成長的資料庫架構
標題取自 Percona 的「Better Than Linear Scaling」。 其實是因為機器數量增加，而且有妥善規劃，使得 cache 的 hit rate 上升而讓整體效率變好 (也就是 1 + 1 > 2)。 不只在 database 上會發生，在其他系統上其實會有類似的情況，剛好看到覺得很懷念 XD
Percona XtraDB Cluster 解釋最近的版本為什麼可以再度提昇效能
Percona XtraDB Cluster 最近的一個版本宣稱效能大幅提昇，這篇試著解釋原因：「How We Made Percona XtraDB Cluster Scale」。 裡面提了三個情境，解釋了這些效能問題以及解法，進而帶出這次的效能提昇： With these three main optimizations, and some small tweaks, we have tuned Percona XtraDB Cluster to scale better and made it fast enough for the growing demands of your … Continue reading
Percona XtraDB Cluster 5.7 的效能改善
在「Percona XtraDB Cluster 5.7.17-29.20 is now available」這邊提到了： This release is focused on performance and scalability with increasing workload threads. Tests show up to 10 times increase in performance. 不過這邊沒提到是 MySQL 本身還是 Galera Cluster 實做的修正，或是 PXC 本身特有的 bug 被修正... (通常都是有 bug … Continue reading
肥大的 DISQUS
在「Replacing Disqus with Github Comments」這邊看到作者抱怨 DISQUS 的肥大，然後作者自己寫了一個用 GitHub 當後端的 comment system XDDD 先看沒有 DISQUS 的： 然後把 DISQUS 掛進來 XDDD：(不得不說 uBlock Origin 與 Disconnect 是你的好朋友...)