{"id":2793,"date":"2026-03-16T20:20:29","date_gmt":"2026-03-16T13:20:29","guid":{"rendered":"https:\/\/himpro.info\/?p=2793"},"modified":"2026-03-16T20:23:34","modified_gmt":"2026-03-16T13:23:34","slug":"myisam-vs-innodb-%e0%b9%80%e0%b8%a5%e0%b8%b7%e0%b8%ad%e0%b8%81-storage-engine-%e0%b9%83%e0%b8%ab%e0%b9%89%e0%b8%96%e0%b8%b9%e0%b8%81%e0%b9%83%e0%b8%88-mysql","status":"publish","type":"post","link":"https:\/\/himpro.info\/?p=2793","title":{"rendered":"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL"},"content":{"rendered":"\n<p>\u0e40\u0e04\u0e22\u0e44\u0e2b\u0e21? \u0e23\u0e31\u0e19 Query \u0e40\u0e14\u0e34\u0e21 \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e17\u0e48\u0e32\u0e40\u0e14\u0e34\u0e21 \u0e41\u0e15\u0e48\u0e1e\u0e2d\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19 Storage Engine \u0e1b\u0e38\u0e4a\u0e1a \u0e40\u0e23\u0e47\u0e27\u0e02\u0e36\u0e49\u0e19\u0e40\u0e1b\u0e47\u0e19\u0e40\u0e17\u0e48\u0e32\u0e15\u0e31\u0e27!<\/p>\n\n\n\n<p>\u0e40\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e19\u0e35\u0e49\u0e40\u0e01\u0e34\u0e14\u0e02\u0e36\u0e49\u0e19\u0e08\u0e23\u0e34\u0e07\u0e01\u0e31\u0e1a\u0e1c\u0e21 \u0e40\u0e21\u0e37\u0e48\u0e2d\u0e2a\u0e31\u0e1b\u0e14\u0e32\u0e2b\u0e4c\u0e17\u0e35\u0e48\u0e41\u0e25\u0e49\u0e27 \u0e15\u0e32\u0e23\u0e32\u0e07 <code>sendrefer<\/code> \u0e02\u0e19\u0e32\u0e14 130,793 \u0e41\u0e16\u0e27 \u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49 MyISAM \u0e2d\u0e22\u0e39\u0e48 \u0e46 JOIN \u0e17\u0e35\u0e0a\u0e49\u0e32\u0e08\u0e19\u0e44\u0e14\u0e49 \u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e40\u0e1b\u0e47\u0e19 InnoDB \u0e40\u0e17\u0e48\u0e32\u0e19\u0e31\u0e49\u0e19\u0e41\u0e2b\u0e25\u0e30\u0e04\u0e23\u0e31\u0e1a Query \u0e17\u0e35\u0e48\u0e40\u0e04\u0e22\u0e43\u0e0a\u0e49\u0e40\u0e27\u0e25\u0e32\u0e40\u0e1b\u0e47\u0e19 10 \u0e27\u0e34\u0e19\u0e32\u0e17\u0e35 \u0e40\u0e2b\u0e25\u0e37\u0e2d\u0e2b\u0e25\u0e31\u0e01\u0e40\u0e2a\u0e35\u0e49\u0e22\u0e27\u0e27\u0e34\u0e19\u0e32\u0e17\u0e35\u0e17\u0e31\u0e19\u0e17\u0e35!<\/p>\n\n\n\n<p>\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e19\u0e35\u0e49\u0e08\u0e30\u0e1e\u0e32\u0e17\u0e38\u0e01\u0e04\u0e19\u0e44\u0e1b\u0e23\u0e39\u0e49\u0e08\u0e31\u0e01\u0e01\u0e31\u0e1a 2 Storage Engine \u0e22\u0e2d\u0e14\u0e2e\u0e34\u0e15\u0e02\u0e2d\u0e07 MySQL \u0e27\u0e48\u0e32\u0e21\u0e31\u0e19\u0e15\u0e48\u0e32\u0e07\u0e01\u0e31\u0e19\u0e22\u0e31\u0e07\u0e44\u0e07? \u0e40\u0e21\u0e37\u0e48\u0e2d\u0e44\u0e2b\u0e23\u0e48\u0e04\u0e27\u0e23\u0e43\u0e0a\u0e49\u0e2d\u0e30\u0e44\u0e23? \u0e41\u0e25\u0e30\u0e17\u0e33\u0e44\u0e21 InnoDB \u0e16\u0e36\u0e07\u0e40\u0e1b\u0e47\u0e19 Default \u0e43\u0e19\u0e1b\u0e31\u0e08\u0e08\u0e38\u0e1a\u0e31\u0e19<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 Storage Engine \u0e04\u0e37\u0e2d\u0e2d\u0e30\u0e44\u0e23?<\/h2>\n\n\n\n<p>Storage Engine \u0e40\u0e1b\u0e23\u0e35\u0e22\u0e1a\u0e40\u0e2a\u0e21\u0e37\u0e2d\u0e19 <strong>\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e22\u0e19\u0e15\u0e4c\u0e02\u0e2d\u0e07\u0e23\u0e16<\/strong> MySQL \u0e40\u0e1b\u0e47\u0e19\u0e15\u0e31\u0e27\u0e16\u0e31\u0e07 \u0e41\u0e15\u0e48\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e22\u0e19\u0e15\u0e4c\u0e04\u0e37\u0e2d\u0e2a\u0e34\u0e48\u0e07\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e27\u0e48\u0e32:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e08\u0e30\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e22\u0e31\u0e07\u0e44\u0e07?<\/li>\n\n\n\n<li>\u0e08\u0e30\u0e04\u0e49\u0e19\u0e2b\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e22\u0e31\u0e07\u0e44\u0e07?<\/li>\n\n\n\n<li>\u0e08\u0e30\u0e08\u0e31\u0e14\u0e01\u0e32\u0e23\u0e04\u0e27\u0e32\u0e21\u0e1b\u0e25\u0e2d\u0e14\u0e20\u0e31\u0e22\u0e02\u0e2d\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e22\u0e31\u0e07\u0e44\u0e07?<\/li>\n\n\n\n<li>\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e17\u0e33\u0e07\u0e32\u0e19\u0e1e\u0e23\u0e49\u0e2d\u0e21\u0e01\u0e31\u0e19\u0e01\u0e35\u0e48\u0e04\u0e19?<\/li>\n<\/ul>\n\n\n\n<p>MySQL \u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e2b\u0e25\u0e32\u0e22 Storage Engine \u0e41\u0e15\u0e48\u0e17\u0e35\u0e48\u0e19\u0e34\u0e22\u0e21\u0e2a\u0e38\u0e14\u0e04\u0e37\u0e2d <strong>MyISAM<\/strong> \u0e41\u0e25\u0e30 <strong>InnoDB<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udd9a \u0e15\u0e32\u0e23\u0e32\u0e07\u0e40\u0e1b\u0e23\u0e35\u0e22\u0e1a\u0e40\u0e17\u0e35\u0e22\u0e1a MyISAM vs InnoDB<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u0e04\u0e38\u0e13\u0e2a\u0e21\u0e1a\u0e31\u0e15\u0e34<\/th><th>MyISAM<\/th><th>InnoDB<\/th><\/tr><\/thead><tbody><tr><td><strong>\u0e01\u0e32\u0e23 Lock<\/strong><\/td><td>Table-level Lock (\u0e25\u0e47\u0e2d\u0e04\u0e17\u0e31\u0e49\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07)<\/td><td>Row-level Lock (\u0e25\u0e47\u0e2d\u0e04\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e41\u0e16\u0e27)<\/td><\/tr><tr><td><strong>Transaction (ACID)<\/strong><\/td><td>\u274c \u0e44\u0e21\u0e48\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a<\/td><td>\u2705 \u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a (COMMIT, ROLLBACK)<\/td><\/tr><tr><td><strong>Foreign Key<\/strong><\/td><td>\u274c \u0e44\u0e21\u0e48\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a<\/td><td>\u2705 \u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a<\/td><\/tr><tr><td><strong>Clustered Index<\/strong><\/td><td>\u274c \u0e44\u0e21\u0e48\u0e21\u0e35 (Heap-organized)<\/td><td>\u2705 \u0e21\u0e35 (Index-organized)<\/td><\/tr><tr><td><strong>Full-text Search<\/strong><\/td><td>\u2705 \u0e21\u0e35 (\u0e41\u0e15\u0e48\u0e23\u0e38\u0e48\u0e19\u0e40\u0e01\u0e48\u0e32)<\/td><td>\u2705 \u0e21\u0e35 (\u0e15\u0e31\u0e49\u0e07\u0e41\u0e15\u0e48 MySQL 5.6)<\/td><\/tr><tr><td><strong>Data Caching<\/strong><\/td><td>Cache \u0e40\u0e09\u0e1e\u0e32\u0e30 Index<\/td><td>Cache \u0e17\u0e31\u0e49\u0e07 Data \u0e41\u0e25\u0e30 Index<\/td><\/tr><tr><td><strong>Compression<\/strong><\/td><td>\u2705 \u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a<\/td><td>\u2705 \u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a (\u0e41\u0e15\u0e48\u0e0b\u0e31\u0e1a\u0e0b\u0e49\u0e2d\u0e19\u0e01\u0e27\u0e48\u0e32)<\/td><\/tr><tr><td><strong>\u0e04\u0e27\u0e32\u0e21\u0e40\u0e23\u0e47\u0e27\u0e43\u0e19\u0e01\u0e32\u0e23\u0e2d\u0e48\u0e32\u0e19<\/strong><\/td><td>\u26a1 \u0e40\u0e23\u0e47\u0e27\u0e21\u0e32\u0e01<\/td><td>\ud83d\ude80 \u0e40\u0e23\u0e47\u0e27 (\u0e16\u0e49\u0e32\u0e43\u0e0a\u0e49 Index \u0e16\u0e39\u0e01)<\/td><\/tr><tr><td><strong>\u0e04\u0e27\u0e32\u0e21\u0e40\u0e23\u0e47\u0e27\u0e43\u0e19\u0e01\u0e32\u0e23\u0e40\u0e02\u0e35\u0e22\u0e19<\/strong><\/td><td>\ud83d\udc22 \u0e0a\u0e49\u0e32 (\u0e25\u0e47\u0e2d\u0e04\u0e17\u0e31\u0e49\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07)<\/td><td>\u26a1 \u0e40\u0e23\u0e47\u0e27 (\u0e25\u0e47\u0e2d\u0e04\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e41\u0e16\u0e27)<\/td><\/tr><tr><td><strong>\u0e1e\u0e37\u0e49\u0e19\u0e17\u0e35\u0e48\u0e08\u0e31\u0e14\u0e40\u0e01\u0e47\u0e1a<\/strong><\/td><td>\ud83d\udcbe \u0e19\u0e49\u0e2d\u0e22\u0e01\u0e27\u0e48\u0e32<\/td><td>\ud83d\udcbf \u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 (\u0e21\u0e35 overhead)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd2c \u0e40\u0e08\u0e32\u0e30\u0e25\u0e36\u0e01\u0e04\u0e27\u0e32\u0e21\u0e41\u0e15\u0e01\u0e15\u0e48\u0e32\u0e07<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>\u0e01\u0e32\u0e23 Lock \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25<\/strong> \ud83d\udd12<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- MyISAM: \u0e40\u0e27\u0e25\u0e32\u0e2d\u0e31\u0e1e\u0e40\u0e14\u0e17 \u0e08\u0e30\u0e25\u0e47\u0e2d\u0e04 TABLE \u0e17\u0e31\u0e49\u0e07 table\nUPDATE myisam_table SET status = 1 WHERE id = 5;\n-- \u0e15\u0e2d\u0e19\u0e19\u0e35\u0e49 TABLE myisam_table \u0e42\u0e14\u0e19\u0e25\u0e47\u0e2d\u0e04\u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14!\n-- \u0e04\u0e19\u0e2d\u0e37\u0e48\u0e19\u0e08\u0e30 SELECT \u0e2b\u0e23\u0e37\u0e2d UPDATE \u0e44\u0e21\u0e48\u0e44\u0e14\u0e49 \u0e08\u0e19\u0e01\u0e27\u0e48\u0e32\u0e08\u0e30\u0e40\u0e2a\u0e23\u0e47\u0e08\n\n-- InnoDB: \u0e25\u0e47\u0e2d\u0e04\u0e40\u0e09\u0e1e\u0e32\u0e30 ROW\nUPDATE innodb_table SET status = 1 WHERE id = 5;\n-- \u0e25\u0e47\u0e2d\u0e04\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e41\u0e16\u0e27 id=5\n-- \u0e04\u0e19\u0e2d\u0e37\u0e48\u0e19 UPDATE \u0e41\u0e16\u0e27 id=6 \u0e44\u0e14\u0e49\u0e1b\u0e01\u0e15\u0e34!<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>Clustered Index vs Heap-organized<\/strong> \ud83d\udcda<\/h3>\n\n\n\n<p><strong>MyISAM (Heap-organized):<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">Primary Key Index     Data File\n[id: 5] ------&gt; [Address: 0x7F8A] ------&gt; [5 | Somchai | 50000]\n[id: 8] ------&gt; [Address: 0x7F9B] ------&gt; [8 | Somsak  | 60000]<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e15\u0e49\u0e2d\u0e07\u0e04\u0e49\u0e19\u0e2b\u0e32 2 \u0e23\u0e2d\u0e1a: Index \u2192 Address \u2192 Data<\/li>\n<\/ul>\n\n\n\n<p><strong>InnoDB (Clustered Index):<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">Primary Key Index + Data\n[id: 5 | Somchai | 50000]  [id: 8 | Somsak | 60000]<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2d\u0e22\u0e39\u0e48\u0e01\u0e31\u0e1a index! \u0e04\u0e49\u0e19\u0e2b\u0e32\u0e40\u0e08\u0e2d\u0e1b\u0e38\u0e4a\u0e1a \u0e44\u0e14\u0e49\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1b\u0e31\u0e4a\u0e1a<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>Buffer Pool vs Key Cache<\/strong> \ud83d\uddc3\ufe0f<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- InnoDB: \u0e21\u0e35 Buffer Pool \u0e43\u0e2b\u0e0d\u0e48\u0e46 \u0e44\u0e27\u0e49 cache \u0e17\u0e38\u0e01\u0e2d\u0e22\u0e48\u0e32\u0e07\nSHOW VARIABLES LIKE 'innodb_buffer_pool_size';\n-- \u0e1c\u0e25: 134217728 (128MB) - cache \u0e17\u0e31\u0e49\u0e07 data \u0e41\u0e25\u0e30 index\n\n-- MyISAM: \u0e21\u0e35 Key Cache \u0e40\u0e09\u0e1e\u0e32\u0e30 index\nSHOW VARIABLES LIKE 'key_buffer_size';\n-- \u0e1c\u0e25: 8388608 (8MB) - cache \u0e40\u0e09\u0e1e\u0e32\u0e30 index\n-- data \u0e15\u0e49\u0e2d\u0e07\u0e2d\u0e48\u0e32\u0e19\u0e08\u0e32\u0e01 disk \u0e15\u0e25\u0e2d\u0e14<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcca \u0e17\u0e14\u0e2a\u0e2d\u0e1a Performance \u0e08\u0e23\u0e34\u0e07<\/h2>\n\n\n\n<p>\u0e2a\u0e21\u0e21\u0e15\u0e34\u6211\u4eec\u6709 2 \u0e15\u0e32\u0e23\u0e32\u0e07:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- MyISAM\nCREATE TABLE users_myisam (\n    id INT PRIMARY KEY,\n    name VARCHAR(100),\n    salary DECIMAL(10,2)\n) ENGINE=MyISAM;\n\n-- InnoDB\nCREATE TABLE users_innodb (\n    id INT PRIMARY KEY,\n    name VARCHAR(100),\n    salary DECIMAL(10,2)\n) ENGINE=InnoDB;\n\n-- \u0e43\u0e2a\u0e48\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 1 \u0e25\u0e49\u0e32\u0e19\u0e41\u0e16\u0e27\u0e40\u0e2b\u0e21\u0e37\u0e2d\u0e19\u0e01\u0e31\u0e19<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0e17\u0e14\u0e2a\u0e2d\u0e1a\u0e17\u0e35\u0e48 1: SELECT with JOIN<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- MyISAM\nEXPLAIN SELECT * FROM users_myisam u\nJOIN orders_myisam o ON u.id = o.user_id;\n-- type: ALL, rows: 1,000,000\n-- Extra: Using join buffer (Block Nested Loop)\n\n-- InnoDB\nEXPLAIN SELECT * FROM users_innodb u\nJOIN orders_innodb o ON u.id = o.user_id;\n-- type: eq_ref, rows: 1\n-- Extra: Using index<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0e17\u0e14\u0e2a\u0e2d\u0e1a\u0e17\u0e35\u0e48 2: UPDATE \u0e1e\u0e23\u0e49\u0e2d\u0e21\u0e01\u0e31\u0e19\u0e2b\u0e25\u0e32\u0e22\u0e46 \u0e04\u0e19<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- Connection 1: MyISAM\nUPDATE users_myisam SET salary = 100000 WHERE id = 5;\n-- \u274c Connection 2 \u0e15\u0e49\u0e2d\u0e07\u0e23\u0e2d\u0e08\u0e19\u0e01\u0e27\u0e48\u0e32 Connection 1 \u0e08\u0e30 COMMIT\n\n-- Connection 1: InnoDB\nUPDATE users_innodb SET salary = 100000 WHERE id = 5;\n-- \u2705 Connection 2 UPDATE id=6 \u0e44\u0e14\u0e49\u0e17\u0e31\u0e19\u0e17\u0e35 \u0e44\u0e21\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e23\u0e2d!<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfaf \u0e40\u0e25\u0e37\u0e2d\u0e01\u0e43\u0e0a\u0e49\u0e41\u0e1a\u0e1a\u0e44\u0e2b\u0e19\u0e14\u0e35?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 <strong>MyISAM \u0e40\u0e2b\u0e21\u0e32\u0e30\u0e01\u0e31\u0e1a:<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Data Warehouse \/ Read-only<\/strong> &#8211; \u0e2d\u0e48\u0e32\u0e19\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e40\u0e14\u0e35\u0e22\u0e27 \u0e44\u0e21\u0e48\u0e21\u0e35\u0e40\u0e02\u0e35\u0e22\u0e19<\/li>\n\n\n\n<li><strong>\u0e23\u0e30\u0e1a\u0e1a Log<\/strong> &#8211; INSERT \u0e2d\u0e22\u0e48\u0e32\u0e07\u0e40\u0e14\u0e35\u0e22\u0e27 \u0e44\u0e21\u0e48\u0e21\u0e35 UPDATE<\/li>\n\n\n\n<li><strong>\u0e15\u0e32\u0e23\u0e32\u0e07\u0e40\u0e25\u0e47\u0e01\u0e46<\/strong> &#8211; \u0e44\u0e21\u0e48\u0e40\u0e01\u0e34\u0e19 100,000 \u0e41\u0e16\u0e27<\/li>\n\n\n\n<li><strong>Full-text Search<\/strong> (\u0e43\u0e19 MySQL \u0e23\u0e38\u0e48\u0e19\u0e40\u0e01\u0e48\u0e32\u0e46)<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- \u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 Data Warehouse \u0e17\u0e35\u0e48\u0e40\u0e2b\u0e21\u0e32\u0e30\u0e01\u0e31\u0e1a MyISAM\nCREATE TABLE sales_summary_2019 (\n    month INT,\n    total_sales DECIMAL(15,2),\n    total_customers INT\n) ENGINE=MyISAM;\n-- INSERT \u0e40\u0e14\u0e37\u0e2d\u0e19\u0e25\u0e30\u0e04\u0e23\u0e31\u0e49\u0e07, SELECT \u0e15\u0e25\u0e2d\u0e14\u0e17\u0e31\u0e49\u0e07\u0e1b\u0e35<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 <strong>InnoDB \u0e40\u0e2b\u0e21\u0e32\u0e30\u0e01\u0e31\u0e1a:<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u0e23\u0e30\u0e1a\u0e1a Transaction<\/strong> &#8211; \u0e01\u0e32\u0e23\u0e40\u0e07\u0e34\u0e19, E-commerce, ERP<\/li>\n\n\n\n<li><strong>\u0e23\u0e30\u0e1a\u0e1a\u0e17\u0e35\u0e48\u0e21\u0e35 User \u0e40\ufffd \u062a\u0637\u0628\u06cc\u0642 \ub9ce\uc74c<\/strong> &#8211; Web application, Mobile backend<\/li>\n\n\n\n<li><strong>\u0e15\u0e32\u0e23\u0e32\u0e07\u0e17\u0e35\u0e48\u0e21\u0e35 UPDATE\/DELETE \u0e1a\u0e48\u0e2d\u0e22<\/strong><\/li>\n\n\n\n<li><strong>\u0e23\u0e30\u0e1a\u0e1a\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e21\u0e35 Foreign Key<\/strong> &#8211; \u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23 Data Integrity<\/li>\n\n\n\n<li><strong>\u0e17\u0e38\u0e01\u0e2d\u0e22\u0e48\u0e32\u0e07!<\/strong> (\u0e40\u0e1e\u0e23\u0e32\u0e30\u0e40\u0e1b\u0e47\u0e19 default \u0e41\u0e25\u0e49\u0e27)<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- \u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e23\u0e30\u0e1a\u0e1a E-commerce \u0e17\u0e35\u0e48\u0e40\u0e2b\u0e21\u0e32\u0e30\u0e01\u0e31\u0e1a InnoDB\nCREATE TABLE orders (\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    user_id INT,\n    total DECIMAL(15,2),\n    status VARCHAR(20),\n    created_at DATETIME,\n    FOREIGN KEY (user_id) REFERENCES users(id)\n) ENGINE=InnoDB;\n-- \u0e21\u0e35 INSERT, UPDATE, DELETE \u0e15\u0e25\u0e2d\u0e14\u0e40\u0e27\u0e25\u0e32\n-- \u0e15\u0e49\u0e2d\u0e07\u4fdd\u4f4f data integrity<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udea8 \u0e40\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e23\u0e39\u0e49\u0e01\u0e48\u0e2d\u0e19\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19 Engine<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>Full-text Search<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MyISAM \u0e21\u0e35 Full-text \u0e21\u0e32\u0e19\u0e32\u0e19<\/li>\n\n\n\n<li>InnoDB \u0e21\u0e35 Full-text \u0e15\u0e31\u0e49\u0e07\u0e41\u0e15\u0e48 MySQL 5.6<\/li>\n\n\n\n<li>\u0e16\u0e49\u0e32\u0e43\u0e0a\u0e49 Full-text \u0e2d\u0e22\u0e39\u0e48 \u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a version \u0e01\u0e48\u0e2d\u0e19\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2. ** AUTO_INCREMENT behavior**<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- MyISAM: AUTO_INCREMENT \u0e40\u0e23\u0e47\u0e27\u0e21\u0e32\u0e01\n-- InnoDB: AUTO_INCREMENT \u0e0a\u0e49\u0e32\u0e01\u0e27\u0e48\u0e32 (\u0e15\u0e49\u0e2d\u0e07 lock special table)\n\n-- \u0e41\u0e15\u0e48 InnoDB \u0e21\u0e35\u0e02\u0e49\u0e2d\u0e14\u0e35: INSERT \u0e1e\u0e23\u0e49\u0e2d\u0e21\u0e01\u0e31\u0e19\u0e2b\u0e25\u0e32\u0e22\u0e46 \u0e41\u0e16\u0e27\u0e44\u0e14\u0e49!<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>Space Usage<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- InnoDB \u0e43\u0e0a\u0e49\u0e1e\u0e37\u0e49\u0e19\u0e17\u0e35\u0e48\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 ~20-30%\nSELECT \n    table_name,\n    ROUND(((data_length + index_length) \/ 1024 \/ 1024), 2) AS 'Size (MB)'\nFROM information_schema.tables\nWHERE table_schema = 'your_db';\n-- MyISAM table \u0e02\u0e19\u0e32\u0e14 100MB\n-- InnoDB table \u0e40\u0e14\u0e35\u0e22\u0e27\u0e01\u0e31\u0e19 \u0e02\u0e19\u0e32\u0e14 120-130MB<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>COUNT(*) Performance<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- MyISAM: COUNT(*) \u0e40\u0e23\u0e47\u0e27\u0e21\u0e32\u0e01 (cache \u0e04\u0e48\u0e32\u0e44\u0e27\u0e49)\nSELECT COUNT(*) FROM big_table_myisam; -- 0.001 \u0e27\u0e34\u0e19\u0e32\u0e17\u0e35\n\n-- InnoDB: COUNT(*) \u0e15\u0e49\u0e2d\u0e07\u0e19\u0e31\u0e1a\u0e08\u0e23\u0e34\u0e07 (\u0e40\u0e1e\u0e23\u0e32\u0e30 MVCC)\nSELECT COUNT(*) FROM big_table_innodb; -- 2.5 \u0e27\u0e34\u0e19\u0e32\u0e17\u0e35\n\n-- \u0e41\u0e15\u0e48 InnoDB \u0e41\u0e01\u0e49\u0e44\u0e14\u0e49\u0e14\u0e49\u0e27\u0e22:\nSELECT COUNT(*) FROM big_table_innodb WHERE id &gt; 1000; -- \u0e40\u0e23\u0e47\u0e27<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udee0\ufe0f \u0e27\u0e34\u0e18\u0e35\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19 Engine (step-by-step)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>\u0e2b\u0e32\u0e43\u0e2b\u0e49\u0e40\u0e08\u0e2d\u0e27\u0e48\u0e32\u0e21\u0e35\u0e15\u0e32\u0e23\u0e32\u0e07\u0e44\u0e2b\u0e19\u0e43\u0e0a\u0e49 MyISAM \u0e1a\u0e49\u0e32\u0e07<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT \n    table_schema AS database_name,\n    table_name,\n    engine\nFROM information_schema.tables\nWHERE engine = 'MyISAM'\nAND table_schema NOT IN ('information_schema', 'mysql', \n                         'performance_schema', 'sys');<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\"># Backup \u0e01\u0e48\u0e2d\u0e19\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e40\u0e2a\u0e21\u0e2d!\nmysqldump -u root -p your_database &gt; backup_before_change.sql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>\u0e40\u0e23\u0e34\u0e48\u0e21\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e17\u0e35\u0e25\u0e30\u0e15\u0e32\u0e23\u0e32\u0e07<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- \u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e17\u0e35\u0e25\u0e30\u0e15\u0e32\u0e23\u0e32\u0e07 (\u0e41\u0e19\u0e30\u0e19\u0e33)\nALTER TABLE your_table ENGINE = InnoDB;\n\n-- \u0e2b\u0e23\u0e37\u0e2d\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u0e2d\u0e31\u0e15\u0e42\u0e19\u0e21\u0e31\u0e15\u0e34\nSELECT CONCAT('ALTER TABLE ', table_schema, '.', table_name, \n              ' ENGINE = InnoDB;') AS alter_command\nFROM information_schema.tables\nWHERE engine = 'MyISAM';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>\u0e2d\u0e31\u0e1e\u0e40\u0e14\u0e17\u0e2a\u0e16\u0e34\u0e15\u0e34<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">ANALYZE TABLE your_table;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5. <strong>\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">EXPLAIN SELECT your_query;\n-- \u0e14\u0e39\u0e27\u0e48\u0e32 type \u0e14\u0e35\u0e02\u0e36\u0e49\u0e19, rows \u0e25\u0e14\u0e25\u0e07\u0e21\u0e31\u0e49\u0e22<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udca1 \u0e40\u0e04\u0e25\u0e47\u0e14\u0e25\u0e31\u0e1a\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e1b\u0e23\u0e30\u0e2a\u0e34\u0e17\u0e18\u0e34\u0e20\u0e32\u0e1e InnoDB<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>\u0e1b\u0e23\u0e31\u0e1a Buffer Pool<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\"># my.cnf<\/code><\/pre>\n\n\n<p>[mysqld]<\/p>\n\n\n\n<p># \u0e15\u0e31\u0e49\u0e07\u0e43\u0e2b\u0e49\u0e1b\u0e23\u0e30\u0e21\u0e32\u0e13 70-80% \u0e02\u0e2d\u0e07 RAM innodb_buffer_pool_size = 4G # \u0e16\u0e49\u0e32 RAM &gt; 16GB \u0e43\u0e2b\u0e49\u0e41\u0e22\u0e01 instance innodb_buffer_pool_instances = 4<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>\u0e43\u0e0a\u0e49 Index \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- \u0e2a\u0e23\u0e49\u0e32\u0e07 composite index \u0e43\u0e2b\u0e49\u0e15\u0e23\u0e07\u0e01\u0e31\u0e1a WHERE\nALTER TABLE your_table \nADD INDEX idx_composite (col1, col2, col3);\n-- \u0e44\u0e21\u0e48\u0e43\u0e0a\u0e48 index \u0e17\u0e35\u0e25\u0e30 col \u0e41\u0e22\u0e01\u0e01\u0e31\u0e19<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>\u0e40\u0e25\u0e37\u0e2d\u0e01 Data Type \u0e43\u0e2b\u0e49\u0e40\u0e2b\u0e21\u0e32\u0e30\u0e2a\u0e21<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">-- \u0e43\u0e0a\u0e49 INT \u0e41\u0e17\u0e19 VARCHAR \u0e16\u0e49\u0e32\u0e40\u0e01\u0e47\u0e1a\u0e15\u0e31\u0e27\u0e40\u0e25\u0e02\n-- \u0e43\u0e0a\u0e49 DATE\/DATETIME \u0e41\u0e17\u0e19 VARCHAR \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\n\n-- \u0e44\u0e21\u0e48\u0e14\u0e35\nCREATE TABLE bad (\n    user_id VARCHAR(20),\n    reg_date VARCHAR(20)\n);\n\n-- \u0e14\u0e35\nCREATE TABLE good (\n    user_id INT,\n    reg_date DATE\n);<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfc1 \u0e2a\u0e23\u0e38\u0e1b<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u0e22\u0e38\u0e04<\/th><th>Storage Engine \u0e17\u0e35\u0e48\u0e19\u0e34\u0e22\u0e21<\/th><\/tr><\/thead><tbody><tr><td>MySQL 3.x &#8211; 5.0<\/td><td>MyISAM \u0e04\u0e34\u0e07<\/td><\/tr><tr><td>MySQL 5.1 &#8211; 5.5<\/td><td>MyISAM + InnoDB<\/td><\/tr><tr><td>MySQL 5.6+<\/td><td>InnoDB default<\/td><\/tr><tr><td>MySQL 8.0<\/td><td>InnoDB \u0e40\u0e17\u0e48\u0e32\u0e19\u0e31\u0e49\u0e19!<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>InnoDB \u0e0a\u0e19\u0e30\u0e02\u0e32\u0e14\u0e43\u0e19\u0e17\u0e38\u0e01\u0e14\u0e49\u0e32\u0e19<\/strong> \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e22\u0e38\u0e04\u0e2a\u0e21\u0e31\u0e22\u0e19\u0e35\u0e49:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 Row-level locking<\/li>\n\n\n\n<li>\u2705 Transaction support<\/li>\n\n\n\n<li>\u2705 Foreign key<\/li>\n\n\n\n<li>\u2705 Crash recovery<\/li>\n\n\n\n<li>\u2705 ACID compliance<\/li>\n<\/ul>\n\n\n\n<p><strong>MyISAM<\/strong> \u0e22\u0e31\u0e07\u0e21\u0e35\u0e17\u0e35\u0e48\u0e17\u0e32\u0e07\u0e41\u0e04\u0e48\u0e01\u0e23\u0e13\u0e35\u0e40\u0e09\u0e1e\u0e32\u0e30 \u0e40\u0e0a\u0e48\u0e19:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e15\u0e32\u0e23\u0e32\u0e07\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19 read-only<\/li>\n\n\n\n<li>\u0e23\u0e30\u0e1a\u0e1a data warehouse \u0e17\u0e35\u0e48 bulk insert \u0e41\u0e25\u0e49\u0e27\u0e2d\u0e48\u0e32\u0e19\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e40\u0e14\u0e35\u0e22\u0e27<\/li>\n\n\n\n<li>MySQL \u0e23\u0e38\u0e48\u0e19\u0e40\u0e01\u0e48\u0e32\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23 full-text search<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcdd \u0e17\u0e34\u0e49\u0e07\u0e17\u0e49\u0e32\u0e22<\/h2>\n\n\n\n<p>\u0e08\u0e32\u0e01\u0e1b\u0e23\u0e30\u0e2a\u0e1a\u0e01\u0e32\u0e23\u0e13\u0e4c\u0e08\u0e23\u0e34\u0e07\u0e17\u0e35\u0e48\u0e1c\u0e21\u0e40\u0e08\u0e2d\u0e21\u0e32 \u0e01\u0e32\u0e23\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e08\u0e32\u0e01 MyISAM \u2192 InnoDB \u0e43\u0e2b\u0e49\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e17\u0e35\u0e48\u0e19\u0e48\u0e32\u0e17\u0e36\u0e48\u0e07\u0e21\u0e32\u0e01 Query \u0e17\u0e35\u0e48\u0e40\u0e04\u0e22\u0e0a\u0e49\u0e32\u0e15\u0e34\u0e14\u0e25\u0e21 \u0e01\u0e25\u0e32\u0e22\u0e40\u0e1b\u0e47\u0e19\u0e44\u0e27\u0e1b\u0e23\u0e37\u0e4b\u0e2d<\/p>\n\n\n\n<p>\u0e41\u0e15\u0e48\u2026 \u0e01\u0e47\u0e44\u0e21\u0e48\u0e40\u0e2a\u0e21\u0e2d\u0e44\u0e1b\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a! \u0e1a\u0e32\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07 MyISAM \u0e01\u0e47\u0e22\u0e31\u0e07\u0e40\u0e2b\u0e19\u0e37\u0e2d\u0e01\u0e27\u0e48\u0e32 \u0e42\u0e14\u0e22\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e01\u0e32\u0e23 <code>COUNT(*)<\/code> \u0e17\u0e31\u0e49\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 \u0e2b\u0e23\u0e37\u0e2d\u0e01\u0e32\u0e23\u0e17\u0e33 full-text search \u0e43\u0e19 MySQL \u0e23\u0e38\u0e48\u0e19\u0e40\u0e01\u0e48\u0e32<\/p>\n\n\n\n<p><strong>\u0e14\u0e31\u0e07\u0e19\u0e31\u0e49\u0e19:<\/strong> \u0e43\u0e0a\u0e49 InnoDB \u0e40\u0e1b\u0e47\u0e19 default \u0e41\u0e15\u0e48\u0e40\u0e02\u0e49\u0e32\u0e43\u0e08 MyISAM \u0e44\u0e27\u0e49\u0e40\u0e1c\u0e37\u0e48\u0e2d\u0e01\u0e23\u0e13\u0e35\u0e1e\u0e34\u0e40\u0e28\u0e29<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd17 \u0e2d\u0e49\u0e32\u0e07\u0e2d\u0e34\u0e07<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/storage-engines.html\">MySQL Documentation: Storage Engines<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.example.com\">MySQL InnoDB vs MyISAM: \u0e01\u0e32\u0e23\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e43\u0e0a\u0e49\u0e43\u0e2b\u0e49\u0e40\u0e2b\u0e21\u0e32\u0e30\u0e2a\u0e21<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0e40\u0e04\u0e22\u0e44\u0e2b\u0e21? \u0e23\u0e31\u0e19 Que&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2794,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2793","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL - Himpro<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/himpro.info\/?p=2793\" \/>\n<meta property=\"og:locale\" content=\"th_TH\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL - Himpro\" \/>\n<meta property=\"og:description\" content=\"\u0e40\u0e04\u0e22\u0e44\u0e2b\u0e21? \u0e23\u0e31\u0e19 Que...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/himpro.info\/?p=2793\" \/>\n<meta property=\"og:site_name\" content=\"Himpro\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/himpro.his\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-16T13:20:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-16T13:23:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1400\" \/>\n\t<meta property=\"og:image:height\" content=\"650\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u0e19\u0e32\u0e17\u0e35\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/himpro.info\/?p=2793#article\",\"isPartOf\":{\"@id\":\"https:\/\/himpro.info\/?p=2793\"},\"author\":{\"name\":\"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d\",\"@id\":\"https:\/\/himpro.info\/#\/schema\/person\/b7023aeeb9284d3e9cf67e183945debf\"},\"headline\":\"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL\",\"datePublished\":\"2026-03-16T13:20:29+00:00\",\"dateModified\":\"2026-03-16T13:23:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/himpro.info\/?p=2793\"},\"wordCount\":212,\"publisher\":{\"@id\":\"https:\/\/himpro.info\/#organization\"},\"image\":{\"@id\":\"https:\/\/himpro.info\/?p=2793#primaryimage\"},\"thumbnailUrl\":\"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"th\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/himpro.info\/?p=2793\",\"url\":\"https:\/\/himpro.info\/?p=2793\",\"name\":\"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL - Himpro\",\"isPartOf\":{\"@id\":\"https:\/\/himpro.info\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/himpro.info\/?p=2793#primaryimage\"},\"image\":{\"@id\":\"https:\/\/himpro.info\/?p=2793#primaryimage\"},\"thumbnailUrl\":\"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png\",\"datePublished\":\"2026-03-16T13:20:29+00:00\",\"dateModified\":\"2026-03-16T13:23:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/himpro.info\/?p=2793#breadcrumb\"},\"inLanguage\":\"th\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/himpro.info\/?p=2793\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"th\",\"@id\":\"https:\/\/himpro.info\/?p=2793#primaryimage\",\"url\":\"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png\",\"contentUrl\":\"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png\",\"width\":1400,\"height\":650},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/himpro.info\/?p=2793#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/himpro.info\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/himpro.info\/#website\",\"url\":\"https:\/\/himpro.info\/\",\"name\":\"Himpro\",\"description\":\"Hospital Infomation Managment Professional\",\"publisher\":{\"@id\":\"https:\/\/himpro.info\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/himpro.info\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"th\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/himpro.info\/#organization\",\"name\":\"Himpro co.,ltd\",\"url\":\"https:\/\/himpro.info\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"th\",\"@id\":\"https:\/\/himpro.info\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/himpro.info\/wp-content\/uploads\/2020\/06\/himpro_icon.png\",\"contentUrl\":\"https:\/\/himpro.info\/wp-content\/uploads\/2020\/06\/himpro_icon.png\",\"width\":512,\"height\":512,\"caption\":\"Himpro co.,ltd\"},\"image\":{\"@id\":\"https:\/\/himpro.info\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/himpro.his\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/himpro.info\/#\/schema\/person\/b7023aeeb9284d3e9cf67e183945debf\",\"name\":\"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"th\",\"@id\":\"https:\/\/himpro.info\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4a9d9807cf1627da009f2911f9791061?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4a9d9807cf1627da009f2911f9791061?s=96&d=identicon&r=g\",\"caption\":\"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d\"},\"sameAs\":[\"https:\/\/himpro.info\"],\"url\":\"https:\/\/himpro.info\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL - Himpro","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/himpro.info\/?p=2793","og_locale":"th_TH","og_type":"article","og_title":"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL - Himpro","og_description":"\u0e40\u0e04\u0e22\u0e44\u0e2b\u0e21? \u0e23\u0e31\u0e19 Que...","og_url":"https:\/\/himpro.info\/?p=2793","og_site_name":"Himpro","article_publisher":"https:\/\/www.facebook.com\/himpro.his","article_published_time":"2026-03-16T13:20:29+00:00","article_modified_time":"2026-03-16T13:23:34+00:00","og_image":[{"width":1400,"height":650,"url":"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png","type":"image\/png"}],"author":"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d","Est. reading time":"3 \u0e19\u0e32\u0e17\u0e35"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/himpro.info\/?p=2793#article","isPartOf":{"@id":"https:\/\/himpro.info\/?p=2793"},"author":{"name":"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d","@id":"https:\/\/himpro.info\/#\/schema\/person\/b7023aeeb9284d3e9cf67e183945debf"},"headline":"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL","datePublished":"2026-03-16T13:20:29+00:00","dateModified":"2026-03-16T13:23:34+00:00","mainEntityOfPage":{"@id":"https:\/\/himpro.info\/?p=2793"},"wordCount":212,"publisher":{"@id":"https:\/\/himpro.info\/#organization"},"image":{"@id":"https:\/\/himpro.info\/?p=2793#primaryimage"},"thumbnailUrl":"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png","articleSection":["Blog"],"inLanguage":"th"},{"@type":"WebPage","@id":"https:\/\/himpro.info\/?p=2793","url":"https:\/\/himpro.info\/?p=2793","name":"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL - Himpro","isPartOf":{"@id":"https:\/\/himpro.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/himpro.info\/?p=2793#primaryimage"},"image":{"@id":"https:\/\/himpro.info\/?p=2793#primaryimage"},"thumbnailUrl":"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png","datePublished":"2026-03-16T13:20:29+00:00","dateModified":"2026-03-16T13:23:34+00:00","breadcrumb":{"@id":"https:\/\/himpro.info\/?p=2793#breadcrumb"},"inLanguage":"th","potentialAction":[{"@type":"ReadAction","target":["https:\/\/himpro.info\/?p=2793"]}]},{"@type":"ImageObject","inLanguage":"th","@id":"https:\/\/himpro.info\/?p=2793#primaryimage","url":"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png","contentUrl":"https:\/\/himpro.info\/wp-content\/uploads\/2026\/03\/myisam-convert-innodb-storage-engine-wordpress.png","width":1400,"height":650},{"@type":"BreadcrumbList","@id":"https:\/\/himpro.info\/?p=2793#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/himpro.info\/"},{"@type":"ListItem","position":2,"name":"MyISAM vs InnoDB: \u0e40\u0e25\u0e37\u0e2d\u0e01 Storage Engine \u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e43\u0e08 MySQL"}]},{"@type":"WebSite","@id":"https:\/\/himpro.info\/#website","url":"https:\/\/himpro.info\/","name":"Himpro","description":"Hospital Infomation Managment Professional","publisher":{"@id":"https:\/\/himpro.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/himpro.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"th"},{"@type":"Organization","@id":"https:\/\/himpro.info\/#organization","name":"Himpro co.,ltd","url":"https:\/\/himpro.info\/","logo":{"@type":"ImageObject","inLanguage":"th","@id":"https:\/\/himpro.info\/#\/schema\/logo\/image\/","url":"https:\/\/himpro.info\/wp-content\/uploads\/2020\/06\/himpro_icon.png","contentUrl":"https:\/\/himpro.info\/wp-content\/uploads\/2020\/06\/himpro_icon.png","width":512,"height":512,"caption":"Himpro co.,ltd"},"image":{"@id":"https:\/\/himpro.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/himpro.his"]},{"@type":"Person","@id":"https:\/\/himpro.info\/#\/schema\/person\/b7023aeeb9284d3e9cf67e183945debf","name":"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d","image":{"@type":"ImageObject","inLanguage":"th","@id":"https:\/\/himpro.info\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4a9d9807cf1627da009f2911f9791061?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4a9d9807cf1627da009f2911f9791061?s=96&d=identicon&r=g","caption":"\u0e1b\u0e23\u0e30\u0e22\u0e39\u0e23 \u0e2b\u0e32\u0e0d\u0e40\u0e2a\u0e21\u0e2d"},"sameAs":["https:\/\/himpro.info"],"url":"https:\/\/himpro.info\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/posts\/2793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himpro.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2793"}],"version-history":[{"count":2,"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/posts\/2793\/revisions"}],"predecessor-version":[{"id":2796,"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/posts\/2793\/revisions\/2796"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himpro.info\/index.php?rest_route=\/wp\/v2\/media\/2794"}],"wp:attachment":[{"href":"https:\/\/himpro.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himpro.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himpro.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}