Recent Comments
- AWS NLB 也可以指定 IP address 當後端了 | Gea-Suan Lin's BLOG on AWS ALB 可以設定 IP address 當作後端伺服器了
- s25g5d4 on Mozilla 的提案「HTTP Immutable Responses」
- EC2 與 EBS 十月開始以秒計費 | Gea-Suan Lin's BLOG on AWS CodeDeploy 支援 BlueGreenDeployment
- Google Chrome 將 .dev 設為 HSTS Preload 名單 | Gea-Suan Lin's BLOG on 在 Google Chrome 連上因 HSTS 而無法連線的網站
- Isaac Kwan on Google Chrome 對 Symantec 全系列憑證的不信任計畫
Archives
- September 2017 (42)
- August 2017 (37)
- July 2017 (41)
- June 2017 (37)
- May 2017 (59)
- 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 (442)
- BBS (22)
- Blog (251)
- Book (31)
- Bridge (1)
- Browser (530)
- Cassandra (2)
- CDN (186)
- Cloud (590)
- CMS (58)
- Comic (19)
- Computer (4,513)
- Computer and Network Center (33)
- CSS (71)
- Database (423)
- DNS (132)
- Editor (26)
- Financial (89)
- Firefox (233)
- Food (14)
- FreeBSD (139)
- FTP (3)
- Game (63)
- GCP (8)
- Go (2)
- GoogleChrome (168)
- Hardware (387)
- IE (98)
- Joke (159)
- Lab (4)
- Library (8)
- Linux (175)
- MacOS (31)
- Mail (120)
- MariaDB (19)
- Movie (35)
- Murmuring (4,654)
- Music (49)
- MySQL (297)
- NCTU (65)
- NetBSD (7)
- Network (3,294)
- OpenBSD (8)
- Opera (26)
- OS (392)
- P2P (132)
- Photo (72)
- Political (124)
- PostgreSQL (41)
- Privacy (13)
- Programming (783)
- Recreation (537)
- RSS (79)
- Safari (38)
- Science (102)
- Search Engine (181)
- Security (1,063)
- Service (64)
- SMS (10)
- Social (220)
- Software (2,379)
- Spam (108)
- Sport (10)
- Telephone (118)
- Television (63)
- Usenet (15)
- Vim (14)
- VPN (19)
- Wiki (48)
- Windows (74)
- WWW (1,639)
Blogroll
Meta
Tag Archives: ssd
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
Amazon EC2 推出 I3 系列機器
Amazon EC2 推出使用 NVMe SSD 的機器，I3 系列：「Now Available – I3 Instances for Demanding, I/O Intensive Applications」。 以東京區的價錢來看，r4.16xlarge 與 i3.16xlarge 都是 64 vCPU 與 488GB RAM。不一樣的地方只有兩個： 第一個是 r4 只有 195 vCPU，而 i3 有 200 vCPU，快了一些。 第二個是 i3 多了 8 個 1900 … Continue reading
Swap 對 InnoDB 的影響
Percona 的老大拿 5.7 版做實驗，確認 swap 對 InnoDB 的影響：「The Impact of Swapping on MySQL Performance」。 測試的機器是 32GB RAM，作業系統 (以及 swap) 裝在已經有點年紀的 Intel 520 SSD 上，而 MySQL 則是裝在 Intel 750 NVMe 上。透過對 innodb_buffer_pool 的調整來看情況。 可以看到設為 24GB (記憶體 75% 的量) 時很穩定的在 44K QPS … Continue reading
InnoDB 的 buffer pool preload 功能
Percona 的人討論了 InnoDB 提供的 buffer pool preload 功能：「Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7」。 就如同他所講的，因為硬體設備的進步 (主要是 SSD 的興起)，而導致 preload 的需求已經沒以前重要了： Frankly, time has reduced the need for this feature. Five years ago, we would typically store databases … Continue reading
AWS 的 General Purpose SSD (gp2) 可以看到 burst I/O 的 credit 數字了
AWS 宣佈把 gp2 的 I/O burst credit 數字給量化了：「New – Burst Balance Metric for EC2’s General Purpose SSD (gp2) Volumes」。 gp2 最小的也可以衝到 3000 IOPS，另外可以累積 5.4M credits： Each volume can accumulate up to 5.4 million credits, and they can be spent at … Continue reading
Firefox 的大量寫入對 SSD 的影響
在「Firefox is eating your SSD - here is how to fix it」這邊講到 Firefox 寫入對 SSD 的影響，先引用文章裡的解法： After some digging, I found out that this behavior is controlled by a parameter that you can access through typing “about:config” in the address … Continue reading
PostgreSQL 上，直接將 SSD 的內容送到 GPU 上，加速讀取速度
在 PostgreSQL 上針對讀取檔案到 GPU 上的成果：「GpuScan + SSD-to-GPU Direct DMA」(日文版)、「(EN) GpuScan + SSD-to-GPU Direct DMA」(英文版)。 主要的原因在於雖然已經有 PGStorm 讓 PostgreSQL 把運算丟到 GPU 上加速，但從 disk 讀到 GPU 這段還是有改善的空間： PG-Strom that is an extension of PostgreSQL to off-load multiple SQL workloads on GPU devices, … Continue reading
Lenovo 開始出 Microsoft-only 機了，其他的 OS 都會被鎖住不能用
有人在 Reddit 上抱怨買了一台 Lenovo 的機器卻不能裝 Linux，因為會抓不到硬碟：「Warning: Microsoft Signature PC program now requires that you can't run Linux. Lenovo's recent Ultrabooks among affected systems.」，官方回覆是： This system has a Signature Edition of Windows 10 Home installed. It is locked per our agreement … Continue reading
MySQL 5.7 中 InnoDB 的 innodb_page_size 在 SSD 硬碟上對效能的巨大影響
在 Percona 的「Small innodb_page_size as a performance boost for SSD」這篇文章裡提到了 MySQL 5.7 的 innodb_page_size 在 SSD 上對效能的差異，主要是這張圖的解釋： 先講一下標示的部份，有三個產品線 (都是 Samsung 的 SSD)，中間的 sam850 是消費級的 SSD 硬碟 (所以不是本次重點)，而 sam863 是企業級 SATA SSD，pm1725 則是企業級 PCI-e SSD。下方的 BP 指的是 Buffer Pool 大小，單位是 GB。左邊是速度，數字愈大愈好。 … Continue reading
DigitalOcean 也推出類似於 Amazon EBS 的東西了：Block Storage
DigitalOcean 也提供類似 Amazon EBS 的服務了：「Block Storage: More Space to Scale」。 只提供 SSD 型態的 Block Storage，價位跟 Amazon EBS 類似，USD$0.1/GB/month。有幾個限制，一個是服務的地區目前只有 NYC1 與 SFO2，下一個會是 FRA1： You can create Block Storage volumes right now in NYC1 and our new SFO2 region. FRA1 is next … Continue reading