還好即時發現，差點撐不過今天晚上 -_-
簡單先找出最吃 CPU resource 的 SQL query，針對他的 WHERE 條件加上適當的 Index 後：
這樣就爭取到調整的時間了...
Recent Comments
Archives
- October 2017 (54)
- September 2017 (60)
- 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 (453)
- BBS (22)
- Blog (252)
- Book (31)
- Bridge (1)
- Browser (535)
- Cassandra (2)
- CDN (191)
- Cloud (608)
- CMS (58)
- Comic (19)
- Computer (4,584)
- Computer and Network Center (33)
- CSS (71)
- Database (433)
- DNS (137)
- Editor (27)
- Financial (93)
- Firefox (234)
- Food (14)
- FreeBSD (139)
- FTP (3)
- Game (67)
- GCP (8)
- Go (2)
- GoogleChrome (170)
- Hardware (396)
- IE (99)
- Joke (159)
- Lab (4)
- Library (14)
- Linux (176)
- MacOS (32)
- Mail (121)
- MariaDB (22)
- Movie (37)
- Murmuring (4,726)
- Music (50)
- MySQL (305)
- NCTU (65)
- NetBSD (7)
- Network (3,347)
- OpenBSD (8)
- Opera (26)
- OS (396)
- P2P (134)
- Photo (74)
- Political (131)
- PostgreSQL (44)
- Privacy (30)
- Programming (797)
- Recreation (545)
- RSS (80)
- Safari (38)
- Science (103)
- Search Engine (181)
- Security (1,090)
- Service (88)
- SMS (10)
- Social (227)
- Software (2,418)
- Spam (108)
- Sport (10)
- Telephone (125)
- Television (65)
- Usenet (15)
- Vim (15)
- VPN (21)
- Wiki (48)
- Windows (75)
- WWW (1,659)
Blogroll
Meta