{"id":3232,"date":"2026-04-28T11:10:42","date_gmt":"2026-04-28T11:10:42","guid":{"rendered":"https:\/\/maram.iq\/blogs\/?p=3232"},"modified":"2026-04-28T15:56:58","modified_gmt":"2026-04-28T12:56:58","slug":"%d8%aa%d8%ad%d8%b3%d9%8a%d9%86-mysql","status":"publish","type":"post","link":"https:\/\/maram.iq\/blogs\/%d8%aa%d8%ad%d8%b3%d9%8a%d9%86-mysql\/","title":{"rendered":"\u062a\u062d\u0633\u064a\u0646 MySQL 2026: 20 \u0625\u0639\u062f\u0627\u062f \u0644\u0632\u064a\u0627\u062f\u0629 \u0623\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a 300%"},"content":{"rendered":"\n<div style=\"background:linear-gradient(135deg,#0f172a,#065f46);color:#fff;padding:2.5rem;border-radius:16px;margin-bottom:2rem;text-align:center\">\n<p style=\"font-size:3rem;margin:0 0 .5rem\">\u26a1<\/p>\n<h2 style=\"color:#fff!important;font-size:1.5rem;margin:0 0 .5rem\" id=\"section-1\">\u062a\u062d\u0633\u064a\u0646 MySQL 2026: 20 \u0625\u0639\u062f\u0627\u062f \u0644\u0632\u064a\u0627\u062f\u0629 \u0623\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a 300%<\/h2>\n<p style=\"margin:0\">\u0645\u0646 \u0636\u0628\u0637 innodb_buffer_pool \u0625\u0644\u0649 \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629\u060c \u0627\u062c\u0639\u0644 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u062a\u0637\u064a\u0631<\/p>\n<\/div>\n\n\n\n<p>MySQL \u0647\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0623\u0643\u062b\u0631 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u064b\u0627 \u0641\u064a \u0627\u0644\u0639\u0627\u0644\u0645. \u062a\u0634\u063a\u0651\u0644 \u0648\u0648\u0631\u062f\u0628\u0631\u064a\u0633\u060c WooCommerce\u060c Magento\u060c \u0622\u0644\u0627\u0641 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a. \u0644\u0643\u0646 \u0641\u064a \u0645\u0639\u0638\u0645 \u0627\u0644\u0633\u064a\u0631\u0641\u0631\u0627\u062a\u060c MySQL \u062a\u0639\u0645\u0644 \u0628\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0645\u0635\u0645\u0645\u0629 \u0644\u0623\u0646\u0638\u0645\u0629 \u0628\u0623\u0642\u0644 \u0645\u0646 1GB \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629. \u0627\u0644\u0646\u062a\u064a\u062c\u0629: \u0623\u062f\u0627\u0621 \u0628\u0639\u064a\u062f \u062c\u062f\u064b\u0627 \u0639\u0646 \u0625\u0645\u0643\u0627\u0646\u064a\u0627\u062a \u0627\u0644\u0633\u064a\u0631\u0641\u0631 \u0627\u0644\u0641\u0639\u0644\u064a\u0629. <strong>\u062a\u062d\u0633\u064a\u0646 MySQL<\/strong> \u0644\u064a\u0633 \u0639\u0645\u0644\u064a\u0629 \u0645\u0639\u0642\u062f\u0629 \u0643\u0645\u0627 \u064a\u0638\u0646 \u0627\u0644\u0628\u0639\u0636\u060c \u0628\u0644 \u0633\u0644\u0633\u0644\u0629 \u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0645\u0646\u0637\u0642\u064a\u0629 \u062a\u062a\u0641\u0627\u0639\u0644 \u0645\u0639 \u0645\u0648\u0627\u0631\u062f \u0633\u064a\u0631\u0641\u0631\u0643. \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u062f\u0644\u064a\u0644\u060c \u0633\u0646\u063a\u0637\u064a 20 \u0625\u0639\u062f\u0627\u062f\u064b\u0627 \u062a\u062c\u0639\u0644 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u0623\u0633\u0631\u0639 \u0628\u0646\u0633\u0628\u0629 \u0642\u062f \u062a\u0635\u0644 \u0625\u0644\u0649 300%.<\/p>\n\n\n\n<div class=\"table-of-contents\" style=\"background:#f8fafc;border:1px solid #e2e8f0;border-radius:12px;padding:1.5rem;margin:1.5rem 0;\"><p style=\"font-weight:700;font-size:1.05rem;margin-bottom:.75rem;\">\u0645\u062d\u062a\u0648\u064a\u0627\u062a \u0627\u0644\u0645\u0642\u0627\u0644<\/p><ul style=\"list-style:none;padding:0;margin:0;\"><li><a href=\"#section-2\">\u0644\u0645\u0627\u0630\u0627 \u062a\u062d\u062a\u0627\u062c \u062a\u062d\u0633\u064a\u0646 MySQL \u0641\u064a 2026<\/a><\/li><li><a href=\"#section-3\">\u062a\u062d\u0644\u064a\u0644 \u0623\u062f\u0627\u0621 MySQL \u0627\u0644\u062d\u0627\u0644\u064a (mysqltuner)<\/a><\/li><li><a href=\"#section-4\">\u062a\u062d\u0633\u064a\u0646 MySQL: \u0636\u0628\u0637 innodb_buffer_pool_size<\/a><\/li><li><a href=\"#section-5\">\u062a\u062d\u0633\u064a\u0646 MySQL: query_cache_size \u0648 key_buffer_size<\/a><\/li><li><a href=\"#section-6\">\u062a\u062d\u0633\u064a\u0646 MySQL: max_connections \u0648 thread_cache_size<\/a><\/li><li><a href=\"#section-7\">\u062a\u062d\u0633\u064a\u0646 MySQL: tmp_table_size \u0648 sort_buffer_size<\/a><\/li><li><a href=\"#section-8\">\u0627\u062e\u062a\u064a\u0627\u0631 \u0645\u062d\u0631\u0643 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0645\u0646\u0627\u0633\u0628<\/a><\/li><li><a href=\"#section-9\">\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 (Indexes) \u0641\u064a MySQL<\/a><\/li><li><a href=\"#section-10\">\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629<\/a><\/li><li><a href=\"#section-11\">\u062a\u062d\u0633\u064a\u0646 MySQL \u0644\u0640 WordPress \u0648 WooCommerce<\/a><\/li><li><a href=\"#section-12\">\u062a\u062d\u0633\u064a\u0646 MySQL \u0639\u0644\u0649 VPS \u0645\u0642\u0627\u0628\u0644 Shared Hosting<\/a><\/li><li><a href=\"#section-13\">\u0636\u0628\u0637 \u0625\u0639\u062f\u0627\u062f\u0627\u062a my.cnf \u0644\u0644\u0623\u062f\u0627\u0621<\/a><\/li><li><a href=\"#section-14\">\u0645\u0631\u0627\u0642\u0628\u0629 MySQL \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Percona Monitoring<\/a><\/li><li><a href=\"#section-15\">\u0623\u0641\u0636\u0644 \u0645\u0645\u0627\u0631\u0633\u0627\u062a \u062a\u062d\u0633\u064a\u0646 MySQL<\/a><\/li><li><a href=\"#section-16\">\u0627\u0644\u062e\u0644\u0627\u0635\u0629<\/a><\/li><\/ul><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-2\">\u0644\u0645\u0627\u0630\u0627 \u062a\u062d\u062a\u0627\u062c \u062a\u062d\u0633\u064a\u0646 MySQL \u0641\u064a 2026<\/h2>\n\n\n\n<p>\u0641\u064a 2026\u060c \u0623\u0635\u0628\u062d \u0627\u0644\u0645\u062a\u0648\u0633\u0637 \u0627\u0644\u0639\u0627\u0644\u0645\u064a \u0644\u0627\u0633\u062a\u062c\u0627\u0628\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0642\u0644 \u0645\u0646 50 \u0645\u064a\u0644\u064a \u062b\u0627\u0646\u064a\u0629 \u0644\u0643\u0644 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0641\u064a \u0627\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0645\u0646\u0627\u0641\u0633\u0629. \u0644\u0648 \u0643\u0627\u0646 \u0645\u062a\u0648\u0633\u0637 \u0627\u0633\u062a\u062c\u0627\u0628\u0629 \u0642\u0627\u0639\u062f\u062a\u0643 \u0623\u0643\u0628\u0631\u060c \u0641\u0623\u0646\u062a \u062a\u062e\u0633\u0631 \u0627\u0644\u0645\u0646\u0627\u0641\u0633\u0629 \u0641\u064a \u0643\u0644 \u0645\u0646 \u062a\u062c\u0631\u0628\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0648 SEO. \u0627\u0644\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u0637\u064a\u0626\u0629 \u062a\u062a\u0631\u062a\u0628 \u0639\u0644\u064a\u0647\u0627 \u0635\u0641\u062d\u0627\u062a \u0628\u0637\u064a\u0626\u0629\u060c \u0627\u0633\u062a\u0647\u0644\u0627\u0643 \u0623\u0643\u0628\u0631 \u0644\u0644\u0640 CPU\u060c \u0648\u0623\u062d\u064a\u0627\u0646\u064b\u0627 \u0627\u0646\u0647\u064a\u0627\u0631 \u0627\u0644\u0645\u0648\u0642\u0639 \u062a\u062d\u062a \u0627\u0644\u0636\u063a\u0637.<\/p>\n\n\n\n<p>\u0627\u0644\u0645\u062b\u064a\u0631 \u0641\u064a \u0627\u0644\u0623\u0645\u0631: \u062a\u062d\u0633\u064a\u0646 MySQL \u0644\u0627 \u064a\u062d\u062a\u0627\u062c \u0639\u0627\u062f\u0629 \u062a\u0631\u0642\u064a\u0629 \u0627\u0644\u0623\u062c\u0647\u0632\u0629. \u0643\u062b\u064a\u0631\u064b\u0627 \u0645\u0627 \u0631\u0623\u064a\u062a \u0633\u064a\u0631\u0641\u0631\u0627\u062a \u0628\u0640 16GB \u0630\u0627\u0643\u0631\u0629 \u062a\u0639\u0645\u0644 \u0628\u0623\u062f\u0627\u0621 \u0633\u064a\u0631\u0641\u0631 \u0628\u0640 2GB\u060c \u0641\u0642\u0637 \u0644\u0623\u0646 \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0644\u0645 \u062a\u064f\u0636\u0628\u0637 \u0623\u0628\u062f\u064b\u0627. \u062a\u062e\u0635\u064a\u0635 70-80% \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0644\u0640 MySQL \u0641\u064a \u0642\u0648\u0627\u0639\u062f \u0643\u0628\u064a\u0631\u0629 \u064a\u0639\u0637\u064a \u0642\u0641\u0632\u0629 \u0647\u0627\u0626\u0644\u0629 \u0641\u064a \u0627\u0644\u0623\u062f\u0627\u0621\u060c \u0623\u062d\u064a\u0627\u0646\u064b\u0627 \u062a\u0635\u0644 \u0625\u0644\u0649 10x.<\/p>\n\n\n\n<p><strong>\u062a\u062d\u0633\u064a\u0646 MySQL<\/strong> \u0644\u0647 \u062a\u0623\u062b\u064a\u0631 \u0645\u0631\u0643\u0651\u0628 \u0639\u0644\u0649 \u0643\u0644 \u0627\u0644\u0645\u0646\u0638\u0648\u0645\u0629. \u0639\u0646\u062f\u0645\u0627 \u062a\u0643\u0648\u0646 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a\u0643 \u0633\u0631\u064a\u0639\u0629\u060c \u064a\u0642\u0644 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 PHP-FPM\u060c \u064a\u0642\u0644 \u0627\u062d\u062a\u0644\u0627\u0644 \u0627\u0644\u0640 CPU\u060c \u064a\u0646\u062e\u0641\u0636 \u0627\u0633\u062a\u0647\u0644\u0627\u0643 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0641\u064a \u0643\u0644 \u0639\u0645\u0644\u064a\u0629\u060c \u0648\u062a\u0631\u062a\u0641\u0639 \u0642\u062f\u0631\u0629 \u0627\u0644\u0633\u064a\u0631\u0641\u0631 \u0627\u0644\u0643\u0644\u064a\u0629 \u0639\u0644\u0649 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0637\u0644\u0628\u0627\u062a \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u0629. \u0647\u0630\u0627 \u064a\u0639\u0646\u064a \u0623\u0646 \u0633\u064a\u0631\u0641\u0631 VPS \u0635\u063a\u064a\u0631 \u064a\u0633\u062a\u0637\u064a\u0639 \u062e\u062f\u0645\u0629 \u0639\u062f\u062f \u0632\u0648\u0627\u0631 \u064a\u0641\u0648\u0642 \u0645\u0627 \u064a\u0642\u062f\u0631 \u0639\u0644\u064a\u0647 VPS \u0623\u0643\u0628\u0631 \u0628\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u062a\u0642\u0644\u064a\u0644 \u0648\u0642\u062a \u062a\u062d\u0645\u064a\u0644 \u0627\u0644\u0635\u0641\u062d\u0627\u062a \u0628\u0646\u0633\u0628\u0629 40-70%.<\/li><li>\u062a\u0642\u0644\u064a\u0644 \u0627\u0633\u062a\u0647\u0644\u0627\u0643 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0648 CPU.<\/li><li>\u0632\u064a\u0627\u062f\u0629 \u0642\u062f\u0631\u0629 \u0627\u0644\u0633\u064a\u0631\u0641\u0631 \u0639\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646.<\/li><li>\u062a\u062d\u0633\u064a\u0646 Core Web Vitals \u0648\u062a\u0631\u062a\u064a\u0628 SEO.<\/li><li>\u062a\u0623\u062e\u064a\u0631 \u0627\u0644\u062d\u0627\u062c\u0629 \u0644\u062a\u0631\u0642\u064a\u0629 \u0627\u0644\u0627\u0633\u062a\u0636\u0627\u0641\u0629.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-3\">\u062a\u062d\u0644\u064a\u0644 \u0623\u062f\u0627\u0621 MySQL \u0627\u0644\u062d\u0627\u0644\u064a (mysqltuner)<\/h2>\n\n\n\n<p>\u0642\u0628\u0644 \u0623\u064a \u062a\u0639\u062f\u064a\u0644\u060c \u064a\u062c\u0628 \u0623\u0646 \u062a\u0639\u0631\u0641 \u0627\u0644\u0648\u0636\u0639 \u0627\u0644\u062d\u0627\u0644\u064a. \u0627\u0644\u0623\u062f\u0627\u0629 \u0627\u0644\u0630\u0647\u0628\u064a\u0629 \u0644\u0630\u0644\u0643 \u0647\u064a mysqltuner. \u0633\u0643\u0631\u0628\u062a Perl \u064a\u062d\u0644\u0644 \u0625\u0639\u062f\u0627\u062f\u0627\u062a MySQL \u0648\u064a\u0642\u062f\u0645 \u062a\u0648\u0635\u064a\u0627\u062a \u0645\u062e\u0635\u0635\u0629. \u0634\u063a\u0651\u0644\u0647 \u0628\u0639\u062f \u0623\u0646 \u062a\u0643\u0648\u0646 MySQL \u0642\u062f \u0639\u0645\u0644\u062a \u0644\u0645\u062f\u0629 24 \u0633\u0627\u0639\u0629 \u0639\u0644\u0649 \u0627\u0644\u0623\u0642\u0644\u060c \u062d\u062a\u0649 \u062a\u0643\u0648\u0646 \u0627\u0644\u0625\u062d\u0635\u0627\u0626\u064a\u0627\u062a \u0630\u0627\u062a \u0645\u0639\u0646\u0649.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u062a\u062d\u0645\u064a\u0644 \u0648\u062a\u0634\u063a\u064a\u0644 mysqltuner\nwget https:\/\/raw.githubusercontent.com\/major\/MySQLTuner-perl\/master\/mysqltuner.pl\nchmod +x mysqltuner.pl\n.\/mysqltuner.pl\n\n# \u0623\u0648 \u062a\u062b\u0628\u064a\u062a\u0647 \u0643\u062d\u0632\u0645\u0629\napt install mysqltuner    # Debian\/Ubuntu\nyum install mysqltuner    # CentOS\/RHEL\n\n# \u0627\u0644\u0641\u062d\u0635 \u0628\u062d\u0633\u0627\u0628 MySQL\nmysqltuner --user root --pass yourpassword<\/code><\/pre>\n\n\n\n<p>mysqltuner \u064a\u0639\u0637\u064a \u062a\u0642\u0631\u064a\u0631\u064b\u0627 \u0645\u062a\u0639\u062f\u062f \u0627\u0644\u0623\u0642\u0633\u0627\u0645: General Recommendations\u060c Variables to adjust\u060c Storage Engine Statistics\u060c Performance Metrics. \u0631\u0643\u0651\u0632 \u0639\u0644\u0649 \u0627\u0644\u0623\u0642\u0633\u0627\u0645 \u0627\u0644\u062d\u0645\u0631\u0627\u0621 \u0648\u0627\u0644\u0635\u0641\u0631\u0627\u0621\u060c \u0641\u0647\u064a \u062a\u0634\u064a\u0631 \u0625\u0644\u0649 \u0645\u0634\u0627\u0643\u0644 \u0641\u0639\u0644\u064a\u0629. \u0627\u0644\u062a\u0648\u0635\u064a\u0627\u062a \u0627\u0644\u062e\u0636\u0631\u0627\u0621 \u062a\u0639\u0646\u064a \u0623\u0646 \u0627\u0644\u0625\u0639\u062f\u0627\u062f \u062c\u064a\u062f.<\/p>\n\n\n\n<p>\u0623\u062f\u0627\u0629 \u062b\u0627\u0646\u064a\u0629 \u0645\u0641\u064a\u062f\u0629 \u0647\u064a tuning-primer.sh\u060c \u0623\u0628\u0633\u0637 \u0645\u0646 mysqltuner \u0644\u0643\u0646\u0647\u0627 \u062a\u0639\u0637\u064a \u0631\u0624\u064a\u0629 \u0645\u062e\u062a\u0644\u0641\u0629. \u0623\u064a\u0636\u064b\u0627 pt-summary \u0645\u0646 Percona Toolkit \u064a\u0642\u062f\u0645 \u0646\u0638\u0631\u0629 \u0639\u0627\u0645\u0629 \u0633\u0631\u064a\u0639\u0629 \u0639\u0644\u0649 \u062d\u0627\u0644\u0629 \u0627\u0644\u0633\u064a\u0631\u0641\u0631 \u0648 MySQL. \u0627\u0633\u062a\u062e\u062f\u0645 \u0623\u0643\u062b\u0631 \u0645\u0646 \u0623\u062f\u0627\u0629 \u0644\u062a\u062d\u0635\u0644 \u0639\u0644\u0649 \u0631\u0624\u064a\u0629 \u0645\u062a\u0643\u0627\u0645\u0644\u0629.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-4\">\u062a\u062d\u0633\u064a\u0646 MySQL: \u0636\u0628\u0637 innodb_buffer_pool_size<\/h2>\n\n\n\n<p>\u0647\u0630\u0627 \u0627\u0644\u0645\u062a\u063a\u064a\u0631 \u0647\u0648 \u0627\u0644\u0623\u0647\u0645 \u0641\u064a \u0643\u0644 \u0639\u0645\u0644\u064a\u0629 <strong>\u062a\u062d\u0633\u064a\u0646 MySQL<\/strong>. innodb_buffer_pool_size \u064a\u062d\u062f\u062f \u062d\u062c\u0645 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0627\u0644\u0645\u062e\u0635\u0635\u0629 \u0644\u0640 InnoDB \u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u0641\u0647\u0627\u0631\u0633. \u0643\u0644 \u0645\u0627 \u064a\u062f\u062e\u0644 \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0628\u0648\u0644 \u064a\u0635\u0628\u062d \u0645\u062a\u0627\u062d\u064b\u0627 \u0628\u0633\u0631\u0639\u0629 \u0627\u0644\u0630\u0627\u0643\u0631\u0629\u060c \u0644\u0627 \u0628\u0633\u0631\u0639\u0629 \u0627\u0644\u0642\u0631\u0635. \u0627\u0644\u0641\u0631\u0642 \u0647\u0627\u0626\u0644: \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u062a\u0633\u062a\u062c\u064a\u0628 \u0641\u064a \u0646\u0627\u0646\u0648\u062b\u0648\u0627\u0646\u064d\u060c \u0627\u0644\u0642\u0631\u0635 \u0641\u064a \u0645\u064a\u0644\u064a \u062b\u0648\u0627\u0646\u064d.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u0641\u064a \u0645\u0644\u0641 \/etc\/mysql\/my.cnf \u0623\u0648 \/etc\/my.cnf\n[mysqld]\n# \u0639\u0644\u0649 \u0633\u064a\u0631\u0641\u0631 \u0645\u062e\u0635\u0635 \u0644\u0644\u0642\u0627\u0639\u062f\u0629\u060c \u0627\u062c\u0639\u0644\u0647\u0627 70-80% \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629\ninnodb_buffer_pool_size = 12G\n\n# \u0639\u0644\u0649 VPS \u0645\u0634\u062a\u0631\u0643\u060c \u0627\u062c\u0639\u0644\u0647\u0627 50-60% \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629\ninnodb_buffer_pool_size = 4G\n\n# \u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0628\u0648\u0644 \u0625\u0644\u0649 \u0639\u062f\u0629 instances \u0644\u062a\u062d\u0633\u064a\u0646 concurrency\ninnodb_buffer_pool_instances = 8\n# \u0642\u0627\u0639\u062f\u0629 \u0639\u0627\u0645\u0629: 1 instance \u0644\u0643\u0644 1GB\n\n# \u0639\u0631\u0636 \u0627\u0644\u0625\u0639\u062f\u0627\u062f \u0627\u0644\u062d\u0627\u0644\u064a\nmysql -e \"SHOW VARIABLES LIKE 'innodb_buffer_pool_size';\"\n\n# \u0639\u0631\u0636 \u062d\u0627\u0644\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\nmysql -e \"SHOW ENGINE INNODB STATUS\\G\" | grep \"Buffer pool\"<\/code><\/pre>\n\n\n\n<p>\u0644\u062a\u062d\u062f\u064a\u062f \u0627\u0644\u062d\u062c\u0645 \u0627\u0644\u0645\u0646\u0627\u0633\u0628\u060c \u0627\u0646\u0638\u0631 \u0625\u0644\u0649 \u062d\u062c\u0645 \u0628\u064a\u0627\u0646\u0627\u062a\u0643. \u0644\u0648 \u0643\u0627\u0646\u062a \u0642\u0627\u0639\u062f\u062a\u0643 5GB\u060c \u0641\u0640 buffer pool \u0628\u0640 6GB \u064a\u0636\u0645\u0646 \u0623\u0646 \u0643\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062a\u0643\u0648\u0646 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u062f\u0627\u0626\u0645\u064b\u0627. \u0644\u0648 \u0643\u0627\u0646\u062a 50GB\u060c \u0627\u062c\u0639\u0644\u0647 \u0623\u0643\u0628\u0631 \u0645\u0627 \u064a\u0633\u062a\u0637\u064a\u0639 \u0627\u0644\u0633\u064a\u0631\u0641\u0631 \u062a\u062d\u0645\u0644\u0647. \u0627\u0644\u0641\u0627\u0626\u062f\u0629 \u062a\u062a\u0642\u0644\u0635 \u0628\u0639\u062f \u062a\u062c\u0627\u0648\u0632 \u062d\u062c\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0644\u0630\u0627 \u0644\u0627 \u062a\u062e\u0635\u0635 \u0623\u0643\u062b\u0631 \u0645\u0646 \u0627\u0644\u0644\u0627\u0632\u0645.<\/p>\n\n\n\n<p>\u0645\u062a\u063a\u064a\u0631 \u0645\u0647\u0645 \u0622\u062e\u0631: <code>innodb_buffer_pool_chunk_size<\/code>. \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a 128MB. \u0639\u0644\u0649 \u0633\u064a\u0631\u0641\u0631\u0627\u062a \u0643\u0628\u064a\u0631\u0629\u060c 1GB \u064a\u062d\u0633\u0651\u0646 \u0627\u0644\u0623\u062f\u0627\u0621. \u0645\u0639 innodb_buffer_pool_instances \u0648 chunk_size\u060c \u064a\u0642\u0633\u0645 MySQL \u0627\u0644\u0628\u0648\u0644 \u0625\u0644\u0649 \u0623\u062c\u0632\u0627\u0621 \u064a\u062f\u064a\u0631\u0647\u0627 \u0628\u0643\u0641\u0627\u0621\u0629 \u0623\u0639\u0644\u0649.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-5\">\u062a\u062d\u0633\u064a\u0646 MySQL: query_cache_size \u0648 key_buffer_size<\/h2>\n\n\n\n<p>query_cache \u0643\u0627\u0646 \u0645\u0641\u064a\u062f\u064b\u0627 \u0641\u064a MySQL 5.x \u0644\u0643\u0646 MySQL 8 \u0623\u0644\u063a\u0627\u0647 \u062a\u0645\u0627\u0645\u064b\u0627 \u0644\u0645\u0634\u0627\u0643\u0644 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u062a\u064a \u064a\u0633\u0628\u0628\u0647\u0627 \u0639\u0644\u0649 \u0627\u0644\u0623\u0646\u0638\u0645\u0629 \u0627\u0644\u0645\u062a\u0639\u062f\u062f\u0629 \u0627\u0644\u0623\u0646\u0648\u064a\u0629. \u0644\u0648 \u0643\u0646\u062a \u0645\u0627 \u0632\u0644\u062a \u0639\u0644\u0649 MySQL 5.7\u060c \u0627\u0633\u062a\u062e\u062f\u0645\u0647 \u0628\u062d\u0630\u0631. \u0644\u0644\u0645\u062a\u0627\u062c\u0631 \u0627\u0644\u0643\u0628\u064a\u0631\u0629\u060c \u0627\u062a\u0631\u0643\u0647 \u0645\u0639\u0637\u0644\u064b\u0627.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u0641\u064a MySQL 5.7 (\u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0635\u063a\u064a\u0631\u0629 \u0641\u0642\u0637)\n[mysqld]\nquery_cache_type = 1\nquery_cache_size = 64M\nquery_cache_limit = 2M\n\n# \u0641\u064a MySQL 5.7+ \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0643\u0628\u064a\u0631\u0629\u060c \u0639\u0637\u0651\u0644\u0647\nquery_cache_type = 0\nquery_cache_size = 0\n\n# \u0641\u064a MySQL 8.0\u060c \u0627\u0644\u0625\u0639\u062f\u0627\u062f \u0645\u062d\u0630\u0648\u0641 \u0628\u0627\u0644\u0643\u0627\u0645\u0644 \u0648\u0644\u0627 \u062d\u0627\u062c\u0629 \u0644\u0630\u0644\u0643<\/code><\/pre>\n\n\n\n<p>key_buffer_size \u0645\u062e\u0635\u0635 \u0644\u0645\u062d\u0631\u0643 MyISAM. \u0644\u0648 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 InnoDB \u0641\u0642\u0637 (\u0648\u0647\u0648 \u0627\u0644\u0645\u0648\u0635\u0649 \u0628\u0647)\u060c \u0627\u062c\u0639\u0644\u0647 \u0635\u063a\u064a\u0631\u064b\u0627 (32M-64M \u0643\u0627\u0641\u064d \u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0646\u0638\u0627\u0645). \u0644\u0648 \u0644\u062f\u064a\u0643 \u062c\u062f\u0627\u0648\u0644 MyISAM \u0643\u0628\u064a\u0631\u0629\u060c \u062e\u0635\u0635 \u0644\u0647 \u062d\u062c\u0645\u064b\u0627 \u0645\u0633\u0627\u0648\u064a\u064b\u0627 \u0644\u0645\u062c\u0645\u0648\u0639 \u062d\u062c\u0645 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u0641\u064a \u062a\u0644\u0643 \u0627\u0644\u062c\u062f\u0627\u0648\u0644.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\nkey_buffer_size = 64M    # \u0643\u0627\u0641\u064d \u0644\u0645\u0639\u0638\u0645 \u0627\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062d\u062f\u064a\u062b\u0629\n\n# \u0644\u0645\u0639\u0631\u0641\u0629 \u0645\u062f\u0649 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 key_buffer\nSHOW STATUS LIKE 'Key%';\n# Key_read_requests \/ Key_reads = \u0646\u0633\u0628\u0629 \u0627\u0644\u0625\u0635\u0627\u0628\u0629 (\u064a\u062c\u0628 \u0623\u0646 \u062a\u0643\u0648\u0646 &gt;99%)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-6\">\u062a\u062d\u0633\u064a\u0646 MySQL: max_connections \u0648 thread_cache_size<\/h2>\n\n\n\n<p>max_connections \u064a\u062d\u062f\u062f \u0627\u0644\u0639\u062f\u062f \u0627\u0644\u0623\u0642\u0635\u0649 \u0644\u0644\u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u0629. \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 151 \u0645\u0646\u062e\u0641\u0636\u0629 \u062c\u062f\u064b\u0627 \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0646\u0634\u0637\u0629. \u0644\u0643\u0646 \u0631\u0641\u0639\u0647\u0627 \u0628\u0634\u0643\u0644 \u0645\u0641\u0631\u0637 \u064a\u0633\u062a\u0647\u0644\u0643 \u0627\u0644\u0630\u0627\u0643\u0631\u0629\u060c \u0644\u0623\u0646 \u0643\u0644 \u0627\u062a\u0635\u0627\u0644 \u064a\u062d\u062a\u0627\u062c \u0645\u0648\u0627\u0631\u062f. <strong>\u062a\u062d\u0633\u064a\u0646 MySQL<\/strong> \u0627\u0644\u0635\u062d\u064a\u062d \u064a\u062d\u062f\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0628\u0646\u0627\u0621 \u0639\u0644\u0649 \u0639\u062f\u062f \u0639\u0645\u0644\u064a\u0627\u062a PHP-FPM \u0627\u0644\u0645\u062a\u0648\u0642\u0639\u0629 \u0648\u0637\u0628\u064a\u0639\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\n# \u0644\u0645\u0648\u0642\u0639 \u0645\u062a\u0648\u0633\u0637\nmax_connections = 200\n\n# \u0644\u0645\u0648\u0642\u0639 \u0646\u0634\u0637 \u062c\u062f\u064b\u0627\nmax_connections = 500\n\n# Thread cache \u064a\u062d\u0633\u0651\u0646 \u0623\u062f\u0627\u0621 \u0627\u0644\u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0627\u0644\u0645\u062a\u0643\u0631\u0631\u0629\nthread_cache_size = 50\n\n# \u0644\u0631\u0635\u062f \u0639\u062f\u062f \u0627\u0644\u0627\u062a\u0635\u0627\u0644\u0627\u062a\nSHOW STATUS LIKE 'Threads_connected';\nSHOW STATUS LIKE 'Max_used_connections';\n\n# \u0644\u0631\u0635\u062f \u0643\u0641\u0627\u0621\u0629 thread cache\nSHOW STATUS LIKE 'Threads_created';\n# \u0644\u0648 \u0642\u064a\u0645\u062a\u0647\u0627 \u0643\u0628\u064a\u0631\u0629 \u0648\u062a\u0632\u064a\u062f\u060c \u0627\u0631\u0641\u0639 thread_cache_size<\/code><\/pre>\n\n\n\n<p>\u0642\u0627\u0639\u062f\u0629 \u0639\u0627\u0645\u0629: max_connections \u064a\u062c\u0628 \u0623\u0646 \u064a\u0633\u0627\u0648\u064a \u0639\u062f\u062f PHP-FPM workers + \u0647\u0627\u0645\u0634 30%. \u0644\u0648 \u0644\u062f\u064a\u0643 150 worker\u060c \u0627\u062c\u0639\u0644 max_connections = 200. \u0627\u0631\u0641\u0639\u0647\u0627 \u0641\u0642\u0637 \u0625\u0630\u0627 \u0631\u0623\u064a\u062a \u0642\u064a\u0645\u0629 Max_used_connections \u0642\u0631\u064a\u0628\u0629 \u0645\u0646 max_connections \u0641\u064a \u0633\u0627\u0639\u0627\u062a \u0627\u0644\u0630\u0631\u0648\u0629.<\/p>\n\n\n\n<div style=\"border-right:4px solid #7c3aed;background:#f5f3ff;padding:1.5rem;border-radius:0 12px 12px 0;margin:2rem 0\">\n<p style=\"margin:0 0 .5rem;font-weight:700;color:#4f46e5\">\u0633\u064a\u0631\u0641\u0631\u0627\u062a VPS \u0645\u064f\u062d\u0633\u0651\u0646\u0629 \u0644\u0644\u0642\u0648\u0627\u0639\u062f \u0645\u0646 \u0645\u0631\u0627\u0645 \u0647\u0648\u0633\u062a<\/p>\n<p style=\"margin:0;color:#374151\">\u0627\u062d\u0635\u0644 \u0639\u0644\u0649 VPS \u0628\u0625\u0639\u062f\u0627\u062f\u0627\u062a MySQL \u0645\u062d\u0633\u0651\u0646\u0629 \u0645\u0633\u0628\u0642\u064b\u0627\u060c \u0645\u0639 SSD NVMe \u0648 \u0630\u0627\u0643\u0631\u0629 \u0643\u0628\u064a\u0631\u0629. <a href=\"https:\/\/maram.iq\/blogs\/%d8%ae%d8%b7%d8%b7-%d9%85%d8%b1%d8%a7%d9%85-%d9%87%d9%88%d8%b3%d8%aa\/\" style=\"color:#4f46e5;font-weight:600\">\u0627\u0628\u062f\u0623 \u0645\u0646 \u0647\u0646\u0627<\/a>.<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-7\">\u062a\u062d\u0633\u064a\u0646 MySQL: tmp_table_size \u0648 sort_buffer_size<\/h2>\n\n\n\n<p>tmp_table_size \u0648 max_heap_table_size \u064a\u062d\u062f\u062f\u0627\u0646 \u0627\u0644\u062d\u062f \u0627\u0644\u0623\u0642\u0635\u0649 \u0644\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0645\u0624\u0642\u062a\u0629 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629. \u0639\u0646\u062f \u062a\u062c\u0627\u0648\u0632 \u0647\u0630\u0627 \u0627\u0644\u062d\u062f\u060c \u064a\u0646\u0642\u0644 MySQL \u0627\u0644\u062c\u062f\u0648\u0644 \u0625\u0644\u0649 \u0627\u0644\u0642\u0631\u0635\u060c \u0645\u0645\u0627 \u064a\u0628\u0637\u0626\u0647 \u0628\u0634\u062f\u0629. \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a 16M \u0635\u063a\u064a\u0631 \u062c\u062f\u064b\u0627 \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062d\u062f\u064a\u062b\u0629.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\ntmp_table_size = 64M\nmax_heap_table_size = 64M\n\n# \u064a\u062c\u0628 \u0623\u0646 \u064a\u0643\u0648\u0646\u0627 \u0645\u062a\u0633\u0627\u0648\u064a\u064a\u0646 \u062f\u0627\u0626\u0645\u064b\u0627\n\n# \u0644\u0631\u0635\u062f \u0641\u0639\u0627\u0644\u064a\u062a\u0647\u0645\u0627\nSHOW STATUS LIKE 'Created_tmp%';\n# Created_tmp_disk_tables \/ Created_tmp_tables = \u0646\u0633\u0628\u0629 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u062a\u064a \u0630\u0647\u0628\u062a \u0644\u0644\u0642\u0631\u0635\n# \u064a\u062c\u0628 \u0623\u0646 \u062a\u0643\u0648\u0646 \u0623\u0642\u0644 \u0645\u0646 25%<\/code><\/pre>\n\n\n\n<p>sort_buffer_size \u064a\u062e\u0635\u0635 \u0630\u0627\u0643\u0631\u0629 \u0644\u0643\u0644 \u0627\u062a\u0635\u0627\u0644 \u064a\u062d\u062a\u0627\u062c \u0639\u0645\u0644\u064a\u0629 \u0641\u0631\u0632 (ORDER BY). \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u062a\u062e\u0635\u0635 &#8220;\u0644\u0643\u0644 \u0627\u062a\u0635\u0627\u0644&#8221;\u060c \u0644\u0630\u0627 \u0627\u0644\u0625\u0633\u0631\u0627\u0641 \u0641\u064a\u0647\u0627 \u0643\u0627\u0631\u062b\u064a. \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 256K \u062a\u0643\u0641\u064a \u0644\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0633\u064a\u0637\u0629. \u0644\u0648 \u0643\u0627\u0646 \u0644\u062f\u064a\u0643 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0645\u0639\u0642\u062f\u0629 \u0628\u0641\u0631\u0632 \u0643\u0628\u064a\u0631\u060c 2M-4M \u0631\u0642\u0645 \u0622\u0645\u0646.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\nsort_buffer_size = 2M\nread_buffer_size = 1M\nread_rnd_buffer_size = 2M\njoin_buffer_size = 2M\n\n# \u0647\u0630\u0647 \u0643\u0644\u0647\u0627 \"per connection\"\u060c \u0641\u0627\u0644\u0625\u062c\u0645\u0627\u0644\u064a = \u0627\u0644\u0642\u064a\u0645\u0629 \u00d7 max_connections<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-8\">\u0627\u062e\u062a\u064a\u0627\u0631 \u0645\u062d\u0631\u0643 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0645\u0646\u0627\u0633\u0628 (InnoDB vs MyISAM)<\/h2>\n\n\n\n<p>\u0641\u064a 2026\u060c InnoDB \u0647\u0648 \u0627\u0644\u0645\u062d\u0631\u0643 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a \u0648\u0627\u0644\u0623\u0646\u0633\u0628 \u0644\u0640 99% \u0645\u0646 \u0627\u0644\u062d\u0627\u0644\u0627\u062a. \u064a\u062f\u0639\u0645 \u0627\u0644\u0645\u0639\u0627\u0645\u0644\u0627\u062a (transactions)\u060c \u0642\u0641\u0644 \u0627\u0644\u0635\u0641\u0648\u0641 (row-level locking)\u060c \u0627\u0633\u062a\u0639\u0627\u062f\u0629 \u0627\u0644\u0623\u0639\u0637\u0627\u0644 \u0627\u0644\u062a\u0644\u0642\u0627\u0626\u064a\u0629 (crash recovery)\u060c \u0648\u0627\u0644\u0645\u0641\u0627\u062a\u064a\u062d \u0627\u0644\u0623\u062c\u0646\u0628\u064a\u0629 (foreign keys). MyISAM \u0623\u0642\u062f\u0645 \u0648\u0623\u0628\u0633\u0637\u060c \u064a\u0633\u062a\u062e\u062f\u0645 \u0642\u0641\u0644 \u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u0643\u0627\u0645\u0644 (table-level locking) \u0645\u0645\u0627 \u064a\u0624\u062f\u064a \u0625\u0644\u0649 \u062a\u0646\u0627\u0632\u0639 \u0634\u062f\u064a\u062f \u0645\u0639 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u0629.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u0645\u0639\u0631\u0641\u0629 \u0645\u062d\u0631\u0643 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0644\u0643\u0644 \u062c\u062f\u0648\u0644\nSELECT TABLE_NAME, ENGINE\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = 'your_database';\n\n-- \u062a\u062d\u0648\u064a\u0644 \u062c\u062f\u0648\u0644 \u0645\u0646 MyISAM \u0625\u0644\u0649 InnoDB\nALTER TABLE wp_posts ENGINE=InnoDB;\n\n-- \u062a\u062d\u0648\u064a\u0644 \u0643\u0644 \u062c\u062f\u0627\u0648\u0644 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0639\u064a\u0646\u0629\nSELECT CONCAT('ALTER TABLE ', TABLE_NAME, ' ENGINE=InnoDB;')\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = 'your_database' AND ENGINE = 'MyISAM';<\/code><\/pre>\n\n\n\n<p>\u0644\u0648 \u0643\u0627\u0646\u062a \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u0648\u0648\u0631\u062f\u0628\u0631\u064a\u0633 \u0642\u062f\u064a\u0645\u0629 (\u0642\u0628\u0644 2014)\u060c \u0641\u0645\u0646 \u0627\u0644\u0645\u0631\u062c\u062d \u0623\u0646 \u062a\u062d\u0648\u064a \u062c\u062f\u0627\u0648\u0644 MyISAM. \u062d\u0648\u0651\u0644\u0647\u0627 \u0643\u0644\u0647\u0627 \u0625\u0644\u0649 InnoDB. \u0627\u0644\u0641\u0627\u0626\u062f\u0629: \u0623\u062f\u0627\u0621 \u0623\u0641\u0636\u0644 \u0644\u0644\u0642\u0631\u0627\u0621\u0629 \u0648\u0627\u0644\u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u0629\u060c \u0648\u062b\u0628\u0627\u062a \u0623\u0643\u0628\u0631 \u0628\u0639\u062f \u0633\u0642\u0648\u0637 \u0627\u0644\u0646\u0638\u0627\u0645. \u0644\u0644\u0646\u0633\u062e \u0627\u0644\u0627\u062d\u062a\u064a\u0627\u0637\u064a\u060c \u0627\u0637\u0651\u0644\u0639 \u0639\u0644\u0649 <a href=\"https:\/\/maram.iq\/blogs\/%d8%a7%d9%84%d9%86%d8%b3%d8%ae-%d8%a7%d9%84%d8%a7%d8%ad%d8%aa%d9%8a%d8%a7%d8%b7%d9%8a-mysql\/\">\u062f\u0644\u064a\u0644 \u0627\u0644\u0646\u0633\u062e \u0627\u0644\u0627\u062d\u062a\u064a\u0627\u0637\u064a MySQL<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-9\">\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 (Indexes) \u0641\u064a MySQL<\/h2>\n\n\n\n<p>\u0627\u0644\u0641\u0647\u0631\u0633 \u0627\u0644\u062c\u064a\u062f \u064a\u062d\u0648\u0651\u0644 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u064b\u0627 \u064a\u0641\u062d\u0635 \u0645\u0644\u064a\u0648\u0646 \u0635\u0641 \u0625\u0644\u0649 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u064a\u0641\u062d\u0635 \u0628\u0636\u0639\u0629 \u0635\u0641\u0648\u0641. \u0647\u0630\u0627 \u0623\u0643\u0628\u0631 \u0645\u0643\u0633\u0628 \u0623\u062f\u0627\u0621 \u064a\u0645\u0643\u0646 \u062a\u062d\u0642\u064a\u0642\u0647 \u062f\u0648\u0646 \u0623\u064a \u062a\u063a\u064a\u064a\u0631 \u0641\u064a \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a. \u062a\u0634\u062e\u064a\u0635 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u0627\u0644\u0646\u0627\u0642\u0635\u0629 \u064a\u0628\u062f\u0623 \u0628\u0623\u062f\u0627\u0629 EXPLAIN\u060c \u0627\u0644\u062a\u064a \u062a\u0643\u0634\u0641 \u062e\u0637\u0629 \u0627\u0644\u062a\u0646\u0641\u064a\u0630 \u0644\u0623\u064a \u0627\u0633\u062a\u0639\u0644\u0627\u0645.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u062a\u062d\u0644\u064a\u0644 \u062e\u0637\u0629 \u062a\u0646\u0641\u064a\u0630 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\nEXPLAIN SELECT * FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post';\n\n-- \u0625\u0646 \u0631\u0623\u064a\u062a type = ALL\u060c \u0641\u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u064a\u0642\u0648\u0645 \u0628\u0641\u062d\u0635 \u0643\u0627\u0645\u0644 (\u0633\u064a\u0626)\n-- \u0646\u0631\u064a\u062f type = ref \u0623\u0648 const \u0623\u0648 range\n\n-- \u0625\u0646\u0634\u0627\u0621 \u0641\u0647\u0631\u0633 \u0645\u0631\u0643\u0651\u0628 \u0639\u0644\u0649 \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0641\u064a WHERE\nCREATE INDEX idx_post_status_type ON wp_posts (post_status, post_type);\n\n-- \u0639\u0631\u0636 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629\nSHOW INDEX FROM wp_posts;\n\n-- \u062d\u0630\u0641 \u0641\u0647\u0631\u0633 \u063a\u064a\u0631 \u0645\u0633\u062a\u062e\u062f\u0645\nDROP INDEX idx_old ON wp_posts;<\/code><\/pre>\n\n\n\n<p>\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0641\u0647\u0631\u0633\u0629 \u0627\u0644\u0630\u0647\u0628\u064a\u0629: \u0636\u0639 \u0627\u0644\u0641\u0647\u0631\u0633 \u0639\u0644\u0649 \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0641\u064a WHERE\u060c ORDER BY\u060c JOIN. \u0641\u064a \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u0627\u0644\u0645\u0631\u0643\u0651\u0628\u0629\u060c \u0636\u0639 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0643\u062b\u0631 \u062a\u062d\u062f\u064a\u062f\u064b\u0627 \u0623\u0648\u0644\u064b\u0627. \u0644\u0627 \u062a\u0641\u0647\u0631\u0633 \u0623\u0639\u0645\u062f\u0629 BOOL \u0623\u0648 ENUM \u0630\u0627\u062a \u0642\u064a\u0645 \u0645\u062d\u062f\u0648\u062f\u0629. \u0644\u0627 \u062a\u0641\u0647\u0631\u0633 \u0623\u0643\u062b\u0631 \u0645\u0646 5 \u0623\u0639\u0645\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u0648\u0627\u062d\u062f\u060c \u0644\u0623\u0646 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u062a\u0628\u0637\u0626 \u0627\u0644\u0625\u062f\u0631\u0627\u062c.<\/p>\n\n\n\n<p>\u0644\u062a\u0634\u062e\u064a\u0635 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u063a\u064a\u0631 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629\u060c \u0627\u0633\u062a\u062e\u062f\u0645 performance_schema. \u0647\u064a \u062a\u062a\u0639\u0642\u0651\u0628 \u0643\u0644 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0648\u062a\u0633\u062c\u0651\u0644 \u0623\u064a \u0641\u0647\u0627\u0631\u0633 \u0627\u0633\u062a\u064f\u062e\u062f\u0645\u062a. \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u0627\u0644\u062a\u064a \u0644\u0645 \u062a\u064f\u0633\u062a\u062e\u062f\u0645 \u0645\u0646\u0630 \u0634\u0647\u0631 \u062a\u0643\u0648\u0646 \u0645\u0631\u0634\u062d\u0629 \u0644\u0644\u062d\u0630\u0641\u060c \u0641\u0647\u064a \u062a\u0633\u062a\u0647\u0644\u0643 \u0645\u0633\u0627\u062d\u0629 \u0648\u062a\u0628\u0637\u0626 \u0627\u0644\u0643\u062a\u0627\u0628\u0629 \u062f\u0648\u0646 \u0641\u0627\u0626\u062f\u0629.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-10\">\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629 (Slow Query Log)<\/h2>\n\n\n\n<p>Slow Query Log \u064a\u0633\u062c\u0651\u0644 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u062a\u064a \u062a\u062a\u062c\u0627\u0648\u0632 \u0639\u062a\u0628\u0629 \u0632\u0645\u0646\u064a\u0629 \u0645\u062d\u062f\u062f\u0629. \u0647\u0630\u0627 \u0627\u0644\u0643\u0646\u0632 \u0627\u0644\u0630\u064a \u064a\u0643\u0634\u0641 \u0639\u0646 \u0627\u0644\u0645\u0634\u0627\u0643\u0644 \u0627\u0644\u062d\u0642\u064a\u0642\u064a\u0629 \u0641\u064a \u062a\u0637\u0628\u064a\u0642\u0643. \u0643\u062b\u064a\u0631 \u0645\u0646 \u0627\u0644\u0645\u0634\u0631\u0641\u064a\u0646 \u064a\u0628\u062d\u062b\u0648\u0646 \u0641\u064a \u0625\u0639\u062f\u0627\u062f\u0627\u062a MySQL\u060c \u0628\u064a\u0646\u0645\u0627 \u0627\u0644\u0645\u0634\u0643\u0644\u0629 \u0627\u0644\u062d\u0642\u064a\u0642\u064a\u0629 \u0641\u064a \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0648\u0627\u062d\u062f \u0633\u064a\u0626 \u064a\u0633\u062a\u0647\u0644\u0643 80% \u0645\u0646 \u0627\u0644\u0645\u0648\u0627\u0631\u062f.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\nslow_query_log = 1\nslow_query_log_file = \/var\/log\/mysql\/slow.log\nlong_query_time = 1\nlog_queries_not_using_indexes = 1\n\n# \u0625\u0639\u0627\u062f\u0629 \u062a\u0634\u063a\u064a\u0644 MySQL\nsystemctl restart mysql\n\n# \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0633\u062c\u0644 \u0628\u0640 mysqldumpslow\nmysqldumpslow -s t -t 20 \/var\/log\/mysql\/slow.log\n# -s t: \u062a\u0631\u062a\u064a\u0628 \u0628\u0627\u0644\u0648\u0642\u062a\n# -t 20: \u0623\u0639\u0644\u0649 20 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u064b\u0627\n\n# \u0623\u062f\u0627\u0629 pt-query-digest \u0645\u0646 Percona \u0623\u0643\u062b\u0631 \u062a\u0637\u0648\u0631\u064b\u0627\npt-query-digest \/var\/log\/mysql\/slow.log<\/code><\/pre>\n\n\n\n<p>long_query_time = 1 \u064a\u0639\u0646\u064a \u062a\u0633\u062c\u064a\u0644 \u0623\u064a \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u064a\u0633\u062a\u063a\u0631\u0642 \u062b\u0627\u0646\u064a\u0629 \u0623\u0648 \u0623\u0643\u062b\u0631. \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0645\u062d\u0633\u0651\u0646\u0629\u060c \u0627\u062c\u0639\u0644\u0647\u0627 0.5 \u0623\u0648 \u062d\u062a\u0649 0.1 \u0644\u0643\u0634\u0641 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0645\u062a\u0648\u0633\u0637\u0629. log_queries_not_using_indexes \u064a\u0643\u0634\u0641 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0628\u062f\u0648\u0646 \u0641\u0647\u0627\u0631\u0633 \u062d\u062a\u0649 \u0644\u0648 \u0643\u0627\u0646\u062a \u0633\u0631\u064a\u0639\u0629.<\/p>\n\n\n\n<p>pt-query-digest \u0645\u0646 Percona Toolkit \u064a\u062c\u0645\u0639 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0645\u062a\u0634\u0627\u0628\u0647\u0629 (\u0627\u0644\u062a\u064a \u062a\u062e\u062a\u0644\u0641 \u0641\u0642\u0637 \u0641\u064a \u0627\u0644\u0642\u064a\u0645)\u060c \u0648\u064a\u0631\u062a\u0628\u0647\u0627 \u0628\u0625\u062c\u0645\u0627\u0644\u064a \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0645\u0633\u062a\u0647\u0644\u0643. \u0647\u0630\u0627 \u064a\u0643\u0634\u0641 \u0628\u0627\u0644\u0636\u0628\u0637 \u0623\u064a \u0642\u0627\u0644\u0628 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u064a\u0633\u062a\u0647\u0644\u0643 \u0623\u0643\u0628\u0631 \u062c\u0632\u0621 \u0645\u0646 \u0627\u0644\u0645\u0648\u0627\u0631\u062f. \u062b\u0645 \u062a\u062d\u0644\u0651 \u0645\u0634\u0643\u0644\u062a\u0647 \u0628\u0641\u0647\u0631\u0633 \u0623\u0648 \u0625\u0639\u0627\u062f\u0629 \u0643\u062a\u0627\u0628\u0629.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-11\">\u062a\u062d\u0633\u064a\u0646 MySQL \u0644\u0640 WordPress \u0648 WooCommerce<\/h2>\n\n\n\n<p>WordPress \u0648 WooCommerce \u064a\u0633\u062a\u062e\u062f\u0645\u0627\u0646 \u062c\u062f\u0648\u0644 wp_postmeta \u0628\u0634\u0643\u0644 \u0645\u0643\u062b\u0651\u0641. \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u0630\u064a \u064a\u062e\u0632\u0651\u0646 \u0645\u0639\u0638\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a schema &#8220;Entity-Attribute-Value&#8221;\u060c \u0648\u0647\u0648 \u0646\u0645\u0637 \u0628\u0637\u064a\u0621 \u0628\u0637\u0628\u064a\u0639\u062a\u0647. <strong>\u062a\u062d\u0633\u064a\u0646 MySQL<\/strong> \u0627\u0644\u0645\u0648\u062c\u0651\u0647 \u0644\u0647\u0645\u0627 \u064a\u0628\u062f\u0623 \u0628\u0641\u0647\u0631\u0633\u0629 \u0647\u0630\u0627 \u0627\u0644\u062c\u062f\u0648\u0644 \u062c\u064a\u062f\u064b\u0627.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u0641\u0647\u0627\u0631\u0633 \u0645\u0641\u064a\u062f\u0629 \u0644\u0640 wp_postmeta\nALTER TABLE wp_postmeta ADD INDEX idx_meta_key_value (meta_key, meta_value(20));\nALTER TABLE wp_postmeta ADD INDEX idx_post_meta_key (post_id, meta_key);\n\n-- \u0641\u0647\u0627\u0631\u0633 \u0644\u0640 wp_options\nALTER TABLE wp_options ADD INDEX idx_autoload (autoload);\n\n-- \u062a\u0646\u0638\u064a\u0641 autoload \u0627\u0644\u0643\u0628\u064a\u0631 \u0641\u064a wp_options\nSELECT option_name, LENGTH(option_value) AS len\nFROM wp_options\nWHERE autoload = 'yes'\nORDER BY len DESC LIMIT 20;\n\n-- \u062a\u0639\u0637\u064a\u0644 autoload \u0644\u062e\u064a\u0627\u0631\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u063a\u064a\u0631 \u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0641\u064a \u0643\u0644 \u0635\u0641\u062d\u0629\nUPDATE wp_options SET autoload = 'no' WHERE option_name = 'large_unused_option';<\/code><\/pre>\n\n\n\n<p>WooCommerce 8+ \u0623\u062a\u0627\u062d \u0645\u064a\u0632\u0629 High-Performance Order Storage (HPOS) \u0627\u0644\u062a\u064a \u062a\u0646\u0642\u0644 \u0627\u0644\u0637\u0644\u0628\u0627\u062a \u0625\u0644\u0649 \u062c\u062f\u0627\u0648\u0644 \u0645\u062e\u0635\u0635\u0629 (wc_orders) \u0628\u062f\u0644\u064b\u0627 \u0645\u0646 wp_posts. \u0647\u0630\u0627 \u064a\u062d\u0633\u0651\u0646 \u0623\u062f\u0627\u0621 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0637\u0644\u0628\u0627\u062a \u0628\u0646\u0633\u0628\u0629 10x \u0641\u064a \u0627\u0644\u0645\u062a\u0627\u062c\u0631 \u0627\u0644\u0643\u0628\u064a\u0631\u0629. \u0641\u0639\u0651\u0644\u0647 \u0645\u0646 \u0625\u0639\u062f\u0627\u062f\u0627\u062a WooCommerce > Advanced > Features.<\/p>\n\n\n\n<p>\u0644\u062a\u0646\u0638\u064a\u0641 \u0628\u064a\u0627\u0646\u0627\u062a WooCommerce \u0627\u0644\u0642\u062f\u064a\u0645\u0629: \u0627\u062d\u0630\u0641 \u0627\u0644\u0637\u0644\u0628\u0627\u062a \u0627\u0644\u0641\u0627\u0634\u0644\u0629 \u0627\u0644\u0623\u0642\u062f\u0645 \u0645\u0646 30 \u064a\u0648\u0645\u064b\u0627\u060c \u0627\u062d\u0630\u0641 \u0627\u0644\u0640 transients \u0627\u0644\u0645\u0646\u062a\u0647\u064a\u0629\u060c \u0627\u062d\u0630\u0641 logs \u0627\u0644\u0642\u062f\u064a\u0645\u0629. \u0644\u0644\u0645\u0632\u064a\u062f \u0639\u0646 \u0625\u062f\u0627\u0631\u0629 Linux \u0648\u0627\u0644\u0642\u0648\u0627\u0639\u062f\u060c \u0627\u0637\u0651\u0644\u0639 \u0639\u0644\u0649 <a href=\"https:\/\/maram.iq\/blogs\/linux-%d8%b3%d8%b7%d8%b1-%d8%a7%d9%84%d8%a3%d9%88%d8%a7%d9%85%d8%b1-%d8%a7%d9%84%d8%af%d9%84%d9%8a%d9%84-%d8%a7%d9%84%d8%b4%d8%a7%d9%85%d9%84-%d9%84%d8%a5%d8%af%d8%a7%d8%b1%d8%a9\/\">\u062f\u0644\u064a\u0644 \u0623\u0648\u0627\u0645\u0631 Linux<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-12\">\u062a\u062d\u0633\u064a\u0646 MySQL \u0639\u0644\u0649 VPS \u0645\u0642\u0627\u0628\u0644 Shared Hosting<\/h2>\n\n\n\n<p>\u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 \u0627\u0644\u0627\u0633\u062a\u0636\u0627\u0641\u0629 \u0627\u0644\u0645\u0634\u062a\u0631\u0643\u0629 \u0648 VPS \u0641\u064a \u0645\u0648\u0636\u0648\u0639 MySQL \u0647\u0627\u0626\u0644. \u0639\u0644\u0649 Shared Hosting\u060c \u0644\u0627 \u062a\u0633\u062a\u0637\u064a\u0639 \u0627\u0644\u062a\u062d\u0643\u0645 \u0641\u064a my.cnf\u060c \u0641\u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0645\u0634\u062a\u0631\u0643\u0629 \u0628\u064a\u0646 \u0643\u0644 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646. \u0645\u0632\u0648\u062f \u0627\u0644\u0627\u0633\u062a\u0636\u0627\u0641\u0629 \u064a\u0636\u0639 \u0642\u064a\u0645\u064b\u0627 \u0645\u062d\u0627\u0641\u0638\u0629 \u0644\u062a\u062c\u0646\u0628 \u0627\u062d\u062a\u0644\u0627\u0644 \u0623\u064a \u0645\u0648\u0642\u0639 \u0643\u0644 \u0627\u0644\u0645\u0648\u0627\u0631\u062f.<\/p>\n\n\n\n<p>\u0639\u0644\u0649 VPS\u060c \u0644\u062f\u064a\u0643 \u062a\u062d\u0643\u0645 \u0643\u0627\u0645\u0644. \u064a\u0645\u0643\u0646\u0643 \u062a\u062e\u0635\u064a\u0635 70% \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0644\u0640 MySQL\u060c \u0648\u0636\u0628\u0637 \u0643\u0644 \u0627\u0644\u0645\u062a\u063a\u064a\u0631\u0627\u062a \u062d\u0633\u0628 \u0627\u062d\u062a\u064a\u0627\u062c\u0627\u062a\u0643. \u0647\u0630\u0627 \u0641\u0631\u0642 \u062c\u0648\u0647\u0631\u064a \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u064a \u062a\u062c\u0627\u0648\u0632\u062a \u062d\u062c\u0645\u064b\u0627 \u0645\u0639\u064a\u0646\u064b\u0627. \u0639\u0645\u0648\u0645\u064b\u0627\u060c \u0639\u0646\u062f\u0645\u0627 \u064a\u0635\u0644 \u0645\u0648\u0642\u0639\u0643 \u0625\u0644\u0649 1000 \u0632\u0627\u0626\u0631 \u064a\u0648\u0645\u064a\u064b\u0627\u060c \u0623\u0648 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0628\u062d\u062c\u0645 1GB\u060c \u0641\u0642\u062f \u062d\u0627\u0646 \u0648\u0642\u062a \u0627\u0644\u0627\u0646\u062a\u0642\u0627\u0644 \u0625\u0644\u0649 VPS.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0639\u0644\u0649 VPS: \u062a\u062d\u0643\u0645 \u0643\u0627\u0645\u0644\u060c \u0623\u062f\u0627\u0621 \u0642\u0627\u0628\u0644 \u0644\u0644\u0636\u0628\u0637\u060c \u062a\u0643\u0644\u0641\u0629 \u0623\u0639\u0644\u0649.<\/li><li>\u0639\u0644\u0649 Shared: \u062a\u062d\u0643\u0645 \u0645\u062d\u062f\u0648\u062f\u060c \u0623\u062f\u0627\u0621 \u0642\u064a\u0627\u0633\u064a\u060c \u062a\u0643\u0644\u0641\u0629 \u0645\u0646\u062e\u0641\u0636\u0629.<\/li><li>\u0639\u0644\u0649 Cloud: \u0645\u0631\u0648\u0646\u0629 \u0641\u064a \u062a\u0648\u0633\u064a\u0639 \u0627\u0644\u0645\u0648\u0627\u0631\u062f\u060c \u062a\u0643\u0644\u0641\u0629 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629.<\/li><li>\u0639\u0644\u0649 Managed MySQL: \u0623\u062f\u0627\u0621 \u0639\u0627\u0644\u064d \u0628\u062f\u0648\u0646 \u0639\u0628\u0621 \u0627\u0644\u0625\u062f\u0627\u0631\u0629.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-13\">\u0636\u0628\u0637 \u0625\u0639\u062f\u0627\u062f\u0627\u062a my.cnf \u0644\u0644\u0623\u062f\u0627\u0621<\/h2>\n\n\n\n<p>\u0625\u0644\u064a\u0643 \u0645\u0644\u0641 my.cnf \u0646\u0645\u0648\u0630\u062c\u064a \u0645\u062d\u0633\u0651\u0646 \u0644\u0633\u064a\u0631\u0641\u0631 VPS \u0628\u0640 8GB \u0630\u0627\u0643\u0631\u0629\u060c \u064a\u0633\u062a\u0636\u064a\u0641 \u0645\u0648\u0642\u0639 WooCommerce \u0646\u0634\u0637:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]\n# Connection settings\nmax_connections = 300\nmax_user_connections = 250\nthread_cache_size = 50\nmax_allowed_packet = 64M\n\n# InnoDB settings\ninnodb_buffer_pool_size = 5G\ninnodb_buffer_pool_instances = 5\ninnodb_log_file_size = 1G\ninnodb_log_buffer_size = 32M\ninnodb_flush_log_at_trx_commit = 2\ninnodb_flush_method = O_DIRECT\ninnodb_file_per_table = 1\ninnodb_io_capacity = 2000\ninnodb_io_capacity_max = 4000\n\n# Query cache (off in MySQL 8)\nquery_cache_type = 0\nquery_cache_size = 0\n\n# Tables\ntable_open_cache = 4000\ntable_definition_cache = 2000\n\n# Temp tables\ntmp_table_size = 128M\nmax_heap_table_size = 128M\n\n# Buffers (per connection)\nsort_buffer_size = 2M\nread_buffer_size = 1M\nread_rnd_buffer_size = 2M\njoin_buffer_size = 2M\n\n# MyISAM (legacy)\nkey_buffer_size = 32M\n\n# Slow query log\nslow_query_log = 1\nslow_query_log_file = \/var\/log\/mysql\/slow.log\nlong_query_time = 1\nlog_queries_not_using_indexes = 1\n\n# Binary log\nlog_bin = \/var\/log\/mysql\/mysql-bin.log\nexpire_logs_days = 7\nmax_binlog_size = 100M\n\n# Charset\ncharacter-set-server = utf8mb4\ncollation-server = utf8mb4_unicode_ci\n\n# Performance schema\nperformance_schema = 1<\/code><\/pre>\n\n\n\n<p>innodb_flush_log_at_trx_commit = 2 \u064a\u062d\u0633\u0651\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0639\u0644\u0649 \u062d\u0633\u0627\u0628 \u0637\u0641\u064a\u0641 \u0645\u0646 \u0627\u0644\u0645\u0648\u062b\u0648\u0642\u064a\u0629. \u0627\u0644\u0642\u064a\u0645\u0629 1 (\u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a) \u0623\u0643\u062b\u0631 \u0623\u0645\u0627\u0646\u064b\u0627\u060c 0 \u0623\u0633\u0631\u0639 \u0644\u0643\u0646 \u0642\u062f \u064a\u0641\u0642\u062f \u0628\u0636\u0639 \u062b\u0648\u0627\u0646\u064a \u0645\u0646 \u0627\u0644\u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0641\u064a \u062d\u0627\u0644 \u0627\u0646\u0642\u0637\u0627\u0639 \u0627\u0644\u062a\u064a\u0627\u0631. \u0627\u0644\u0642\u064a\u0645\u0629 2 \u062a\u0648\u0627\u0632\u0646 \u062c\u064a\u062f. innodb_flush_method = O_DIRECT \u064a\u062a\u062c\u0627\u0648\u0632 \u0643\u0627\u0634 \u0646\u0638\u0627\u0645 \u0627\u0644\u0645\u0644\u0641\u0627\u062a\u060c \u0648\u0647\u0648 \u0627\u0644\u0623\u0645\u062b\u0644 \u0639\u0644\u0649 SSD.<\/p>\n\n\n\n<div style=\"border-right:4px solid #7c3aed;background:#f5f3ff;padding:1.5rem;border-radius:0 12px 12px 0;margin:2rem 0\">\n<p style=\"margin:0 0 .5rem;font-weight:700;color:#4f46e5\">\u0623\u062f\u0627\u0621 \u0641\u0627\u0626\u0642 \u0644\u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0643<\/p>\n<p style=\"margin:0;color:#374151\">\u0645\u0639 \u062a\u062d\u0633\u064a\u0646\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629 \u0644\u0640 MySQL \u0639\u0644\u0649 \u0627\u0633\u062a\u0636\u0627\u0641\u0629 \u0645\u0631\u0627\u0645\u060c \u0627\u062d\u0635\u0644 \u0639\u0644\u0649 \u0623\u062f\u0627\u0621 \u064a\u0636\u0627\u0647\u064a \u0627\u0644\u0633\u064a\u0631\u0641\u0631\u0627\u062a \u0627\u0644\u0645\u062e\u0635\u0635\u0629. \u0627\u0637\u0651\u0644\u0639 \u0639\u0644\u0649 <a href=\"https:\/\/maram.iq\/blogs\/%d8%aa%d8%ad%d9%82%d9%82-core-web-vitals-100-%d9%88%d9%88%d8%b1%d8%af%d8%a8%d8%b1%d9%8a%d8%b3\/\">Core Web Vitals 100<\/a> \u0648<a href=\"https:\/\/maram.iq\" style=\"color:#4f46e5;font-weight:600\">\u0627\u0628\u062f\u0623 \u0645\u0646 \u0647\u0646\u0627<\/a>.<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-14\">\u0645\u0631\u0627\u0642\u0628\u0629 MySQL \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Percona Monitoring<\/h2>\n\n\n\n<p>Percona Monitoring and Management (PMM) \u0623\u062f\u0627\u0629 \u0645\u062c\u0627\u0646\u064a\u0629 \u0645\u0641\u062a\u0648\u062d\u0629 \u0627\u0644\u0645\u0635\u062f\u0631 \u062a\u0642\u062f\u0645 \u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u062d\u062a\u0631\u0627\u0641\u064a\u0629 \u0644\u0640 MySQL. \u062a\u0639\u0631\u0636 \u0631\u0633\u0648\u0645\u064b\u0627 \u0628\u064a\u0627\u0646\u064a\u0629 \u0644\u0643\u0644 \u0627\u0644\u0645\u0624\u0634\u0631\u0627\u062a: \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0630\u0627\u0643\u0631\u0629\u060c \u0639\u062f\u062f \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a\u060c \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0628\u0637\u064a\u0626\u0629\u060c \u062d\u0627\u0644\u0629 InnoDB\u060c \u0648\u0623\u0643\u062b\u0631 \u0628\u0643\u062b\u064a\u0631. \u0647\u064a \u0645\u0627 \u064a\u0633\u062a\u062e\u062f\u0645\u0647 \u0627\u0644\u0645\u062d\u062a\u0631\u0641\u0648\u0646 \u0641\u064a \u0627\u0644\u0634\u0631\u0643\u0627\u062a \u0627\u0644\u0643\u0628\u0631\u0649.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u062a\u062b\u0628\u064a\u062a PMM Server \u0641\u064a Docker\ndocker run -d --name pmm-server \\\n  --restart always \\\n  -p 80:80 -p 443:443 \\\n  percona\/pmm-server:latest\n\n# \u062a\u062b\u0628\u064a\u062a PMM Client \u0639\u0644\u0649 \u0633\u064a\u0631\u0641\u0631 MySQL\nwget https:\/\/www.percona.com\/downloads\/pmm2\/latest\/binary\/tarball\/pmm2-client-linux-amd64.tar.gz\ntar xfz pmm2-client-linux-amd64.tar.gz\ncd pmm2-client-*\nsudo .\/install_tarball\n\n# \u062a\u0648\u0635\u064a\u0644 PMM Client \u0628\u0640 PMM Server\npmm-admin config --server-url=https:\/\/admin:admin@pmm-server-ip:443\n\n# \u0625\u0636\u0627\u0641\u0629 MySQL \u0644\u0644\u0645\u0631\u0627\u0642\u0628\u0629\npmm-admin add mysql --username=pmm --password=pmm-password mysql-prod<\/code><\/pre>\n\n\n\n<p>PMM \u064a\u0643\u0634\u0641 \u0628\u0635\u0631\u064a\u064b\u0627 \u0623\u0646\u0645\u0627\u0637 \u0627\u0644\u0623\u062f\u0627\u0621 \u0639\u0644\u0649 \u0645\u062f\u0627\u0631 \u0627\u0644\u064a\u0648\u0645. \u0633\u0627\u0639\u0627\u062a \u0627\u0644\u0630\u0631\u0648\u0629\u060c \u0644\u062d\u0638\u0627\u062a \u0628\u0637\u0621 \u063a\u064a\u0631 \u0645\u062a\u0648\u0642\u0639\u0629\u060c \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0645\u062a\u0636\u062e\u0645\u0629. \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u064a \u064a\u0642\u062f\u0645\u0647\u0627 \u0644\u0627 \u062a\u0633\u062a\u0637\u064a\u0639 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u064a\u0647\u0627 \u0645\u0646 mysqltuner \u0623\u0648 \u0627\u0644\u0633\u0637\u0631. \u0625\u0646 \u0643\u0646\u062a \u062a\u062f\u064a\u0631 \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0647\u0645\u0629\u060c PMM \u0627\u0633\u062a\u062b\u0645\u0627\u0631 \u064a\u0633\u062a\u062d\u0642 \u0627\u0644\u0648\u0642\u062a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-15\">\u0623\u0641\u0636\u0644 \u0645\u0645\u0627\u0631\u0633\u0627\u062a \u062a\u062d\u0633\u064a\u0646 MySQL<\/h2>\n\n\n\n<p>\u0644\u0644\u062d\u0641\u0627\u0638 \u0639\u0644\u0649 \u0623\u062f\u0627\u0621 MySQL \u0639\u0644\u0649 \u0627\u0644\u0645\u062f\u0649 \u0627\u0644\u0637\u0648\u064a\u0644\u060c \u0627\u062a\u0628\u0639 \u0647\u0630\u0647 \u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0627\u062a. \u0623\u0648\u0644\u064b\u0627\u060c \u0646\u0641\u0651\u0630 <code>OPTIMIZE TABLE<\/code> \u062f\u0648\u0631\u064a\u064b\u0627 \u0639\u0644\u0649 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0646\u0634\u0637\u0629\u060c \u062e\u0635\u0648\u0635\u064b\u0627 \u062a\u0644\u0643 \u0627\u0644\u062a\u064a \u062a\u062a\u0639\u0631\u0636 \u0644\u0643\u062b\u064a\u0631 \u0645\u0646 DELETE. \u0647\u0630\u0627 \u064a\u0633\u062a\u0639\u064a\u062f \u0627\u0644\u0645\u0633\u0627\u062d\u0629 \u0627\u0644\u0636\u0627\u0626\u0639\u0629 \u0648\u064a\u0639\u064a\u062f \u0628\u0646\u0627\u0621 \u0627\u0644\u0641\u0647\u0627\u0631\u0633.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0631\u0627\u0642\u0628 slow query log \u0623\u0633\u0628\u0648\u0639\u064a\u064b\u0627.<\/li><li>\u0634\u063a\u0651\u0644 mysqltuner \u0634\u0647\u0631\u064a\u064b\u0627 \u0648\u0627\u062a\u0628\u0639 \u062a\u0648\u0635\u064a\u0627\u062a\u0647.<\/li><li>\u0627\u062d\u062a\u0641\u0638 \u0628\u0646\u0633\u062e \u0627\u062d\u062a\u064a\u0627\u0637\u064a\u0629 \u064a\u0648\u0645\u064a\u0629 \u0648\u0644\u0627 \u062a\u0646\u0633\u0649 \u0627\u062e\u062a\u0628\u0627\u0631 \u0627\u0644\u0627\u0633\u062a\u0631\u062c\u0627\u0639.<\/li><li>\u0642\u0645 \u0628\u062a\u062d\u062f\u064a\u062b MySQL \u0625\u0644\u0649 \u0623\u062d\u062f\u062b LTS \u0633\u0646\u0648\u064a\u064b\u0627.<\/li><li>\u0631\u0627\u062c\u0639 \u0627\u0644\u0641\u0647\u0627\u0631\u0633 \u063a\u064a\u0631 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0643\u0644 \u0631\u0628\u0639 \u0633\u0646\u0629.<\/li><li>\u0627\u0633\u062a\u062e\u062f\u0645 Connection Pool \u0644\u062a\u0642\u0644\u064a\u0644 overhead \u0627\u0644\u0627\u062a\u0635\u0627\u0644\u0627\u062a.<\/li><li>\u0639\u0632\u0644 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062b\u0642\u064a\u0644\u0629 \u0639\u0644\u0649 VPS \u0645\u0646\u0641\u0635\u0644 \u0639\u0646\u062f \u0627\u0644\u062d\u0627\u062c\u0629.<\/li><\/ul>\n\n\n\n<p>\u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0629 \u0627\u0644\u0623\u0647\u0645 \u0645\u0646 \u0643\u0644 \u0645\u0627 \u0633\u0628\u0642: \u0644\u0627 \u062a\u062b\u0642 \u0628\u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0627\u062a. \u0643\u0644 \u0645\u0646 \u064a\u062f\u064a\u0631\u0648\u0646 \u0642\u0648\u0627\u0639\u062f MySQL \u0641\u064a \u0634\u0631\u0643\u0627\u062a \u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627 \u0643\u0628\u0631\u0649 \u064a\u0628\u062f\u0624\u0648\u0646 \u0645\u0646 \u062a\u062e\u0635\u064a\u0635 my.cnf \u0644\u0627\u062d\u062a\u064a\u0627\u062c\u0627\u062a\u0647\u0645. \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0645\u0635\u0645\u0645\u0629 \u0644\u0644\u0639\u0645\u0644 \u062f\u0648\u0646 \u0627\u0646\u0647\u064a\u0627\u0631\u060c \u0644\u0627 \u0644\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0639\u0627\u0644\u064a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-16\">\u0627\u0644\u062e\u0644\u0627\u0635\u0629<\/h2>\n\n\n\n<p>\u062a\u062d\u0633\u064a\u0646 MySQL \u0641\u064a 2026 \u0644\u064a\u0633 \u0641\u0646\u064b\u0627 \u063a\u0627\u0645\u0636\u064b\u0627\u060c \u0628\u0644 \u0639\u0644\u0645 \u0645\u0646\u0647\u062c\u064a. \u0627\u0628\u062f\u0623 \u0628\u0642\u064a\u0627\u0633 \u0627\u0644\u0648\u0636\u0639 \u0627\u0644\u062d\u0627\u0644\u064a \u0628\u0640 mysqltuner\u060c \u062d\u062f\u062f \u0627\u0644\u0639\u0646\u0642 \u0627\u0644\u062d\u0631\u062c (\u0633\u0648\u0627\u0621 \u0641\u064a buffer pool \u0623\u0648 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629 \u0623\u0648 \u0627\u0644\u0641\u0647\u0627\u0631\u0633)\u060c \u0637\u0628\u0651\u0642 \u0627\u0644\u062a\u062d\u0633\u064a\u0646\u0627\u062a \u062a\u062f\u0631\u064a\u062c\u064a\u064b\u0627 \u0645\u0639 \u0642\u064a\u0627\u0633 \u0627\u0644\u0623\u062b\u0631 \u0628\u0639\u062f \u0643\u0644 \u062a\u063a\u064a\u064a\u0631. \u0636\u0628\u0637 innodb_buffer_pool_size \u0647\u0648 \u0623\u0643\u0628\u0631 \u0645\u0643\u0633\u0628 \u0641\u0631\u062f\u064a. \u062a\u0646\u0638\u064a\u0641 wp_postmeta \u0648\u0641\u0647\u0631\u0633\u062a\u0647 \u064a\u0636\u0627\u0639\u0641 \u0623\u062f\u0627\u0621 WordPress \u0648 WooCommerce. \u062a\u062d\u0648\u064a\u0644 MyISAM \u0625\u0644\u0649 InnoDB \u0636\u0631\u0648\u0631\u0629. \u062a\u062d\u0644\u064a\u0644 slow query log \u0643\u0646\u0632 \u064a\u0643\u0634\u0641 \u0627\u0644\u0645\u0634\u0627\u0643\u0644 \u0627\u0644\u062d\u0642\u064a\u0642\u064a\u0629. \u0645\u0639 \u0627\u0644\u0627\u0644\u062a\u0632\u0627\u0645 \u0628\u0647\u0630\u0647 \u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0627\u062a \u0648\u0627\u0644\u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u0644\u0645\u0633\u062a\u0645\u0631\u0629\u060c \u0633\u062a\u062d\u0635\u0644 \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0633\u0631\u064a\u0639\u0629\u060c \u0645\u0648\u062b\u0648\u0642\u0629\u060c \u062a\u062f\u0639\u0645 \u0646\u0645\u0648 \u0645\u0648\u0642\u0639\u0643 \u062f\u0648\u0646 \u0627\u062e\u062a\u0646\u0627\u0642\u0627\u062a. \u0627\u0644\u0627\u0633\u062a\u062b\u0645\u0627\u0631 \u0641\u064a \u0645\u0639\u0631\u0641\u0629 MySQL \u0647\u0648 \u0645\u0646 \u0623\u0639\u0644\u0649 \u0627\u0633\u062a\u062b\u0645\u0627\u0631\u0627\u062a \u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627 \u0627\u0644\u0648\u064a\u0628 \u0639\u0627\u0626\u062f\u064b\u0627\u060c \u0641\u0645\u0639\u0638\u0645 \u062a\u0637\u0628\u064a\u0642\u0627\u062a\u0643 \u062a\u0646\u0627\u0645 \u0639\u0644\u0649 \u0646\u0641\u0633 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0633\u0646\u0648\u0627\u062a \u0637\u0648\u064a\u0644\u0629.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>\u26a1 \u062a\u062d\u0633\u064a\u0646 MySQL 2026: 20 \u0625\u0639\u062f\u0627\u062f \u0644\u0632\u064a\u0627\u062f\u0629 \u0623\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a 300% \u0645\u0646 \u0636\u0628\u0637 innodb_buffer_pool \u0625\u0644\u0649 \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629\u060c \u0627\u062c\u0639\u0644 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u062a\u0637\u064a\u0631 MySQL \u0647\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0623\u0643\u062b\u0631 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u064b\u0627 \u0641\u064a \u0627\u0644\u0639\u0627\u0644\u0645&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":3239,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[273,280],"tags":[403,404,405,176,408,407,406,295],"class_list":["post-3232","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-273","category-280","tag-database","tag-innodb","tag-mycnf","tag-mysql","tag-performance","tag-woocommerce-db","tag-wordpress-database","tag-295"],"_links":{"self":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts\/3232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/comments?post=3232"}],"version-history":[{"count":1,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts\/3232\/revisions"}],"predecessor-version":[{"id":3257,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts\/3232\/revisions\/3257"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/media\/3239"}],"wp:attachment":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/media?parent=3232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/categories?post=3232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/tags?post=3232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}