????MySQL????????????????????????????????????????????ó??????????????MySQL???????????????????101??????????MySQL???????ɡ??Щ???????????????????????????Щ?·??????????????????????????????????????MySQL????????????ɡ?
????MySQL ????????????????????:
????1. ??????????????????????InnoDB?????????????——??????з?????????????????????з????????
????2. ?????д?????????Swap???????? – ????????????????????????????
????3. ?????????RAM?????RAM??????洢??????
????4. ???????RAID?????Redundant Arrays of Inexpensive Disks???????????У? – ????RAID10??????
????5. ????RAID5????????洢?????????????洢???????洢????????? – ???????????????У???????????????
????6. ???????????????????????????????????????????????? – ?????????д????????????????????
????7. ??MySQL????????????????????????????? – ????????????????ж?д?????????????????????
????8. ?????????????????????
????9. ????????????
????10. ???SAS????? Serial Attached SCSI????????????SCSI??????SATA?????SATA??????????????
????11. ??С????? ?? ????????????????RAID???????????
????12. ???????????????RAID????????
????13. ?????????????????С?
????14. ??????????????ù??IO?? (?????????????)  – ??Щ???????????κ??????????????2GB/s??д??????
????15. ??Linux??????swappiness????0 – ???????????????????????????????????????????????????????
????16. ??????????????  noatime ?? nodirtime ????????? – ?????????·???????????????????
????17. ??? XFS ????? – ????ext3??????С???????????????????????? ????ext3 ???????MySQL???????????
????18. ???? XFS ???????????????? – ????????????
????19. ?? Linux ???У? ??? NOOP ???? DEADLINE IO ?????????? – ? NOOP ?? DEADLINE????????????????? CFQ ?? ANTICIPATORY ?????????? ??÷??????
????20. ???64λ??????? – ????MySQL?????и?????????????á?
????21. ???????????δ????????????????? – ??????????á?
????22. ?????MySQL??host?????MySQL host??????hosts????? – ???DNS?????
????23. ?????????????MySQL???? – ??????????????????б???????
????24. ????????????MySQL – ???????????????????????????????CPU?????
????MySQL ????:
????25. ??д???????? innodb_flush_method=O_DIRECT ??????????塣
????26. ??????? O_DIRECT ?? EXT3 ????? – ?????л??????д????
????27. ???????? innodb_buffer_pool_size ?????????? InnoDB ??????????– ???????ж????
????28. ????? innodb_log_file_size ??????????? ??????????????и????????? – ??????????????????????????????????????????????
????29. ??????? innodb_thread_concurrency ?? thread_concurrency ????– ??2????????????
????30. ?????????С???????? max_connections ???? – ??????????t?RAM??????MySQL????
????31. ???? thread_cache ??????????????????? 16 – ????????????????
????32. ???skip-name-resolve???? – ??? DNS ?????
????33.????????????????????????????????????仯???????????ò?????檔??????????????????????仯???????ò???????????е??????
????34.????temp_table_size???????д?????
????35.????max_heap_table_size???????д?????
????36.?????sort_buffer_size?????????????????????潫??????
????37.????key_read_requests??key_reads???????key_buffer???С??????????key_read_requests????key_reads?????????????Ч?????key_buffer
????38.??innodb_flush_log_at_trx_commit?????0????????????????????????????????1???????????????????????????????????????????????
????39.???????????????????????????????????????????????????????￡?????????????????
????MySQL?????:
????40. ???????????????????
????41. ??????鵵 – ?????????з?????????????
????42. ?????????????????.
????43. ???????????????????????.
????44. ????????BLOB???????? – ????????????????????.
????45. UTF 8??UTF16??????latin1???Ч??.
????46. ?н????????????.
????47. ????????????????? – ????????????????.
????48. ????????????????????.
????49. ??????????????????????????У??????????С?????.
????50. ???????????????????????????BLOB / TEXT??????????BLOB / TEXT???????????????????.
????51.????????????.
????52. ??????дInnoDB?????.
????53. ????????????????????????????????????????????????.
????54. ?????????????ò????洢????.
????55. ??ù鵵?洢??????????????-???????Ч??д??.
????56.  ??????洢????棨memcache?????????MySQL?? – ???????????????????????????????????????д??MySQL?????????.
????57.?洢???????????????VARCHAR??????CHAR – ?????????????????CHAR????VARCHAR??????????UTF8????????.
????58. ??????????仯 – ???С??仯???????о??????.
????59.??????????в???????????????????仯.
????60. ?????????????????????е???????????????????????.
????61. ???????MySQL??configs??????.
????62.?????????????????MySQL???????.