{"id":1615,"date":"2021-03-15T13:53:00","date_gmt":"2021-03-15T13:53:00","guid":{"rendered":"https:\/\/3lmee.com\/blog\/computer\/%d9%85%d8%a7-%d9%87%d9%88-%d8%a7%d9%84%d9%81%d8%b1%d9%82-%d8%a8%d9%8a%d9%86-myisam-%d9%88-innodb\/1615\/"},"modified":"2021-03-19T02:42:29","modified_gmt":"2021-03-19T02:42:29","slug":"%d9%85%d8%a7-%d9%87%d9%88-%d8%a7%d9%84%d9%81%d8%b1%d9%82-%d8%a8%d9%8a%d9%86-myisam-%d9%88-innodb","status":"publish","type":"post","link":"https:\/\/3lmee.com\/blog\/%d9%85%d8%a7-%d9%87%d9%88-%d8%a7%d9%84%d9%81%d8%b1%d9%82-%d8%a8%d9%8a%d9%86-myisam-%d9%88-innodb\/","title":{"rendered":"\u0645\u0627 \u0647\u0648 \u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 MYISAM \u0648 InnoDb"},"content":{"rendered":"<div dir=\"rtl\" style=\"text-align: right;\">\n<h2><\/h2>\n<div><\/div>\n<div>\n<div><img decoding=\"async\" title=\"\u0645\u0627 \u0647\u0648 \u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 MYISAM \u0648 InnoDb\" src=\"http:\/\/www.nwahy.com\/upload\/2772014-458bd.png\" alt=\"\u0645\u0627 \u0647\u0648 \u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 MYISAM \u0648 InnoDb\" \/><\/div>\n<p>MyISAM \u0648 InnoDB \u0647\u064a \u0645\u062d\u0631\u0643\u0627\u062a \u0644\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0627\u0644\u0627\u062e\u062a\u0644\u0627\u0641\u0627\u062a \u0628\u064a\u0646\u0647\u0645 \u062a\u0643\u0648\u0646 \u0641\u064a \u0637\u0631\u064a\u0642\u0629 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u062e\u0632\u0646\u0629\u060c \u0643\u064a\u0641\u064a\u0629 \u062a\u062e\u0632\u064a\u0646\u0647\u0627\u060c \u0643\u064a\u0641\u064a\u0629 \u0627\u0644\u062a\u0639\u062f\u064a\u0644 \u0639\u0644\u064a\u0647\u0627\u060c \u0627\u0644\u0628\u062d\u062b \u0628\u0647\u0627\u060c \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u062a\u0627\u062d\u0629 \u0639\u0644\u064a\u0647\u0627<\/p>\n<p>1- MyISAM \u0639\u0645\u0648\u0645\u0627 \u0647\u0648 \u0644\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062a\u064a \u062a\u062d\u0645\u0644 \u0643\u0645\u064a\u0627\u062a \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062a\u0639\u062a\u0628\u0631 \u0645\u0639\u0642\u0648\u0644\u0629 \u0628\u0627\u0644\u0646\u0633\u0628\u0629 \u0644\u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a &#8211; \u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u064a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u0646\u0648\u0639\u064a\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0646\u0648\u0639\u064a\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u0646\u0641\u0630\u0629 \u0639\u0644\u064a\u0647\u0627 \u0643\u0645\u062b\u0627\u0644 : \u062c\u062f\u0648\u0644 \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 10 \u062d\u0642\u0648\u0644 \u0645\u0627 \u0628\u064a\u0646 \u0646\u0635 \u0648\u0631\u0642\u0645 \u060c \u0648\u0628\u062f\u0627\u062e\u0644\u0647 10,000 \u0646\u062a\u064a\u062c\u0629 .. \u064a\u0639\u062a\u0628\u0631 \u0645\u0639\u0642\u0648\u0644 \u0628\u0627\u0644\u0646\u0633\u0628\u0629 \u0644\u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a .<\/p>\n<p>\u0648 MyISAM \u062a\u062a\u0645\u064a\u0632 \u0628\u0627\u0644\u0633\u0631\u0639\u0629\u060c \u0648\u0642\u0644\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644 memory \u0645\u0642\u0627\u0631\u0646\u0629 \u0628\u0627\u0644 InnoDB \u0645\u0639 \u0645\u0644\u0627\u062d\u0638\u0629 \u0627\u0646\u0646\u0627 \u0646\u062a\u062d\u062f\u062b \u0639\u0646 \u0643\u0645\u064a\u0629 \u0628\u064a\u0627\u0646\u0627\u062a ( \u0628\u0627\u0644\u062d\u062c\u0645 \u0627\u0644\u0645\u0639\u0642\u0648\u0644 ) .<\/p>\n<p>2- InnoDB \u062a\u062a\u0645\u064a\u0632 \u0628\u062a\u0639\u0642\u064a\u062f \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u062a\u0627\u062d\u0629 \u0648\u062f\u0642\u062a\u0647\u0627 \u060c \u062a\u0633\u062a\u062e\u062f\u0645 \u0639\u0627\u0645\u0629 \u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0628\u0646\u0648\u0643 \u060c \u0627\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u060c \u0643\u0645\u064a\u0627\u062a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u060c \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0646\u062a\u0627\u0626\u062c \u0639\u062f\u064a\u062f\u0629 \u0648\u062d\u0642\u0648\u0644 \u0645\u062a\u0639\u062f\u062f\u0629\u060c \u0641\u0647\u064a \u0627\u0633\u0631\u0639 \u0641\u064a \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0643\u0645\u064a\u0627\u062a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u0639\u0644\u0649 \u0639\u0643\u0633 \u0643\u0645\u064a\u0627\u062a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0635\u063a\u064a\u0631\u0629 \u060c \u0641\u0647\u064a \u0627\u0628\u0637\u0623 \u0645\u0646 MyISAM \u0643\u0645\u0627 \u062a\u0633\u062a\u062e\u062f\u0645 \u062d\u064a\u0632 \u0643\u0628\u064a\u0631 \u0645\u0646 \u0627\u0644\u0645\u064a\u0645\u0648\u0631\u064a ( \u0648\u0644\u0647\u0630\u0627 \u064a\u0641\u0636\u0644 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0627 \u0627\u0644\u062d\u064a\u0632 \u0641\u064a \u0645\u0643\u0627\u0646\u0647 \u0627\u0644\u0635\u062d\u064a\u062d \u0627\u0648 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0641\u064a \u0645\u062d\u0644\u0647 &#8211; \u0643\u0645\u064a\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a ).<\/p>\n<p>\u0645\u0642\u0627\u0631\u0646\u0629 \u0633\u0631\u064a\u0639\u0629 \u0628\u064a\u0646 \u0627\u0644\u062e\u0648\u0627\u0635 \u0627\u0644\u0645\u062a\u0627\u062d\u0629 :<\/p>\n<p>3- MyISAM \u062a\u062f\u0639\u0645 \u062e\u0627\u0635\u064a\u0629 \u0627\u0644 Full text Search \u0628\u064a\u0646\u0645\u0627 InnoDB \u0644\u0627 \u062a\u062f\u0639\u0645\u0647\u0627 .<\/p>\n<p>4- InnoDB \u062a\u062f\u0639\u0645 \u0627\u0644 Transactions \u0648\u0647\u064a \u0646\u0648\u0639\u064a\u0629 \u0645\u0639\u0631\u0648\u0641\u0629 \u0645\u0646 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u0631\u062a\u0628\u0637\u0629 \u0628\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a &#8211; \u062a\u0633\u062a\u062e\u062f\u0645 \u063a\u0627\u0644\u0628\u0627 \u0644\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062c\u0627\u062f\u0629 \u0645\u062b\u0644 \u062a\u062d\u0648\u064a\u0644 \u0627\u0644\u0628\u0646\u0648\u0643\u060c \u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0628\u064a\u0639 \u0648\u0627\u0644\u0634\u0631\u0627\u0621 .. \u0648\u0645\u0646 \u0627\u0647\u0645 \u0645\u0645\u064a\u0632\u0627\u062a \u0627\u0644 RollBack \u0648\u0627\u0644\u062a\u064a \u062a\u062a\u064a\u062d \u0627\u0633\u062a\u0631\u062c\u0627\u0639 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u0646\u0641\u0630\u0629 \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0643\u0627\u0645\u0644\u0629 .. \u0643\u0623\u0646\u0647 \u0628\u0627\u0643 \u0627\u0628 \u062c\u0632\u0626\u064a .. \u0627\u0648 ctrl+z \u0644\u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a &#8211; \u0648\u0627\u0644\u062a\u064a \u0644\u0627 \u062a\u062f\u0639\u0645\u0647\u0627 \u0627\u0644 MyISAM<\/p>\n<p>5- InnoDB \u062a\u062f\u0639\u0645 \u0627\u0644 Foreign Keys \u0648\u062a\u062f\u0639\u0645 \u0631\u0628\u0637 \u062c\u062f\u0648\u0644\u064a\u0646 \u0627\u0648 \u0627\u0643\u062b\u0631 \u0645\u0646 \u062e\u0644\u0627\u0644 \u0645\u0641\u0627\u062a\u064a\u062d \u0627\u0648 \u062d\u0642\u0648\u0644 \u060c \u0648\u064a\u0643\u0648\u0646 \u0627\u0644\u0631\u0628\u0637 \u0628\u064a\u0646\u0647\u0645 \u062d\u0642\u064a\u0642\u064a \u0627\u0648 \u0645\u0634\u0631\u0648\u0637 constraints \u0648\u0644\u064a\u0633 \u0645\u062c\u0631\u062f virtual \u0643\u0645\u0627 \u0647\u064a \u0627\u0644\u062d\u0627\u0644\u0629 \u0641\u064a MyISAM .<\/p>\n<p>6- MyISAM \u062a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u062a\u0642\u0646\u064a\u0629 Table level locking \u0628\u064a\u0646\u0645\u0627 InnoDB \u062a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 Row level locking \u0648\u0644\u0643\u0644\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0627\u062a\u0647\u0627 \u0648\u0645\u0645\u064a\u0632\u0627\u062a\u0647\u0627 \u0648\u0639\u064a\u0648\u0628\u0647\u0627 .. \u0647\u0630\u0627 \u0627\u0644\u0631\u0627\u0628\u0637 \u0645\u0641\u064a\u062f \u0644\u0644\u0645\u0647\u062a\u0645\u064a\u0646 :<br \/>\n<a href=\"http:\/\/stackoverflow.com\/questions\/3462643\/why-is-table-level-locking-better-than-row-level-locking-for-large-tables\" target=\"'_blank'\" rel=\"noopener\">http:\/\/stackoverflow.com\/questions\/3462643\/why-is-table-level-locking-better-than-row-level-locking-for-large-tables<\/a><\/p>\n<p>7- \u0643\u0630\u0644\u0643 \u0647\u0646\u0627\u0643 \u0628\u0639\u0636 \u0627\u0644 datatypes \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a MyISAM \u0648\u063a\u064a\u0631 \u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a InnoDB<\/p>\n<p>\u0627\u062e\u064a\u0631\u0627 \u060c \u0627\u062a\u0648\u0642\u0639 \u0627\u0646\u0647 \u0645\u0646 \u0627\u0644\u0648\u0627\u0636\u062d \u0627\u0646 MyISAM \u0645\u0641\u064a\u062f\u0629 \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u064a \u062a\u062d\u0645\u0644 \u0628\u064a\u0627\u0646\u0627\u062a \u0642\u0644\u064a\u0644\u0629 ( \u0644\u0627 \u062a\u0641\u0647\u0645 \u0642\u0644\u064a\u0644\u0629 \u063a\u0644\u0637 ! ) \u0627\u0648 \u0627\u0644\u062a\u064a \u0639\u0644\u0649 \u0627\u0644\u0627\u0642\u0644 \u0644\u0644\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u064a \u0644\u0627 \u062a\u062d\u062a\u0627\u062c \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0639\u064a\u0646 \u0645\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0627\u062a InnoDB .<\/p>\n<p>\u0648\u0644\u0627 \u062a\u0646\u0633\u0649 \u0627\u0646 \u0627\u0644 MyISAM \u0641\u064a \u0627\u0644\u0646\u0647\u0627\u064a\u0629 \u0647\u0648 \u0627\u0644 default table type in MySQL \u0648\u0628\u0627\u0644\u0645\u0646\u0627\u0633\u0628\u0629 \u0641\u0647\u0648 \u062a\u0637\u0648\u064a\u0631 \u0644\u0645\u062d\u0631\u0643 &#8211; \u062a\u0645 \u0627\u0644\u063a\u0627\u0621\u0647 \u062d\u0627\u0644\u064a\u0627 &#8211; ISAM .<\/p>\n<div style=\"padding: 10px 0 10px 0;\"><a href=\"http:\/\/www.swalif.net\/softs\/swalif45\/softs294670\/\" target=\"_blank\" rel=\"noopener\">\u0627\u0644\u0645\u0635\u062f\u0631<\/a><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MyISAM \u0648 InnoDB \u0647\u064a \u0645\u062d\u0631\u0643\u0627\u062a \u0644\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0627\u0644\u0627\u062e\u062a\u0644\u0627\u0641\u0627\u062a \u0628\u064a\u0646\u0647\u0645 \u062a\u0643\u0648\u0646 \u0641\u064a \u0637\u0631\u064a\u0642\u0629 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639<\/p>\n","protected":false},"author":1,"featured_media":3124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-1615","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer"],"jetpack_featured_media_url":"https:\/\/3lmee.com\/blog\/wp-content\/uploads\/2021\/02\/Slide1-3.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/posts\/1615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/comments?post=1615"}],"version-history":[{"count":2,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/posts\/1615\/revisions"}],"predecessor-version":[{"id":3125,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/posts\/1615\/revisions\/3125"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/media\/3124"}],"wp:attachment":[{"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/media?parent=1615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/categories?post=1615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/3lmee.com\/blog\/wp-json\/wp\/v2\/tags?post=1615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}