{"id":226,"date":"2021-01-19T05:55:36","date_gmt":"2021-01-19T03:55:36","guid":{"rendered":"https:\/\/dlshad.net\/?p=226"},"modified":"2021-01-19T05:56:08","modified_gmt":"2021-01-19T03:56:08","slug":"%d9%83%d9%8a%d9%81-%d8%aa%d8%ba%d9%84%d8%a8%d8%aa-%d8%b9%d9%84%d9%89-%d9%85%d8%b4%d9%83%d9%84%d8%a9-%d8%a7%d9%84%d9%80-cpu-100-%d9%85%d8%b9-%d8%b3%d9%8a%d8%b1%d9%81%d8%b1-mysql%d8%9f","status":"publish","type":"post","link":"https:\/\/dlshad.net\/%d9%83%d9%8a%d9%81-%d8%aa%d8%ba%d9%84%d8%a8%d8%aa-%d8%b9%d9%84%d9%89-%d9%85%d8%b4%d9%83%d9%84%d8%a9-%d8%a7%d9%84%d9%80-cpu-100-%d9%85%d8%b9-%d8%b3%d9%8a%d8%b1%d9%81%d8%b1-mysql%d8%9f\/","title":{"rendered":"\u0643\u064a\u0641 \u062a\u063a\u0644\u0628\u062a \u0639\u0644\u0649 \u0645\u0634\u0643\u0644\u0629 \u0627\u0644\u0640 CPU = 100% \u0645\u0639 \u0633\u064a\u0631\u0641\u0631 MySQL\u061f"},"content":{"rendered":"\n
\u0641\u064a \u0639\u0646\u062f\u064a \u062f\u0627\u062a\u0627 \u0628\u064a\u0632 MySQL \u062d\u062c\u0645\u0647\u0627 \u062a\u0642\u0631\u064a\u0628\u0627\u064b 12 \u063a\u064a\u063a\u0627 \u0628\u0627\u064a\u062a, \u0647\u064a \u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u062a\u0633\u062a\u062e\u062f\u0645 InnoDB \u0644\u062d\u0641\u0638 \u0627\u0644\u062f\u0627\u062a\u0627. \u0627\u0644\u0640 IO \u0639 \u0647\u064a \u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0639\u0627\u0644\u064a \u0643\u062a\u064a\u0631, \u0645\u0645\u0643\u0646 \u064a\u0648\u0635\u0644 \u0644\u0640 5000 \u0628\u0627\u0644\u062b\u0627\u0646\u064a\u0629 \u0628\u0628\u0639\u0636 \u0627\u0644\u0623\u062d\u064a\u0627\u0646. \u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0645\u0648\u062c\u0648\u062f\u0629 \u0639 Dedicated server \u0639\u0644\u064a\u0647 \u0645\u0639\u0627\u0644\u062c Intel i9 octa-core \u0645\u0639 128 GB DDR4 Ram.<\/p>\n\n\n\n
\u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0639\u0645 \u062a\u0643\u0628\u0631 \u0643\u0644 \u064a\u0648\u0645 \u0648 \u0627\u0644\u062a\u0631\u0627\u0641\u064a\u0643 \u0639 \u0627\u0644\u0640 Front end \u0644\u0644\u062a\u0637\u0628\u064a\u0642 \u0627\u0644\u064a \u0639\u0645 \u062a\u0634\u063a\u0644\u0647 \u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0639\u0645 \u064a\u0632\u064a\u062f, \u0647\u0627\u0644\u0634\u064a \u062e\u0644\u0627\u0646\u064a \u0627\u0646\u0642\u0644\u0647\u0627 \u0645\u0646 \u0633\u064a\u0631\u0641\u0631 \u0644\u0633\u064a\u0631\u0641\u0631 \u0627\u0643\u0628\u0631 \u0645\u0624\u062e\u0631\u0627\u064b \u0644\u062d\u062a\u0649 \u062a\u0642\u062f\u0631 \u062a\u0644\u062d\u0642 \u0627\u0644\u0640 Load.<\/p>\n\n\n\n
\u0645\u0646 \u0641\u062a\u0631\u0629 \u0642\u0631\u0631\u062a \u0627\u0646\u0648 \u0645\u0627 \u0639\u0627\u062f \u0641\u064a\u0646\u064a \u0636\u0644 \u0647\u064a\u0643\u060c \u062e\u0635\u0648\u0635\u064a \u0627\u0646\u0648 \u0641\u064a \u0639\u0646\u062f\u064a Replica \u0648 \u0627\u0644\u0627\u0647\u062a\u0645\u0627\u0645 \u0628\u0633\u064a\u0631\u0641\u0631\u064a\u0646 \u0628\u0627\u0644\u0634\u0643\u0644 \u0648 \u0628\u0627\u0644\u062d\u062c\u0645 \u0647\u0627\u062f \u0639\u0645 \u064a\u0627\u062e\u062f \u0648\u0642\u062a \u0648 \u062c\u0647\u062f \u0643\u062a\u064a\u0631, \u0641\u0642\u0631\u0631\u062a \u0627\u0646\u062a\u0642\u0644 \u0644\u0644\u0643\u0644\u0627\u0648\u062f \u0648 \u0627\u0633\u062a\u062e\u062f\u0645 IaaS \u0644\u062a\u0634\u063a\u0644 \u0627\u0644\u0640 MySQL, \u0627\u0644\u062e\u064a\u0627\u0631 \u0643\u0627\u0646 \u0643\u0627\u0631\u062b\u064a \u0645\u0627\u062f\u064a\u0627\u064b, \u0627\u0644\u0643\u0644\u0641\u0629 \u0627\u0631\u062a\u0641\u0639\u062a \u0639 \u0627\u0644\u0623\u0642\u0644 4 \u0627\u0636\u0639\u0627\u0641, \u0648 \u0647\u0627\u0644\u0634\u064a \u062f\u0641\u0639\u0646\u064a \u0627\u0646\u064a \u0627\u0631\u062c\u0639 \u0644\u0644\u0633\u064a\u0631\u0641\u0631\u0627\u062a \u0627\u0644\u0645\u0639\u062f\u0646\u064a\u0629.<\/p>\n\n\n\n
\u0642\u0636\u064a\u062a \u0641\u062a\u0631\u0629 \u0645\u0646\u064a\u062d\u0629 \u0648 \u0627\u0646\u0627 \u0639\u0645 \u0627\u0639\u0645\u0644 Debug \u0644\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0644\u062d\u062a\u0649 \u0627\u0641\u0647\u0645 \u062a\u0645\u0627\u0645\u0627\u064b \u0634\u0648 \u0627\u0644\u064a \u0639\u0645 \u064a\u062e\u0644\u064a \u0627\u0644\u0640 CPU = 100% \u0637\u0648\u0644 \u0627\u0644\u0648\u0642\u062a, \u0648 \u0634\u0641\u062a \u0627\u0646\u0648 \u0641\u0643\u0631\u0629 \u062a\u0648\u0633\u0639\u0629 \u0627\u0644\u0640 Hardware resources \u0644\u0647\u0627\u0644\u062f\u0627\u062a\u0627 \u0628\u064a\u0632 \u0643\u0640 \u062d\u0644 \u0627\u0628\u062f\u0627\u064b \u0645\u0627\u0646\u0648 \u062e\u064a\u0627\u0631 \u062c\u064a\u062f \u0648 \u0645\u0633\u062a\u0642\u0631, \u0627\u0644\u0645\u0647\u0645 \u0642\u0636\u064a\u062a \u0623\u064a\u0627\u0645 \u0639\u0645 \u0627\u0634\u062a\u063a\u0644 \u0639 \u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0648 \u0642\u062f\u0631\u062a \u0646\u0632\u0644 \u0627\u0644\u0640 CPU load \u0644\u0640 10% \u0639\u0628\u0631 \u0627\u062a\u0628\u0627\u0639 \u0627\u0644\u0637\u0631\u064a\u0642\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629:<\/p>\n\n\n\n