COSCUP 2012 - MySQL System Stability

Speaker: Gea-Suan Lin (@gslin), KKBOX Inc.
Topic: MySQL System Stability
Conference: COSCUP 2012 (in Taipei, Taiwan)

This is live slide.

Transcript

1. MySQL System Stability
   Gea-Suan Lin @gslin
   KKBOX Inc.
   

   View Slide

2. 真正的投影片
   星期五已經放出來了...
   

   View Slide

3. https://speakerdeck.com/
   u/gslin/p/mysql-system-
   stability
   

   View Slide

4. bit.ly/QO2TMo
   (第二個是英文字母 O)
   

   View Slide

5. View Slide

6. 接下來應該是
   Q&A 時間...
   

   View Slide

7. 在 Q&A 之前...
   

   View Slide

8. 工商服務時間
   Gea-Suan Lin @gslin
   KKBOX Inc.
   

   View Slide

9. a.k.a.
   “人力銀行履歷甘苦談”
   

   View Slide

10. 昨天睡的太開心
    沒報到 Lightning Talk
    

    View Slide

11. 所以在自己的
    Session 上講...
    

    View Slide

12. 工作經歷 != 工作經驗
    

    View Slide

13. Interview
    需要有鑑別力的問題
    

    View Slide

14. 第⼀一題
    

    View Slide

15. for
    Programmer
    

    View Slide

16. “最熟悉的程式語言是
    哪個啊”
    

    View Slide

17. “C”
    

    View Slide

18. “那，白板上來個
    Hello World 吧”
    

    View Slide

19. printf(“Hello, word”);
    

    View Slide

20. “這程式看起來是不是
    哪裡怪怪的”
    

    View Slide

21. 30 秒過去...
    

    View Slide

22. “喔喔我知道...”
    

    View Slide

23. printf(“Hello, word\n”);
    

    View Slide

24. “...”
    

    View Slide

25. (另⼀一位面試者)
    

    View Slide

26. “最熟悉的程式語言是
    哪個啊”
    

    View Slide

27. “C++”
    

    View Slide

28. “那，白板上來個
    Hello World 吧”
    

    View Slide

29. cout >> “Hello world”;
    

    View Slide

30. “這程式看起來是不是
    哪裡怪怪的”
    

    View Slide

31. 30 秒過去...
    

    View Slide

32. “喔喔我知道...”
    

    View Slide

33. cout >> “Hello world\n”;
    

    View Slide

34. “這程式... 是不是還有
    可以修正的地方？”
    

    View Slide

35. 30 秒過去...
    

    View Slide

36. “喔喔我知道...”
    

    View Slide

37. cout >> “Hello, world\n”;
    

    View Slide

38. “...”
    

    View Slide

39. 第三題
    

    View Slide

40. for
    Network
    

    View Slide

41. (翻履歷)
    

    View Slide

42. “有 xxxx (某網路證照)？”
    

    View Slide

43. “對”
    

    View Slide

44. (白板寫上 168.95.1.1)
    

    View Slide

45. (轉頭過去問面試者)
    

    View Slide

46. “這是什麼”
    

    View Slide

47. “看起來是個 IP”
    

    View Slide

48. (淡定)
    “嗯，是個 IP”
    

    View Slide

49. (繼續寫白板)
    

    View Slide

50. 168.95.1.1
    168.95.192.1
    請給我⼀一個 Netmask，使得兩
    個 IP 在同⼀一個 Network 內
    

    View Slide

51. 遇過 n 種答案
    

    View Slide

52. “255.255.0.0”
    (直觀答案)
    

    View Slide

53. “0.0.0.0”
    (萬用答案)
    

    View Slide

54. “168.95.0.1”
    “...”
    (AND 運算？)
    

    View Slide

55. “192.0.0.255”
    “...”
    (這怎麼算的)
    

    View Slide

56. 第四題
    

    View Slide

57. for
    Network
    

    View Slide

58. “解釋什麼是 NAT”
    

    View Slide

59. “blah blah blah...”
    (大致正確)
    

    View Slide

60. “解釋什麼是 NAT64”
    

    View Slide

61. “支援 64bits 的 NAT”
    

    View Slide

62. (面試官在面試者前崩潰)
    

    View Slide

63. We’re hiring !
    (快來救我)
    

    View Slide

64. 外面有 KKBOX 的
    Booth 可以參觀
    

    View Slide

65. View Slide

66. 下午會在外面跟大家聊天 &
    看人吞布丁^W交換名片
    

    View Slide

67. 回到 Q&A 時間
    

    View Slide

68. MySQL System Stability
    Gea-Suan Lin @gslin
    KKBOX Inc.
    

    View Slide