{"id":194,"date":"2024-12-16T00:46:10","date_gmt":"2024-12-15T16:46:10","guid":{"rendered":"https:\/\/codeloveme.com\/?p=194"},"modified":"2024-12-16T00:46:10","modified_gmt":"2024-12-15T16:46:10","slug":"mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97","status":"publish","type":"post","link":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/","title":{"rendered":"MySQL \u5165\u95e8\u6307\u5357"},"content":{"rendered":"<h1>\u7b80\u4ecb<\/h1>\n<p>MySQL \u662f\u5168\u7403\u6700\u6d41\u884c\u7684\u5f00\u6e90\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u88ab\u5e7f\u6cdb\u5e94\u7528\u4e8e Web \u5e94\u7528\u3001\u4f01\u4e1a\u7ea7\u8f6f\u4ef6\u548c\u5404\u7c7b\u4fe1\u606f\u7cfb\u7edf\u3002\u60f3\u8c61 MySQL \u5c31\u50cf\u662f\u4e00\u4e2a\u9ad8\u6548\u7684\u6570\u636e\u4ed3\u5e93\u7ba1\u7406\u5458\uff0c\u80fd\u7cbe\u51c6\u3001\u5feb\u901f\u5730\u5b58\u50a8\u3001\u68c0\u7d22\u548c\u7ba1\u7406\u6d77\u91cf\u6570\u636e\u3002<\/p>\n<h2>MySQL vs NoSQL\u6570\u636e\u5e93\uff1a<\/h2>\n<table>\n<thead>\n<tr>\n<th>\u7279\u6027<\/th>\n<th>MySQL\uff08\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff09<\/th>\n<th>NoSQL \u6570\u636e\u5e93<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>\u6570\u636e\u6a21\u578b<\/strong><\/td>\n<td>\u7ed3\u6784\u5316\u8868\u683c\uff0c\u6709\u4e25\u683c\u7684\u6a21\u5f0f\u5b9a\u4e49<\/td>\n<td>\u7075\u6d3b\u7684\u6570\u636e\u6a21\u578b\uff0c\u65e0\u56fa\u5b9a\u6a21\u5f0f<\/td>\n<\/tr>\n<tr>\n<td><strong>\u6570\u636e\u4e00\u81f4\u6027<\/strong><\/td>\n<td>\u5f3a\u4e00\u81f4\u6027\uff0c\u652f\u6301\u4e8b\u52a1ACID\u7279\u6027<\/td>\n<td>\u6700\u7ec8\u4e00\u81f4\u6027\uff0c\u90e8\u5206\u652f\u6301\u4e8b\u52a1<\/td>\n<\/tr>\n<tr>\n<td><strong>\u6269\u5c55\u6027<\/strong><\/td>\n<td>\u5782\u76f4\u6269\u5c55\u4e3a\u4e3b\uff0c\u6c34\u5e73\u6269\u5c55\u76f8\u5bf9\u590d\u6742<\/td>\n<td>\u6c34\u5e73\u6269\u5c55\u7b80\u5355\uff0c\u5206\u5e03\u5f0f\u67b6\u6784<\/td>\n<\/tr>\n<tr>\n<td><strong>\u67e5\u8be2\u80fd\u529b<\/strong><\/td>\n<td>\u5f3a\u5927\u7684 SQL \u67e5\u8be2\uff0c\u652f\u6301\u590d\u6742\u7684\u5173\u8054\u64cd\u4f5c<\/td>\n<td>\u67e5\u8be2\u80fd\u529b\u76f8\u5bf9\u6709\u9650<\/td>\n<\/tr>\n<tr>\n<td><strong>\u6027\u80fd<\/strong><\/td>\n<td>\u9002\u5408\u590d\u6742\u67e5\u8be2\u548c\u5173\u7cfb\u578b\u6570\u636e\u5904\u7406<\/td>\n<td>\u9002\u5408\u5927\u89c4\u6a21\u3001\u9ad8\u5e76\u53d1\u7684\u7b80\u5355\u8bfb\u5199\u64cd\u4f5c<\/td>\n<\/tr>\n<tr>\n<td><strong>\u4f7f\u7528\u573a\u666f<\/strong><\/td>\n<td>\u91d1\u878d\u7cfb\u7edf\u3001\u7535\u5546\u5e73\u53f0\u3001\u4f01\u4e1a\u7ba1\u7406\u7cfb\u7edf<\/td>\n<td>\u5b9e\u65f6\u5927\u6570\u636e\u3001\u7269\u8054\u7f51\u3001\u793e\u4ea4\u7f51\u7edc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u5b89\u88c5<\/h2>\n<h3>\u5b89\u88c5\u524d\u63d0<\/h3>\n<ul>\n<li>\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows\u3001macOS\u3001Linux<\/li>\n<li>\u7cfb\u7edf\u914d\u7f6e\uff1a\u63a8\u8350 64 \u4f4d\u64cd\u4f5c\u7cfb\u7edf<\/li>\n<li>\u786c\u4ef6\u8981\u6c42\uff1a\u81f3\u5c11 2GB \u5185\u5b58\uff0c\u63a8\u8350 4GB \u4ee5\u4e0a<\/li>\n<li>\u5b58\u50a8\u8981\u6c42\uff1a\u81f3\u5c11 10GB \u53ef\u7528\u78c1\u76d8\u7a7a\u95f4<\/li>\n<\/ul>\n<h3>\u5b89\u88c5\u6b65\u9aa4<\/h3>\n<ol>\n<li>\u8bbf\u95ee\u5b98\u65b9\u7f51\u7ad9 <a class=\"wp-editor-md-post-content-link\" href=\"https:\/\/www.mysql.com\/downloads\/\" target=\"_blank\"  rel=\"nofollow\" >MySQL\u5b98\u7f51<\/a><\/li>\n<li>\u9009\u62e9\u9002\u5408\u7684\u7248\u672c\uff08\u793e\u533a\u7248 Community Edition\uff09<\/li>\n<li>\u4e0b\u8f7d\u5e76\u5b89\u88c5\u7a0b\u5e8f<\/li>\n<li>\u5b8c\u6210\u521d\u59cb\u5316\u914d\u7f6e<\/li>\n<li>\u9a8c\u8bc1\u5b89\u88c5\uff1a\u5728\u7ec8\u7aef\u4e2d\u8fd0\u884c <code>mysql --version<\/code><\/li>\n<\/ol>\n<h1>\u5165\u95e8\u7bc7<\/h1>\n<h2>\u6570\u636e\u5e93\u7ba1\u7406<\/h2>\n<p>MySQL \u6570\u636e\u5e93\u662f\u7ed3\u6784\u5316\u6570\u636e\u7684\u5bb9\u5668\uff0c\u7531\u6570\u636e\u8868\u3001\u89c6\u56fe\u3001\u5b58\u50a8\u8fc7\u7a0b\u7b49\u7ec4\u6210\u3002\u5b83\u50cf\u662f\u4e00\u4e2a\u7cbe\u5fc3\u7ec4\u7ec7\u7684\u6587\u4ef6\u67dc\uff0c\u6bcf\u4e2a\u62bd\u5c49\uff08\u8868\uff09\u90fd\u4e95\u7136\u6709\u5e8f\u3002<\/p>\n<h3>\u6982\u5ff5\u7406\u89e3<\/h3>\n<p>\u6570\u636e\u5e93\u662f\u7ec4\u7ec7\u548c\u5b58\u50a8\u6570\u636e\u7684\u7cfb\u7edf\uff1a<\/p>\n<ul>\n<li>\u5305\u542b\u591a\u4e2a\u6570\u636e\u8868<\/li>\n<li>\u652f\u6301\u590d\u6742\u7684\u6570\u636e\u5173\u7cfb<\/li>\n<li>\u63d0\u4f9b\u6570\u636e\u5b8c\u6574\u6027\u548c\u5b89\u5168\u6027<\/li>\n<li>\u652f\u6301\u5e76\u53d1\u8bbf\u95ee<\/li>\n<li>\u53ef\u8fdb\u884c\u9ad8\u7ea7\u6570\u636e\u5904\u7406<\/li>\n<\/ul>\n<h3>\u5173\u952e\u7279\u70b9<\/h3>\n<ul>\n<li>\u652f\u6301\u591a\u79cd\u5b58\u50a8\u5f15\u64ce\uff08InnoDB\u3001MyISAM\uff09<\/li>\n<li>\u4e8b\u52a1\u652f\u6301<\/li>\n<li>\u590d\u5236\u548c\u96c6\u7fa4<\/li>\n<li>\u5b89\u5168\u7684\u7528\u6237\u6743\u9650\u7ba1\u7406<\/li>\n<li>\u8de8\u5e73\u53f0\u652f\u6301<\/li>\n<\/ul>\n<h3>\u57fa\u672c\u6570\u636e\u5e93\u64cd\u4f5c<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u547d\u4ee4<\/th>\n<th>\u4f5c\u7528<\/th>\n<th>\u793a\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>CREATE DATABASE<\/code><\/td>\n<td>\u521b\u5efa\u65b0\u6570\u636e\u5e93<\/td>\n<td><code>CREATE DATABASE mydb;<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>USE<\/code><\/td>\n<td>\u9009\u62e9\u6570\u636e\u5e93<\/td>\n<td><code>USE mydb;<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>DROP DATABASE<\/code><\/td>\n<td>\u5220\u9664\u6570\u636e\u5e93<\/td>\n<td><code>DROP DATABASE mydb;<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>SHOW DATABASES<\/code><\/td>\n<td>\u5217\u51fa\u6240\u6709\u6570\u636e\u5e93<\/td>\n<td>-<\/td>\n<\/tr>\n<tr>\n<td><code>CREATE TABLE<\/code><\/td>\n<td>\u521b\u5efa\u6570\u636e\u8868<\/td>\n<td><code>CREATE TABLE users (id INT, name VARCHAR(50));<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>ALTER TABLE<\/code><\/td>\n<td>\u4fee\u6539\u8868\u7ed3\u6784<\/td>\n<td><code>ALTER TABLE users ADD COLUMN age INT;<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>DROP TABLE<\/code><\/td>\n<td>\u5220\u9664\u6570\u636e\u8868<\/td>\n<td><code>DROP TABLE users;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u521b\u5efa\u6570\u636e\u8868\u793a\u4f8b<\/h3>\n<pre><code class=\"language-sql line-numbers\">CREATE TABLE employees (\n    id INT PRIMARY KEY,\n    name VARCHAR(100),\n    department VARCHAR(50),\n    salary DECIMAL(10,2),\n    hire_date DATE\n);\n<\/code><\/pre>\n<h2>\u6570\u636e\u64cd\u4f5c<\/h2>\n<p>MySQL \u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u6570\u636e\u64cd\u4f5c\u80fd\u529b\uff0c\u901a\u8fc7 SQL \u8bed\u8a00\u5b9e\u73b0\u6570\u636e\u7684\u589e\u5220\u6539\u67e5\u3002<\/p>\n<h3>\u57fa\u672c CRUD \u64cd\u4f5c<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>SQL \u547d\u4ee4<\/th>\n<th>\u793a\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u63d2\u5165\u6570\u636e<\/td>\n<td><code>INSERT INTO<\/code><\/td>\n<td><code>INSERT INTO employees VALUES (1, 'John', 'IT', 5000.00, '2023-01-01');<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u67e5\u8be2\u6570\u636e<\/td>\n<td><code>SELECT<\/code><\/td>\n<td><code>SELECT * FROM employees WHERE department = 'IT';<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u66f4\u65b0\u6570\u636e<\/td>\n<td><code>UPDATE<\/code><\/td>\n<td><code>UPDATE employees SET salary = 5500.00 WHERE id = 1;<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u5220\u9664\u6570\u636e<\/td>\n<td><code>DELETE<\/code><\/td>\n<td><code>DELETE FROM employees WHERE id = 1;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u6027\u80fd\u4e0e\u4f18\u5316<\/h2>\n<h3>\u7d22\u5f15<\/h3>\n<ul>\n<li>\u52a0\u901f\u6570\u636e\u67e5\u8be2<\/li>\n<li>\u7c7b\u4f3c\u4e66\u672c\u7684\u76ee\u5f55<\/li>\n<li>\u51cf\u5c11\u5168\u8868\u626b\u63cf\u65f6\u95f4<\/li>\n<li>\u9002\u5ea6\u521b\u5efa\uff0c\u907f\u514d\u8fc7\u591a\u7d22\u5f15<\/li>\n<\/ul>\n<h3>\u67e5\u8be2\u4f18\u5316<\/h3>\n<ul>\n<li>\u4f7f\u7528 <code>EXPLAIN<\/code> \u5206\u6790\u67e5\u8be2<\/li>\n<li>\u907f\u514d\u4f7f\u7528 <code>SELECT *<\/code><\/li>\n<li>\u5408\u7406\u8bbe\u8ba1\u8868\u7ed3\u6784<\/li>\n<li>\u4f7f\u7528\u9002\u5f53\u7684\u7d22\u5f15<\/li>\n<\/ul>\n<h2>\u5b89\u5168\u6027<\/h2>\n<ul>\n<li>\u7528\u6237\u6743\u9650\u7ba1\u7406<\/li>\n<li>\u6570\u636e\u52a0\u5bc6<\/li>\n<li>\u5b9a\u671f\u5907\u4efd<\/li>\n<li>\u9632\u6b62 SQL \u6ce8\u5165<\/li>\n<\/ul>\n<h1>\u8fdb\u9636\u7bc7<\/h1>\n<h2>\u4e8b\u52a1\u7ba1\u7406<\/h2>\n<p>\u4e8b\u52a1\u662f\u6570\u636e\u5e93\u4e2d\u7684\u6838\u5fc3\u6982\u5ff5\uff0c\u5b83\u4fdd\u8bc1\u4e86\u6570\u636e\u64cd\u4f5c\u7684\u4e00\u81f4\u6027\u548c\u53ef\u9760\u6027\u3002\u53ef\u4ee5\u5c06\u4e8b\u52a1\u7406\u89e3\u4e3a\u4e00\u4e2a\"\u539f\u5b50\u64cd\u4f5c\"\uff0c\u8981\u4e48\u5168\u90e8\u6210\u529f\uff0c\u8981\u4e48\u5168\u90e8\u5931\u8d25\u3002<\/p>\n<h3>\u4e8b\u52a1\u57fa\u672c\u64cd\u4f5c<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>SQL \u547d\u4ee4<\/th>\n<th>\u8bf4\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u5f00\u542f\u4e8b\u52a1<\/td>\n<td><code>START TRANSACTION<\/code> \u6216 <code>BEGIN<\/code><\/td>\n<td>\u6807\u5fd7\u4e8b\u52a1\u5f00\u59cb<\/td>\n<\/tr>\n<tr>\n<td>\u63d0\u4ea4\u4e8b\u52a1<\/td>\n<td><code>COMMIT<\/code><\/td>\n<td>\u786e\u8ba4\u5e76\u4fdd\u5b58\u6240\u6709\u66f4\u6539<\/td>\n<\/tr>\n<tr>\n<td>\u56de\u6eda\u4e8b\u52a1<\/td>\n<td><code>ROLLBACK<\/code><\/td>\n<td>\u64a4\u9500\u6240\u6709\u672a\u63d0\u4ea4\u7684\u66f4\u6539<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u4e8b\u52a1\u56db\u5927\u7279\u6027\uff08ACID\uff09<\/h3>\n<p>\u4e8b\u52a1\u7684\u56db\u5927\u7279\u6027\u662f\u4fdd\u8bc1\u6570\u636e\u5b8c\u6574\u6027\u548c\u4e00\u81f4\u6027\u7684\u5173\u952e\uff1a<\/p>\n<ol>\n<li><strong>\u539f\u5b50\u6027\uff08Atomicity\uff09<\/strong>\n<ul>\n<li>\u4e8b\u52a1\u662f\u4e0d\u53ef\u5206\u5272\u7684\u6700\u5c0f\u64cd\u4f5c\u5355\u5143<\/li>\n<li>\u8981\u4e48\u5168\u90e8\u6210\u529f\uff0c\u8981\u4e48\u5168\u90e8\u5931\u8d25<\/li>\n<li>\u7c7b\u4f3c\u4e8e\"\u4e00\u9524\u5b50\u4e70\u5356\"\uff0c\u4e0d\u80fd\u53ea\u5b8c\u6210\u4e00\u534a<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u4e00\u81f4\u6027\uff08Consistency\uff09<\/strong>\n<ul>\n<li>\u4e8b\u52a1\u5b8c\u6210\u540e\uff0c\u6570\u636e\u5fc5\u987b\u4fdd\u6301\u4e00\u81f4\u72b6\u6001<\/li>\n<li>\u786e\u4fdd\u6570\u636e\u7684\u5408\u6cd5\u6027\u548c\u5b8c\u6574\u6027<\/li>\n<li>\u9632\u6b62\u6570\u636e\u5e93\u9677\u5165\u4e0d\u6b63\u786e\u7684\u72b6\u6001<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u9694\u79bb\u6027\uff08Isolation\uff09<\/strong>\n<ul>\n<li>\u5e76\u53d1\u6267\u884c\u7684\u4e8b\u52a1\u4e4b\u95f4\u76f8\u4e92\u72ec\u7acb<\/li>\n<li>\u9632\u6b62\u4e8b\u52a1\u4e4b\u95f4\u76f8\u4e92\u5e72\u6270<\/li>\n<li>\u786e\u4fdd\u6bcf\u4e2a\u4e8b\u52a1\u90fd\u611f\u89c9\u81ea\u5df1\u662f\u552f\u4e00\u7684\u6267\u884c\u8005<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u6301\u4e45\u6027\uff08Durability\uff09<\/strong>\n<ul>\n<li>\u4e8b\u52a1\u4e00\u65e6\u63d0\u4ea4\uff0c\u5176\u6539\u53d8\u662f\u6c38\u4e45\u7684<\/li>\n<li>\u5373\u4f7f\u7cfb\u7edf\u53d1\u751f\u6545\u969c\uff0c\u6570\u636e\u4e5f\u4e0d\u4f1a\u4e22\u5931<\/li>\n<li>\u901a\u5e38\u4f9d\u8d56\u4e8e\u6570\u636e\u5e93\u7684\u65e5\u5fd7\u7cfb\u7edf<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>\u5e76\u53d1\u4e8b\u52a1\u95ee\u9898<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u95ee\u9898<\/th>\n<th>\u63cf\u8ff0<\/th>\n<th>\u5371\u5bb3<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u810f\u8bfb<\/td>\n<td>\u8bfb\u53d6\u672a\u63d0\u4ea4\u7684\u6570\u636e<\/td>\n<td>\u53ef\u80fd\u5bfc\u81f4\u6570\u636e\u4e0d\u4e00\u81f4<\/td>\n<\/tr>\n<tr>\n<td>\u4e0d\u53ef\u91cd\u590d\u8bfb<\/td>\n<td>\u540c\u4e00\u4e8b\u52a1\u591a\u6b21\u8bfb\u53d6\u540c\u4e00\u6570\u636e\u7ed3\u679c\u4e0d\u540c<\/td>\n<td>\u7834\u574f\u4e8b\u52a1\u7684\u53ef\u9760\u6027<\/td>\n<\/tr>\n<tr>\n<td>\u5e7b\u8bfb<\/td>\n<td>\u67e5\u8be2\u65f6\u53d1\u73b0\u6570\u636e\u884cmysteriously\u6539\u53d8<\/td>\n<td>\u5f71\u54cd\u6570\u636e\u7684\u51c6\u786e\u6027<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u9694\u79bb\u7ea7\u522b<\/th>\n<th>\u63cf\u8ff0<\/th>\n<th>\u53ef\u89e3\u51b3\u95ee\u9898<\/th>\n<th>\u6027\u80fd<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Read Uncommitted<\/td>\n<td>\u6700\u4f4e\u7ea7\u522b\uff0c\u5141\u8bb8\u8bfb\u53d6\u672a\u63d0\u4ea4\u6570\u636e<\/td>\n<td>\u65e0\u6cd5\u89e3\u51b3\u4efb\u4f55\u5e76\u53d1\u95ee\u9898<\/td>\n<td>\u6700\u9ad8<\/td>\n<\/tr>\n<tr>\n<td>Read Committed<\/td>\n<td>\u53ea\u80fd\u8bfb\u53d6\u5df2\u63d0\u4ea4\u6570\u636e<\/td>\n<td>\u89e3\u51b3\u810f\u8bfb<\/td>\n<td>\u8f83\u9ad8<\/td>\n<\/tr>\n<tr>\n<td>Repeatable Read<\/td>\n<td>MySQL \u9ed8\u8ba4\u7ea7\u522b<\/td>\n<td>\u89e3\u51b3\u810f\u8bfb\u548c\u4e0d\u53ef\u91cd\u590d\u8bfb<\/td>\n<td>\u4e2d\u7b49<\/td>\n<\/tr>\n<tr>\n<td>Serializable<\/td>\n<td>\u6700\u9ad8\u9694\u79bb\u7ea7\u522b<\/td>\n<td>\u89e3\u51b3\u6240\u6709\u5e76\u53d1\u95ee\u9898<\/td>\n<td>\u6700\u4f4e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u9694\u79bb\u7ea7\u522b\u64cd\u4f5c<\/h3>\n<pre><code class=\"language-sql line-numbers\">-- \u67e5\u770b\u5f53\u524d\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\nSELECT @@transaction_isolation;\n\n-- \u8bbe\u7f6e\u4f1a\u8bdd\u7ea7\u522b\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\nSET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;\nSET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;\n<\/code><\/pre>\n<h2>\u5b58\u50a8\u5f15\u64ce<\/h2>\n<p>\u5b58\u50a8\u5f15\u64ce\u662f MySQL \u7684\u6838\u5fc3\u7ec4\u4ef6\uff0c\u51b3\u5b9a\u4e86\u6570\u636e\u7684\u5b58\u50a8\u65b9\u5f0f\u548c\u6027\u80fd\u7279\u5f81\u3002<\/p>\n<h3>InnoDB \u5f15\u64ce<\/h3>\n<p><strong>\u7279\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\uff08MySQL 5.5 \u4e4b\u540e\uff09<\/li>\n<li>\u652f\u6301\u4e8b\u52a1 ACID \u6a21\u578b<\/li>\n<li>\u884c\u7ea7\u9501\uff0c\u63d0\u9ad8\u5e76\u53d1\u6027\u80fd<\/li>\n<li>\u652f\u6301\u5916\u952e\u7ea6\u675f<\/li>\n<\/ul>\n<p><strong>\u6587\u4ef6<\/strong>\uff1a<\/p>\n<ul>\n<li><code>xxx.ibd<\/code>\uff1a\u8868\u7a7a\u95f4\u6587\u4ef6\uff0c\u5b58\u50a8\u8868\u7ed3\u6784\u3001\u6570\u636e\u548c\u7d22\u5f15<\/li>\n<\/ul>\n<h3>MyISAM \u5f15\u64ce<\/h3>\n<p><strong>\u7279\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>MySQL \u65e9\u671f\u9ed8\u8ba4\u5f15\u64ce<\/li>\n<li>\u4e0d\u652f\u6301\u4e8b\u52a1\u548c\u5916\u952e<\/li>\n<li>\u8868\u7ea7\u9501<\/li>\n<li>\u8bbf\u95ee\u901f\u5ea6\u5feb<\/li>\n<\/ul>\n<p><strong>\u6587\u4ef6<\/strong>\uff1a<\/p>\n<ul>\n<li><code>xxx.sdi<\/code>\uff1a\u8868\u7ed3\u6784\u4fe1\u606f<\/li>\n<li><code>xxx.MYD<\/code>\uff1a\u6570\u636e\u6587\u4ef6<\/li>\n<li><code>xxx.MYI<\/code>\uff1a\u7d22\u5f15\u6587\u4ef6<\/li>\n<\/ul>\n<h3>Memory \u5b58\u50a8\u5f15\u64ce<\/h3>\n<p><strong>\u7279\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>\u6570\u636e\u5b58\u50a8\u5728\u5185\u5b58\u4e2d<\/li>\n<li>\u8bbf\u95ee\u901f\u5ea6\u6781\u5feb<\/li>\n<li>\u9002\u5408\u4e34\u65f6\u8868\u548c\u7f13\u5b58<\/li>\n<li>\u53d7\u786c\u4ef6\u548c\u65ad\u7535\u5f71\u54cd<\/li>\n<\/ul>\n<h2>\u7d22\u5f15<\/h2>\n<p>\u7d22\u5f15\u662f\u63d0\u9ad8\u6570\u636e\u5e93\u67e5\u8be2\u6027\u80fd\u7684\u5173\u952e\u5de5\u5177\u3002<\/p>\n<h3>\u7d22\u5f15\u4f18\u7f3a\u70b9<\/h3>\n<p><strong>\u4f18\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>\u63d0\u9ad8\u6570\u636e\u68c0\u7d22\u6548\u7387<\/li>\n<li>\u51cf\u5c11\u6570\u636e\u5e93 I\/O \u6210\u672c<\/li>\n<li>\u964d\u4f4e\u6392\u5e8f\u6210\u672c<\/li>\n<\/ul>\n<p><strong>\u7f3a\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5360\u7528\u989d\u5916\u5b58\u50a8\u7a7a\u95f4<\/li>\n<li>\u964d\u4f4e\u8868\u66f4\u65b0\u901f\u5ea6<\/li>\n<\/ul>\n<h3>\u7d22\u5f15\u7ed3\u6784<\/h3>\n<h4>B+Tree \u7d22\u5f15<\/h4>\n<ul>\n<li>\u6240\u6709\u6570\u636e\u96c6\u4e2d\u5728\u53f6\u5b50\u8282\u70b9<\/li>\n<li>\u53f6\u5b50\u8282\u70b9\u5f62\u6210\u6709\u5e8f\u94fe\u8868<\/li>\n<li>MySQL \u5bf9\u7ecf\u5178 B+Tree \u8fdb\u884c\u4e86\u4f18\u5316<\/li>\n<\/ul>\n<h4>Hash \u7d22\u5f15<\/h4>\n<ul>\n<li>\u7b49\u503c\u6bd4\u8f83\u6548\u7387\u9ad8<\/li>\n<li>\u4e0d\u652f\u6301\u8303\u56f4\u5339\u914d<\/li>\n<li>\u4e0d\u9002\u5408\u6392\u5e8f\u64cd\u4f5c<\/li>\n<\/ul>\n<h3>\u7d22\u5f15\u5206\u7c7b<\/h3>\n<h4>\u805a\u96c6\u7d22\u5f15<\/h4>\n<ul>\n<li>\u53f6\u5b50\u8282\u70b9\u76f4\u63a5\u4fdd\u5b58\u884c\u6570\u636e<\/li>\n<li>\u6bcf\u4e2a\u8868\u53ea\u80fd\u6709\u4e00\u4e2a<\/li>\n<li>\u4f18\u5148\u4f7f\u7528\u4e3b\u952e<\/li>\n<\/ul>\n<h4>\u4e8c\u7ea7\u7d22\u5f15<\/h4>\n<ul>\n<li>\u53f6\u5b50\u8282\u70b9\u5b58\u50a8\u4e3b\u952e<\/li>\n<li>\u9700\u8981\u56de\u8868\u67e5\u8be2<\/li>\n<\/ul>\n<h3>\u4e3a\u4ec0\u4e48\u9009\u62e9 B+Tree<\/h3>\n<p><strong>\u4f18\u52bf<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5c42\u7ea7\u5c11\uff0c\u641c\u7d22\u6548\u7387\u9ad8<\/li>\n<li>\u8282\u70b9\u5229\u7528\u7387\u9ad8<\/li>\n<li>\u652f\u6301\u8303\u56f4\u67e5\u8be2<\/li>\n<li>\u6839\u8282\u70b9\u5e38\u9a7b\u5185\u5b58<\/li>\n<\/ul>\n<h1>\u9ad8\u7ea7\u7bc7<\/h1>\n<h2>SQL \u6027\u80fd\u5206\u6790<\/h2>\n<p>\u6027\u80fd\u5206\u6790\u662f\u4f18\u5316 MySQL \u6570\u636e\u5e93\u7684\u5173\u952e\u6b65\u9aa4\u3002\u901a\u8fc7\u6df1\u5165\u4e86\u89e3 SQL \u6267\u884c\u7684\u5404\u4e2a\u7ef4\u5ea6\uff0c\u6211\u4eec\u53ef\u4ee5\u6709\u9488\u5bf9\u6027\u5730\u63d0\u5347\u6570\u636e\u5e93\u6027\u80fd\u3002<\/p>\n<h3>\u6267\u884c\u9891\u7387\u5206\u6790<\/h3>\n<p>\u6267\u884c\u9891\u7387\u5206\u6790\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u4e86\u89e3\u6570\u636e\u5e93\u4e2d\u6700\u5e38\u88ab\u6267\u884c\u7684 SQL \u64cd\u4f5c\u7c7b\u578b\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th>\u547d\u4ee4<\/th>\n<th>\u4f5c\u7528<\/th>\n<th>\u8bf4\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>SHOW GLOBAL STATUS LIKE 'com_______'<\/code><\/td>\n<td>\u67e5\u770b SQL \u6267\u884c\u9891\u7387<\/td>\n<td>\u4f7f\u7528 7 \u4e2a\u4e0b\u5212\u7ebf\u901a\u914d\u7b26\uff0c\u53ef\u5339\u914d\u6240\u6709 COM \u5f00\u5934\u7684\u72b6\u6001<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u89e3\u91ca<\/strong>\uff1a<\/p>\n<ul>\n<li>\u901a\u8fc7 <code>com_<\/code> \u524d\u7f00\u53ef\u4ee5\u67e5\u770b\u5404\u7c7b SQL \u64cd\u4f5c\u7684\u6267\u884c\u6b21\u6570<\/li>\n<li>\u4f8b\u5982 <code>com_select<\/code>\u3001<code>com_insert<\/code>\u3001<code>com_update<\/code> \u7b49<\/li>\n<li>\u6709\u52a9\u4e8e\u8bc6\u522b\u7cfb\u7edf\u8d1f\u8f7d\u548c\u6027\u80fd\u74f6\u9888<\/li>\n<\/ul>\n<h3>\u6162\u67e5\u8be2\u65e5\u5fd7<\/h3>\n<p>\u6162\u67e5\u8be2\u65e5\u5fd7\u662f\u8bca\u65ad\u6027\u80fd\u95ee\u9898\u7684\u5229\u5668\uff0c\u53ef\u4ee5\u5e2e\u52a9\u8bc6\u522b\u6267\u884c\u65f6\u95f4\u8fc7\u957f\u7684 SQL \u8bed\u53e5\u3002<\/p>\n<p><strong>\u914d\u7f6e\u65b9\u6cd5<\/strong>\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u67e5\u770b\u6162\u67e5\u8be2\u65e5\u5fd7\u72b6\u6001\nSHOW VARIABLES LIKE 'slow_query_log';\n\n-- \u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7\nSET GLOBAL slow_query_log='ON';\n\n-- \u8bbe\u7f6e\u6162\u67e5\u8be2\u65f6\u95f4\u9608\u503c\uff08\u5355\u4f4d\uff1a\u79d2\uff09\nSHOW VARIABLES LIKE 'long_query_time';\nSET GLOBAL long_query_time=1;\n<\/code><\/pre>\n<p><strong>\u914d\u7f6e\u6587\u4ef6\u6301\u4e45\u5316<\/strong>\uff08<code>\/etc\/my.cnf<\/code>\uff09\uff1a<\/p>\n<pre><code class=\"language-conf line-numbers\">slow_query_log=ON\nlong_query_time=1\nslow_query_log_file=\/var\/log\/mysql\/slow_query.log\n<\/code><\/pre>\n<p><strong>\u6700\u4f73\u5b9e\u8df5<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5efa\u8bae\u5c06\u9608\u503c\u8bbe\u7f6e\u4e3a 1-2 \u79d2<\/li>\n<li>\u5b9a\u671f\u5206\u6790\u6162\u67e5\u8be2\u65e5\u5fd7<\/li>\n<li>\u914d\u7f6e\u65e5\u5fd7\u6587\u4ef6\u8def\u5f84\uff0c\u65b9\u4fbf\u6301\u4e45\u5316\u548c\u5206\u6790<\/li>\n<\/ul>\n<h3>SQL \u8017\u65f6\u5206\u6790<\/h3>\n<h4>Profiling \u529f\u80fd<\/h4>\n<p>Profiling \u662f MySQL \u63d0\u4f9b\u7684\u6027\u80fd\u8bca\u65ad\u5de5\u5177\uff0c\u53ef\u4ee5\u8be6\u7ec6\u5c55\u793a SQL \u6267\u884c\u7684\u5404\u4e2a\u9636\u6bb5\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th>\u547d\u4ee4<\/th>\n<th>\u4f5c\u7528<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>SELECT @@have_profiling<\/code><\/td>\n<td>\u68c0\u67e5\u662f\u5426\u652f\u6301 Profiling<\/td>\n<\/tr>\n<tr>\n<td><code>SET profiling = 1<\/code><\/td>\n<td>\u5f00\u542f Profiling<\/td>\n<\/tr>\n<tr>\n<td><code>SHOW PROFILES<\/code><\/td>\n<td>\u67e5\u770b\u57fa\u672c\u8017\u65f6\u60c5\u51b5<\/td>\n<\/tr>\n<tr>\n<td><code>SHOW PROFILE FOR QUERY [query_id]<\/code><\/td>\n<td>\u67e5\u770b\u5177\u4f53\u67e5\u8be2\u5404\u9636\u6bb5\u8017\u65f6<\/td>\n<\/tr>\n<tr>\n<td><code>SHOW PROFILE CPU FOR QUERY [query_id]<\/code><\/td>\n<td>\u67e5\u770b CPU \u4f7f\u7528\u60c5\u51b5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u6ce8\u610f\u4e8b\u9879<\/strong>\uff1a<\/p>\n<ul>\n<li>\u4ec5\u7528\u4e8e\u5f00\u53d1\u548c\u8c03\u8bd5\u9636\u6bb5<\/li>\n<li>\u751f\u4ea7\u73af\u5883\u8c28\u614e\u4f7f\u7528\uff0c\u4f1a\u5f71\u54cd\u6027\u80fd<\/li>\n<li>\u53ef\u4ee5\u5e2e\u52a9\u5b9a\u4f4d SQL \u6267\u884c\u7684\u6027\u80fd\u74f6\u9888<\/li>\n<\/ul>\n<h3>\u6267\u884c\u8ba1\u5212\uff08EXPLAIN\uff09<\/h3>\n<p>\u6267\u884c\u8ba1\u5212\u662f\u5206\u6790 SQL \u6027\u80fd\u7684\u5173\u952e\u5de5\u5177\uff0c\u5c55\u793a MySQL \u4f18\u5316\u5668\u5982\u4f55\u6267\u884c\u67e5\u8be2\u3002<\/p>\n<p><strong>\u5e38\u7528\u5b57\u6bb5<\/strong>\uff1a<\/p>\n<table>\n<thead>\n<tr>\n<th>\u5b57\u6bb5<\/th>\n<th>\u8bf4\u660e<\/th>\n<th>\u91cd\u8981\u6027<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>id<\/td>\n<td>\u6267\u884c\u987a\u5e8f<\/td>\n<td>\u503c\u8d8a\u5927\u4f18\u5148\u6267\u884c<\/td>\n<\/tr>\n<tr>\n<td>select_type<\/td>\n<td>\u67e5\u8be2\u7c7b\u578b<\/td>\n<td>\u4e86\u89e3\u67e5\u8be2\u590d\u6742\u5ea6<\/td>\n<\/tr>\n<tr>\n<td>type<\/td>\n<td>\u8fde\u63a5\u7c7b\u578b<\/td>\n<td>\u6027\u80fd\u5173\u952e\u6307\u6807<\/td>\n<\/tr>\n<tr>\n<td>key<\/td>\n<td>\u5b9e\u9645\u4f7f\u7528\u7d22\u5f15<\/td>\n<td>\u9a8c\u8bc1\u7d22\u5f15\u6548\u679c<\/td>\n<\/tr>\n<tr>\n<td>Extra<\/td>\n<td>\u9644\u52a0\u4fe1\u606f<\/td>\n<td>\u6027\u80fd\u4f18\u5316\u53c2\u8003<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u793a\u4f8b<\/strong>\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">EXPLAIN SELECT COUNT(*) FROM user;\n<\/code><\/pre>\n<p><strong>\u89e3\u8bfb\u6280\u5de7<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5173\u6ce8 <code>type<\/code> \u5b57\u6bb5\uff0c\u6027\u80fd\u4ece\u597d\u5230\u5dee\uff1asystem > const > eq_ref > ref > range > index > all<\/li>\n<li><code>Extra<\/code> \u4e2d\u7684 \"Using index\" \u901a\u5e38\u610f\u5473\u7740\u9ad8\u6548\u67e5\u8be2<\/li>\n<\/ul>\n<h2>\u7d22\u5f15\u4f18\u5316<\/h2>\n<p>\u7d22\u5f15\u662f\u63d0\u5347 MySQL \u67e5\u8be2\u6027\u80fd\u7684\u6838\u5fc3\u673a\u5236\uff0c\u6b63\u786e\u4f7f\u7528\u7d22\u5f15\u53ef\u4ee5\u663e\u8457\u51cf\u5c11\u67e5\u8be2\u65f6\u95f4\u3002<\/p>\n<h3>\u7d22\u5f15\u6548\u7387\u9a8c\u8bc1<\/h3>\n<p>\u7d22\u5f15\u6548\u7387\u9a8c\u8bc1\u662f\u4e00\u4e2a\u7cfb\u7edf\u6027\u7684\u8fc7\u7a0b\uff0c\u5305\u62ec\u4ee5\u4e0b\u6b65\u9aa4\uff1a<\/p>\n<ol>\n<li>\u521b\u5efa\u7d22\u5f15\u524d\u6267\u884c\u67e5\u8be2\uff0c\u8bb0\u5f55\u539f\u59cb\u6027\u80fd<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u672a\u521b\u5efa\u7d22\u5f15\u524d\u7684\u67e5\u8be2\nSELECT * FROM user WHERE name = 'xxx';\n<\/code><\/pre>\n<ol start=\"2\">\n<li>\u521b\u5efa\u7d22\u5f15<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u4e3a name \u5217\u521b\u5efa\u7d22\u5f15\nCREATE INDEX idx_user ON user(name);\n<\/code><\/pre>\n<ol start=\"3\">\n<li>\u67e5\u770b\u7d22\u5f15<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u9a8c\u8bc1\u7d22\u5f15\u662f\u5426\u6210\u529f\u521b\u5efa\nSHOW INDEX FROM user;\n<\/code><\/pre>\n<ol start=\"4\">\n<li>\u9a8c\u8bc1\u7d22\u5f15\u751f\u6548<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u4f7f\u7528 EXPLAIN \u68c0\u67e5\u7d22\u5f15\u4f7f\u7528\u60c5\u51b5\nEXPLAIN SELECT * FROM user WHERE name = 'xxx';\n<\/code><\/pre>\n<p><strong>\u6027\u80fd\u5bf9\u6bd4\u6ce8\u610f\u4e8b\u9879<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5bf9\u6bd4\u521b\u5efa\u7d22\u5f15\u524d\u540e\u7684\u67e5\u8be2\u8017\u65f6<\/li>\n<li>\u5173\u6ce8\u6267\u884c\u8ba1\u5212\u4e2d\u7684 <code>type<\/code> \u548c <code>key<\/code> \u5b57\u6bb5<\/li>\n<li>\u5927\u6570\u636e\u91cf\u4e0b\u6d4b\u8bd5\u66f4\u5177\u4ee3\u8868\u6027<\/li>\n<\/ul>\n<h3>\u7d22\u5f15\u4f7f\u7528\u6280\u5de7<\/h3>\n<h4>\u6700\u5de6\u524d\u7f00\u6cd5\u5219<\/h4>\n<p>\u8054\u5408\u7d22\u5f15\u67e5\u8be2\u5fc5\u987b\u5305\u542b\u6700\u5de6\u5217\uff0c\u8fd9\u662f\u7d22\u5f15\u6709\u6548\u6027\u7684\u5173\u952e\u539f\u5219\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u521b\u5efa\u8054\u5408\u7d22\u5f15\nCREATE INDEX idx_user_name_phone ON user(name, phone);\n\n-- \u6b63\u786e\u4f7f\u7528\u7d22\u5f15\u7684\u67e5\u8be2\nSELECT * FROM user WHERE name = 'xxx' AND phone = '123';\n\n-- \u53ef\u80fd\u65e0\u6cd5\u5145\u5206\u5229\u7528\u7d22\u5f15\u7684\u67e5\u8be2\nSELECT * FROM user WHERE phone = '123';\n<\/code><\/pre>\n<h4>\u7d22\u5f15\u5931\u6548\u573a\u666f<\/h4>\n<p>\u4e86\u89e3\u7d22\u5f15\u5931\u6548\u7684\u573a\u666f\u53ef\u4ee5\u5e2e\u52a9\u4f18\u5316\u67e5\u8be2\uff1a<\/p>\n<ol>\n<li>LIKE \u4ee5 % \u5f00\u5934<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u7d22\u5f15\u5931\u6548\nSELECT * FROM user WHERE name LIKE '%\u5f20%';\n<\/code><\/pre>\n<ol start=\"2\">\n<li>OR \u8bed\u53e5\u672a\u540c\u65f6\u4f7f\u7528\u7d22\u5f15<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u53ef\u80fd\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\nSELECT * FROM user WHERE name = 'xxx' OR phone = '123';\n<\/code><\/pre>\n<ol start=\"3\">\n<li>\u5b57\u7b26\u4e32\u672a\u52a0\u5f15\u53f7<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u7d22\u5f15\u53ef\u80fd\u5931\u6548\nSELECT * FROM user WHERE name = 123;\n<\/code><\/pre>\n<ol start=\"4\">\n<li>\u5bf9\u7d22\u5f15\u5217\u4f7f\u7528\u51fd\u6570<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- \u7d22\u5f15\u5931\u6548\nSELECT * FROM user WHERE YEAR(create_time) = 2023;\n<\/code><\/pre>\n<ol start=\"5\">\n<li>\u8303\u56f4\u67e5\u8be2\u540e\u7d22\u5f15\u5931\u6548<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">-- age \u540e\u7684\u7d22\u5f15\u5217\u53ef\u80fd\u5931\u6548\nCREATE INDEX idx_age_name ON user(age, name);\nSELECT * FROM user WHERE age &gt; 20 AND name = 'xxx';\n<\/code><\/pre>\n<h4>\u8986\u76d6\u7d22\u5f15<\/h4>\n<p>\u8986\u76d6\u7d22\u5f15\u662f\u6307\u67e5\u8be2\u7ed3\u679c\u5b8c\u5168\u5728\u7d22\u5f15\u4e2d\u80fd\u591f\u627e\u5230\uff0c\u907f\u514d\u56de\u8868\u67e5\u8be2\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u521b\u5efa\u8986\u76d6\u7d22\u5f15\nCREATE INDEX idx_user ON user(id, name);\n\n-- \u9ad8\u6548\u67e5\u8be2\nSELECT id, name FROM user;\n<\/code><\/pre>\n<p><strong>\u4f18\u52bf<\/strong>\uff1a<\/p>\n<ul>\n<li>\u51cf\u5c11\u78c1\u76d8 I\/O<\/li>\n<li>\u63d0\u9ad8\u67e5\u8be2\u901f\u5ea6<\/li>\n<\/ul>\n<h4>\u524d\u7f00\u7d22\u5f15<\/h4>\n<p>\u9488\u5bf9\u957f\u5b57\u7b26\u4e32\u5b57\u6bb5\uff0c\u53ef\u4ee5\u4f7f\u7528\u524d\u7f00\u7d22\u5f15\u8282\u7701\u5b58\u50a8\u7a7a\u95f4\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u4e3a email \u7684\u524d 10 \u4e2a\u5b57\u7b26\u521b\u5efa\u7d22\u5f15\nCREATE INDEX idx_email ON user(email(10));\n<\/code><\/pre>\n<p><strong>\u9009\u62e9\u524d\u7f00\u957f\u5ea6<\/strong>\uff1a<\/p>\n<ul>\n<li>\u8db3\u591f\u533a\u5206\u5ea6<\/li>\n<li>\u4fdd\u6301\u8f83\u5c0f\u7684\u7d22\u5f15\u4f53\u79ef<\/li>\n<\/ul>\n<h2>SQL \u4f18\u5316\u6280\u5de7<\/h2>\n<h3>\u6570\u636e\u63d2\u5165\u4f18\u5316<\/h3>\n<ol>\n<li>\u6279\u91cf\u63d2\u5165\uff08\u4e0d\u8d85\u8fc7 1000 \u6761\uff09<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">INSERT INTO user (name, age) VALUES \n('\u5f20\u4e09', 20),\n('\u674e\u56db', 22),\n('\u738b\u4e94', 25);\n<\/code><\/pre>\n<ol start=\"2\">\n<li>\u4e3b\u952e\u987a\u5e8f\u63d2\u5165<\/li>\n<\/ol>\n<ul>\n<li>\u51cf\u5c11\u9875\u5206\u88c2<\/li>\n<li>\u63d0\u9ad8\u63d2\u5165\u6027\u80fd<\/li>\n<\/ul>\n<ol start=\"3\">\n<li>\u5927\u6279\u91cf\u6570\u636e\u5206\u6279\u5904\u7406<\/li>\n<\/ol>\n<pre><code class=\"language-python line-numbers\"># \u4f2a\u4ee3\u7801\u793a\u4f8b\nbatch_size = 1000\nfor i in range(0, total_data, batch_size):\n    batch_data = get_data_batch(i, batch_size)\n    insert_batch(batch_data)\n<\/code><\/pre>\n<h3>\u5e38\u89c1\u64cd\u4f5c\u4f18\u5316<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>\u4f18\u5316\u7b56\u7565<\/th>\n<th>\u793a\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>ORDER BY<\/td>\n<td>\u4f7f\u7528\u7d22\u5f15\u652f\u6301\u6392\u5e8f<\/td>\n<td><code>CREATE INDEX idx_age ON user(age)<\/code><\/td>\n<\/tr>\n<tr>\n<td>GROUP BY<\/td>\n<td>\u907f\u514d\u5168\u8868\u626b\u63cf<\/td>\n<td><code>CREATE INDEX idx_dept ON user(department)<\/code><\/td>\n<\/tr>\n<tr>\n<td>LIMIT<\/td>\n<td>\u4f7f\u7528\u8986\u76d6\u7d22\u5f15<\/td>\n<td><code>SELECT id, name FROM user LIMIT 10<\/code><\/td>\n<\/tr>\n<tr>\n<td>COUNT<\/td>\n<td>\u4f7f\u7528\u7d22\u5f15\u7edf\u8ba1<\/td>\n<td><code>SELECT COUNT(id) FROM user<\/code><\/td>\n<\/tr>\n<tr>\n<td>UPDATE<\/td>\n<td>WHERE \u6761\u4ef6\u4f7f\u7528\u7d22\u5f15<\/td>\n<td><code>UPDATE user SET status=1 WHERE id=100<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u9ad8\u7ea7\u6570\u636e\u5e93\u5bf9\u8c61<\/h2>\n<h3>\u89c6\u56fe<\/h3>\n<p>\u89c6\u56fe\u662f\u865a\u62df\u8868\uff0c\u53ef\u4ee5\u7b80\u5316\u590d\u6742\u67e5\u8be2\uff0c\u63d0\u4f9b\u6570\u636e\u8bbf\u95ee\u7684\u62bd\u8c61\u5c42\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u521b\u5efa\u89c6\u56fe\nCREATE VIEW view_name AS \nSELECT column1, column2 \nFROM table_name \nWHERE condition;\n\n-- \u4fee\u6539\u89c6\u56fe\nCREATE OR REPLACE VIEW view_name AS \nSELECT column1, column2 \nFROM table_name \nWHERE new_condition;\n\n-- \u5220\u9664\u89c6\u56fe\nDROP VIEW IF EXISTS view_name;\n<\/code><\/pre>\n<p><strong>\u89c6\u56fe\u7684\u4f18\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>\u7b80\u5316\u590d\u6742\u67e5\u8be2<\/li>\n<li>\u63d0\u4f9b\u6570\u636e\u8bbf\u95ee\u7684\u5b89\u5168\u6027<\/li>\n<li>\u5c4f\u853d\u5e95\u5c42\u8868\u7ed3\u6784\u53d8\u5316<\/li>\n<\/ul>\n<h3>\u5b58\u50a8\u8fc7\u7a0b<\/h3>\n<p>\u5b58\u50a8\u8fc7\u7a0b\u662f\u9884\u7f16\u8bd1\u7684 SQL \u8bed\u53e5\u96c6\u5408\uff0c\u53ef\u4ee5\u63d0\u9ad8\u6027\u80fd\u5e76\u589e\u5f3a\u4ee3\u7801\u590d\u7528\u6027\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\nDELIMITER \/\/\nCREATE PROCEDURE proc_name(IN param INT)\nBEGIN\n    -- \u58f0\u660e\u53d8\u91cf\n    DECLARE var_name INT DEFAULT 0;\n\n    -- \u8fc7\u7a0b\u903b\u8f91\n    IF param &gt; 0 THEN\n        SELECT * FROM table_name WHERE id = param;\n    ELSE\n        INSERT INTO log_table VALUES('Invalid parameter');\n    END IF;\nEND \/\/\nDELIMITER ;\n\n-- \u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b\nCALL proc_name(10);\n<\/code><\/pre>\n<p><strong>\u5b58\u50a8\u8fc7\u7a0b\u7279\u70b9<\/strong>\uff1a<\/p>\n<ul>\n<li>\u51cf\u5c11\u7f51\u7edc\u4f20\u8f93<\/li>\n<li>\u53ef\u4ee5\u5305\u542b\u590d\u6742\u7684\u4e1a\u52a1\u903b\u8f91<\/li>\n<li>\u652f\u6301\u53c2\u6570\u548c\u8fd4\u56de\u503c<\/li>\n<\/ul>\n<h3>\u5b58\u50a8\u51fd\u6570<\/h3>\n<p>\u5b58\u50a8\u51fd\u6570\u7c7b\u4f3c\u5b58\u50a8\u8fc7\u7a0b\uff0c\u4f46\u5fc5\u987b\u8fd4\u56de\u4e00\u4e2a\u503c\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">DELIMITER \/\/\nCREATE FUNCTION func_name(param1 INT) \nRETURNS INT\nBEGIN\n    DECLARE result INT;\n\n    -- \u51fd\u6570\u903b\u8f91\n    SET result = param1 * 2;\n\n    RETURN result;\nEND \/\/\nDELIMITER ;\n\n-- \u4f7f\u7528\u5b58\u50a8\u51fd\u6570\nSELECT func_name(5);\n<\/code><\/pre>\n<p><strong>\u4e0e\u5b58\u50a8\u8fc7\u7a0b\u7684\u533a\u522b<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5fc5\u987b\u6709\u8fd4\u56de\u503c<\/li>\n<li>\u4e0d\u80fd\u6267\u884c INSERT\/UPDATE \u7b49\u4fee\u6539\u64cd\u4f5c<\/li>\n<li>\u53ef\u4ee5\u5728 SQL \u8bed\u53e5\u4e2d\u76f4\u63a5\u8c03\u7528<\/li>\n<\/ul>\n<h3>\u89e6\u53d1\u5668<\/h3>\n<p>\u89e6\u53d1\u5668\u662f\u5728\u7279\u5b9a\u6570\u636e\u5e93\u4e8b\u4ef6\u53d1\u751f\u65f6\u81ea\u52a8\u6267\u884c\u7684\u7279\u6b8a\u5b58\u50a8\u8fc7\u7a0b\u3002<\/p>\n<pre><code class=\"language-sql line-numbers\">DELIMITER \/\/\nCREATE TRIGGER trig_name \nBEFORE\/AFTER INSERT\/UPDATE\/DELETE \nON table_name \nFOR EACH ROW \nBEGIN\n    -- \u89e6\u53d1\u5668\u903b\u8f91\n    IF NEW.column &gt; 100 THEN\n        INSERT INTO log_table VALUES('Condition met');\n    END IF;\nEND \/\/\nDELIMITER ;\n<\/code><\/pre>\n<p><strong>\u89e6\u53d1\u5668\u5e94\u7528\u573a\u666f<\/strong>\uff1a<\/p>\n<ul>\n<li>\u6570\u636e\u4e00\u81f4\u6027\u6821\u9a8c<\/li>\n<li>\u81ea\u52a8\u8bb0\u5f55\u65e5\u5fd7<\/li>\n<li>\u5b9e\u73b0\u590d\u6742\u7684\u4e1a\u52a1\u89c4\u5219<\/li>\n<\/ul>\n<h2>\u9501\u673a\u5236<\/h2>\n<p>\u9501\u662f\u5e76\u53d1\u63a7\u5236\u7684\u5173\u952e\u673a\u5236\uff0c\u786e\u4fdd\u6570\u636e\u5e93\u7684\u4e00\u81f4\u6027\u548c\u5b8c\u6574\u6027\u3002<\/p>\n<h3>\u9501\u7c7b\u578b<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u9501\u7c7b\u578b<\/th>\n<th>\u63cf\u8ff0<\/th>\n<th>\u4f7f\u7528\u573a\u666f<\/th>\n<th>\u7c92\u5ea6<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u5168\u5c40\u9501<\/td>\n<td>\u9501\u5b9a\u6574\u4e2a\u6570\u636e\u5e93<\/td>\n<td>\u5907\u4efd\u64cd\u4f5c<\/td>\n<td>\u6700\u5927<\/td>\n<\/tr>\n<tr>\n<td>\u8868\u7ea7\u9501<\/td>\n<td>\u9501\u5b9a\u6574\u5f20\u8868<\/td>\n<td>\u8bfb\u5199\u63a7\u5236<\/td>\n<td>\u4e2d\u7b49<\/td>\n<\/tr>\n<tr>\n<td>\u884c\u7ea7\u9501<\/td>\n<td>\u9501\u5b9a\u7279\u5b9a\u884c<\/td>\n<td>\u5e76\u53d1\u63a7\u5236<\/td>\n<td>\u6700\u5c0f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u9501\u7684\u4f7f\u7528\u793a\u4f8b<\/strong>\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">-- \u5168\u5c40\u9501\uff08\u614e\u7528\uff09\nFLUSH TABLES WITH READ LOCK;\n-- \u6267\u884c\u5907\u4efd\u64cd\u4f5c\nUNLOCK TABLES;\n\n-- \u8868\u7ea7\u9501\nLOCK TABLES table_name READ;  -- \u8bfb\u9501\nLOCK TABLES table_name WRITE; -- \u5199\u9501\nUNLOCK TABLES;\n\n-- InnoDB \u884c\u7ea7\u9501\uff08\u81ea\u52a8\uff09\n-- \u901a\u8fc7\u4e8b\u52a1\u548c\u7d22\u5f15\u5b9e\u73b0\nBEGIN;\nSELECT * FROM table_name WHERE id = 1 FOR UPDATE;\nCOMMIT;\n<\/code><\/pre>\n<p><strong>\u9501\u7684\u6027\u80fd\u8003\u8651<\/strong>\uff1a<\/p>\n<ul>\n<li>\u5168\u5c40\u9501\u4f1a\u963b\u585e\u6240\u6709\u64cd\u4f5c\uff0c\u4e25\u91cd\u5f71\u54cd\u6027\u80fd<\/li>\n<li>\u8868\u7ea7\u9501\u4f1a\u964d\u4f4e\u5e76\u53d1\u5ea6<\/li>\n<li>\u884c\u7ea7\u9501\u5f00\u9500\u6700\u5c0f\uff0c\u63a8\u8350\u4f7f\u7528<\/li>\n<\/ul>\n<h2>\u6027\u80fd\u4f18\u5316\u6700\u4f73\u5b9e\u8df5<\/h2>\n<ol>\n<li><strong>\u5b9a\u671f\u76d1\u63a7<\/strong>\n<ul>\n<li>\u4f7f\u7528 MySQL \u76d1\u63a7\u5de5\u5177<\/li>\n<li>\u5206\u6790\u6162\u67e5\u8be2\u65e5\u5fd7<\/li>\n<li>\u5b9a\u671f\u68c0\u67e5\u7d22\u5f15\u4f7f\u7528\u60c5\u51b5<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u5408\u7406\u8bbe\u8ba1<\/strong>\n<ul>\n<li>\u89c4\u8303\u6570\u636e\u5e93\u8303\u5f0f<\/li>\n<li>\u907f\u514d\u8fc7\u5ea6\u8bbe\u8ba1<\/li>\n<li>\u6839\u636e\u4e1a\u52a1\u7279\u70b9\u9009\u62e9\u5408\u9002\u7684\u5b58\u50a8\u5f15\u64ce<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u7f13\u5b58\u7b56\u7565<\/strong>\n<ul>\n<li>\u4f7f\u7528 Redis \u7b49\u7f13\u5b58\u4e2d\u95f4\u4ef6<\/li>\n<li>\u5408\u7406\u914d\u7f6e MySQL \u67e5\u8be2\u7f13\u5b58<\/li>\n<li>\u907f\u514d\u7f13\u5b58\u7a7f\u900f\u548c\u96ea\u5d29<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u5206\u5e93\u5206\u8868<\/strong>\n<ul>\n<li>\u5782\u76f4\u62c6\u5206<\/li>\n<li>\u6c34\u5e73\u62c6\u5206<\/li>\n<li>\u4f7f\u7528\u5206\u5e93\u5206\u8868\u4e2d\u95f4\u4ef6<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u5b9a\u671f\u7ef4\u62a4<\/strong>\n<ul>\n<li>\u66f4\u65b0\u7edf\u8ba1\u4fe1\u606f<\/li>\n<li>\u5b9a\u671f OPTIMIZE TABLE<\/li>\n<li>\u5408\u7406\u914d\u7f6e MySQL \u53c2\u6570<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h1>\u6700\u7ec8\u7bc7<\/h1>\n<h2>\u4e3b\u4ece\u590d\u5236\u67b6\u6784<\/h2>\n<h3>\u67b6\u6784\u6982\u8ff0<\/h3>\n<p>\u4e3b\u4ece\u590d\u5236\u662f MySQL \u9ad8\u53ef\u7528\u6027\u548c\u6027\u80fd\u6269\u5c55\u7684\u6838\u5fc3\u67b6\u6784\u6a21\u5f0f\uff0c\u901a\u8fc7\u5c06\u6570\u636e\u4ece\u4e3b\u5e93\u540c\u6b65\u5230\u4ece\u5e93\uff0c\u5b9e\u73b0\u591a\u79cd\u9ad8\u7ea7\u529f\u80fd\u3002<\/p>\n<h4>\u4e3b\u4ece\u590d\u5236\u7684\u6838\u5fc3\u4ef7\u503c<\/h4>\n<ol>\n<li><strong>\u9ad8\u53ef\u7528\u6027<\/strong>\n<ul>\n<li>\u4e3b\u5e93\u6545\u969c\u53ef\u5feb\u901f\u5207\u6362\u5230\u4ece\u5e93<\/li>\n<li>\u663e\u8457\u63d0\u5347\u7cfb\u7edf\u5bb9\u9519\u80fd\u529b<\/li>\n<li>\u51cf\u5c11\u5355\u70b9\u6545\u969c\u98ce\u9669<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u6027\u80fd\u4f18\u5316<\/strong>\n<ul>\n<li>\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb<\/li>\n<li>\u4ece\u5e93\u5206\u62c5\u8bfb\u8bf7\u6c42<\/li>\n<li>\u63d0\u5347\u6574\u4f53\u7cfb\u7edf\u541e\u5410\u91cf<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u6570\u636e\u5907\u4efd<\/strong>\n<ul>\n<li>\u53ef\u5728\u4ece\u5e93\u6267\u884c\u5907\u4efd<\/li>\n<li>\u907f\u514d\u5907\u4efd\u671f\u95f4\u5f71\u54cd\u4e3b\u5e93\u670d\u52a1<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>\u590d\u5236\u539f\u7406\u8be6\u89e3<\/h3>\n<h4>\u590d\u5236\u67b6\u6784<\/h4>\n<pre><code class=\"line-numbers\">\u4e3b\u5e93 (Master)\n    \u2193 Binlog \u540c\u6b65\n\u4ece\u5e93 (Slave1, Slave2...)\n<\/code><\/pre>\n<h4>\u914d\u7f6e\u793a\u4f8b<\/h4>\n<pre><code class=\"language-sql line-numbers\"># \u4e3b\u5e93\u914d\u7f6e (my.cnf)\nlog-bin=mysql-bin\nserver-id=1\nbinlog_format=row\n\n# \u4ece\u5e93\u914d\u7f6e (my.cnf)\nserver-id=2\nread-only=1\nrelay-log=relay-bin\n<\/code><\/pre>\n<h4>\u590d\u5236\u5de5\u4f5c\u6d41\u7a0b<\/h4>\n<ol>\n<li>\u4e3b\u5e93\u8bb0\u5f55\u4e8c\u8fdb\u5236\u65e5\u5fd7\uff08Binlog\uff09<\/li>\n<li>\u4ece\u5e93 I\/O \u7ebf\u7a0b\u8bfb\u53d6\u4e3b\u5e93 Binlog<\/li>\n<li>\u4ece\u5e93 SQL \u7ebf\u7a0b\u91cd\u653e\u65e5\u5fd7<\/li>\n<li>\u5b9e\u73b0\u6570\u636e\u540c\u6b65<\/li>\n<\/ol>\n<h3>\u590d\u5236\u6a21\u5f0f<\/h3>\n<ol>\n<li><strong>\u5f02\u6b65\u590d\u5236<\/strong>\n<ul>\n<li>\u9ed8\u8ba4\u6a21\u5f0f<\/li>\n<li>\u6027\u80fd\u6700\u9ad8<\/li>\n<li>\u5b58\u5728\u6570\u636e\u4e22\u5931\u98ce\u9669<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u534a\u540c\u6b65\u590d\u5236<\/strong>\n<ul>\n<li>\u81f3\u5c11\u4e00\u4e2a\u4ece\u5e93\u786e\u8ba4\u540e\u8fd4\u56de<\/li>\n<li>\u964d\u4f4e\u6570\u636e\u4e22\u5931\u6982\u7387<\/li>\n<li>\u8f7b\u5fae\u6027\u80fd\u635f\u8017<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u7ec4\u590d\u5236\uff08Group Replication\uff09<\/strong>\n<ul>\n<li>\u591a\u8282\u70b9\u4e00\u81f4\u6027<\/li>\n<li>\u9ad8\u53ef\u7528\u96c6\u7fa4\u65b9\u6848<\/li>\n<li>\u5f3a\u4e00\u81f4\u6027\u4fdd\u8bc1<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2>\u5206\u5e93\u5206\u8868\u67b6\u6784<\/h2>\n<h3>\u67b6\u6784\u8bbe\u8ba1\u7406\u5ff5<\/h3>\n<p>\u5206\u5e93\u5206\u8868\u662f\u89e3\u51b3\u5355\u4e00\u6570\u636e\u5e93\u6027\u80fd\u74f6\u9888\u7684\u5173\u952e\u7b56\u7565\uff0c\u901a\u8fc7\u6570\u636e\u5206\u6563\u5b58\u50a8\u63d0\u5347\u6574\u4f53\u6027\u80fd\u3002<\/p>\n<h4>\u6027\u80fd\u74f6\u9888\u5206\u6790<\/h4>\n<ol>\n<li><strong>\u5b58\u50a8\u74f6\u9888<\/strong>\n<ul>\n<li>\u5355\u8868\u6570\u636e\u91cf\u8fc7\u5927<\/li>\n<li>\u7d22\u5f15\u7ef4\u62a4\u6210\u672c\u9ad8<\/li>\n<li>\u67e5\u8be2\u6027\u80fd\u4e0b\u964d<\/li>\n<\/ul>\n<\/li>\n<li><strong>IO \u74f6\u9888<\/strong>\n<ul>\n<li>\u70ed\u70b9\u6570\u636e\u96c6\u4e2d<\/li>\n<li>\u7f13\u5b58\u4e0d\u8db3<\/li>\n<li>\u78c1\u76d8 IO \u538b\u529b\u5927<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u8ba1\u7b97\u74f6\u9888<\/strong>\n<ul>\n<li>\u590d\u6742\u67e5\u8be2 CPU \u6d88\u8017<\/li>\n<li>\u5e76\u53d1\u8bf7\u6c42\u5904\u7406\u80fd\u529b\u53d7\u9650<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>\u5206\u5e93\u5206\u8868\u7b56\u7565<\/h3>\n<h4>\u5782\u76f4\u5206\u5e93<\/h4>\n<pre><code class=\"line-numbers\">\u7528\u6237\u5e93    \u8ba2\u5355\u5e93    \u5546\u54c1\u5e93    \u65e5\u5fd7\u5e93\n<\/code><\/pre>\n<ul>\n<li>\u6309\u4e1a\u52a1\u6a21\u5757\u62c6\u5206<\/li>\n<li>\u964d\u4f4e\u5355\u5e93\u590d\u6742\u5ea6<\/li>\n<li>\u63d0\u9ad8\u7cfb\u7edf\u6a21\u5757\u72ec\u7acb\u6027<\/li>\n<\/ul>\n<h4>\u6c34\u5e73\u5206\u8868<\/h4>\n<pre><code class=\"line-numbers\">user_0    user_1    user_2    user_3\n<\/code><\/pre>\n<ul>\n<li>\u6309\u6570\u636e\u7279\u5f81\u62c6\u5206<\/li>\n<li>\u5e38\u7528\u5206\u7247\u7b97\u6cd5\uff1a\n<ul>\n<li>\u53d6\u6a21\u7b97\u6cd5<\/li>\n<li>\u8303\u56f4\u7b97\u6cd5<\/li>\n<li>\u4e00\u81f4\u6027\u54c8\u5e0c<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>\u5206\u7247\u5173\u952e\u6280\u672f<\/h3>\n<ol>\n<li><strong>\u5206\u7247\u952e\u9009\u62e9<\/strong>\n<ul>\n<li>\u5c3d\u91cf\u5747\u5300\u5206\u5e03<\/li>\n<li>\u67e5\u8be2\u9891\u7e41\u5b57\u6bb5<\/li>\n<li>\u907f\u514d\u70ed\u70b9\u6570\u636e<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u8de8\u5e93\u805a\u5408<\/strong>\n<ul>\n<li>\u91c7\u7528\u6c47\u603b\u8868<\/li>\n<li>\u5f02\u6b65\u8ba1\u7b97<\/li>\n<li>\u7a7a\u95f4\u6362\u65f6\u95f4<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u5206\u5e03\u5f0f ID<\/strong>\n<ul>\n<li>\u5168\u5c40\u552f\u4e00 ID<\/li>\n<li>\u96ea\u82b1\u7b97\u6cd5<\/li>\n<li>\u53f7\u6bb5\u6a21\u5f0f<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2>\u8bfb\u5199\u5206\u79bb\u67b6\u6784<\/h2>\n<h3>\u67b6\u6784\u6a21\u578b<\/h3>\n<pre><code class=\"line-numbers\">              \u8bf7\u6c42\u5206\u53d1\n   \u5ba2\u6237\u7aef \u2190 \u8d1f\u8f7d\u5747\u8861\u5668 \u2192 \u4e3b\u5e93\uff08\u5199\uff09\n                     \u2193\n                 \u4ece\u5e93\u96c6\u7fa4\uff08\u8bfb\uff09\n<\/code><\/pre>\n<h3>\u5b9e\u73b0\u65b9\u6848<\/h3>\n<ol>\n<li><strong>\u4ee3\u7406\u4e2d\u95f4\u4ef6<\/strong>\n<ul>\n<li>MyCat<\/li>\n<li>Sharding-Sphere<\/li>\n<li>ProxySQL<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u6846\u67b6\u7ea7\u5b9e\u73b0<\/strong>\n<pre><code class=\"language-java line-numbers\">\/\/ \u8bfb\u5199\u5206\u79bb\u7b80\u5355\u5b9e\u73b0\nif (SqlType.isRead()) {\n   return slaveDataSource.execute(sql);\n} else {\n   return masterDataSource.execute(sql);\n}\n<\/code><\/pre>\n<\/li>\n<\/ol>\n<h3>\u8d1f\u8f7d\u5747\u8861\u7b56\u7565<\/h3>\n<ol>\n<li><strong>\u968f\u673a\u7b56\u7565<\/strong><\/li>\n<li><strong>\u8f6e\u8be2\u7b56\u7565<\/strong><\/li>\n<li><strong>\u6743\u91cd\u7b56\u7565<\/strong><\/li>\n<li><strong>\u6700\u5c0f\u8fde\u63a5\u6570\u7b56\u7565<\/strong><\/li>\n<\/ol>\n<h2>\u9ad8\u53ef\u7528\u67b6\u6784<\/h2>\n<h3>\u96c6\u7fa4\u67b6\u6784<\/h3>\n<ol>\n<li><strong>\u4e3b\u4ece\u9ad8\u53ef\u7528<\/strong>\n<ul>\n<li>\u6545\u969c\u81ea\u52a8\u5207\u6362<\/li>\n<li>\u6700\u5c0f\u6062\u590d\u65f6\u95f4<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u53cc\u4e3b\u70ed\u5907<\/strong>\n<ul>\n<li>\u4e92\u4e3a\u4e3b\u5907<\/li>\n<li>\u63d0\u9ad8\u53ef\u7528\u6027<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u591a\u8282\u70b9\u96c6\u7fa4<\/strong>\n<ul>\n<li>MGR\uff08MySQL Group Replication\uff09<\/li>\n<li>InnoDB Cluster<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2>\u6700\u4f73\u5b9e\u8df5<\/h2>\n<ol>\n<li><strong>\u76d1\u63a7\u4e0e\u9884\u8b66<\/strong>\n<ul>\n<li>\u6027\u80fd\u6307\u6807\u76d1\u63a7<\/li>\n<li>\u5f02\u5e38\u53ca\u65f6\u901a\u77e5<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u4f18\u96c5\u964d\u7ea7<\/strong>\n<ul>\n<li>\u6d41\u91cf\u63a7\u5236<\/li>\n<li>\u5907\u7528\u65b9\u6848<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u6570\u636e\u4e00\u81f4\u6027<\/strong>\n<ul>\n<li>\u6700\u7ec8\u4e00\u81f4\u6027<\/li>\n<li>\u8865\u507f\u673a\u5236<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h1>\u5b66\u4e60\u8def\u5f84\u63a8\u8350<\/h1>\n<ul>\n<li><strong>\u5165\u95e8<\/strong>\uff1a\u638c\u63e1 MySQL \u7684\u57fa\u672c\u547d\u4ee4\u548c\u6982\u5ff5\u3002<\/li>\n<li><strong>\u8fdb\u9636<\/strong>\uff1a\u6df1\u5165\u5b66\u4e60\u4e8b\u52a1\u3001\u5b58\u50a8\u5f15\u64ce\u548c\u7d22\u5f15\u7684\u4f7f\u7528\u4e0e\u7ba1\u7406\u3002<\/li>\n<li><strong>\u9ad8\u7ea7<\/strong>\uff1a\u638c\u63e1 SQL \u6027\u80fd\u5206\u6790\u3001\u7d22\u5f15\u4f18\u5316\u3001SQL \u4f18\u5316\u6280\u5de7\uff0c\u5b66\u4e60\u9ad8\u7ea7\u6570\u636e\u5e93\u5bf9\u8c61\u548c\u9501\u673a\u5236\u7684\u539f\u7406\u4e0e\u5b9e\u8df5\u3002<\/li>\n<li><strong>\u67b6\u6784\u8bbe\u8ba1<\/strong>\uff1a\u7814\u7a76\u5e76\u5e94\u7528\u4e3b\u4ece\u590d\u5236\u3001\u5206\u5e93\u5206\u8868\u3001\u8bfb\u5199\u5206\u79bb\u3001\u9ad8\u53ef\u7528\u67b6\u6784\u7b49\u6280\u672f\uff0c\u9010\u6b65\u5b9e\u73b0\u6570\u636e\u5e93\u7684\u9ad8\u6027\u80fd\u548c\u9ad8\u53ef\u7528\u3002<\/li>\n<li><strong>\u5b9e\u6218<\/strong>\uff1a\u591a\u7ec3\u4e60\uff0c\u5b9e\u8df5\u662f\u68c0\u9a8c\u5b66\u4e60\u6210\u679c\u7684\u6700\u4f73\u65b9\u5f0f\uff01<\/li>\n<\/ul>\n<hr \/>\n<p>\u5e0c\u671b\u8fd9\u4efd\u6307\u5357\u80fd\u52a9\u4f60\u8f7b\u677e\u9a7e\u9a6d\u6570\u636e\u5e93\u6280\u672f\uff0c\u6784\u5efa\u9ad8\u6548\u7a33\u5b9a\u7684\u7cfb\u7edf\uff01\ud83d\udcca<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7b80\u4ecb MySQL \u662f\u5168\u7403\u6700\u6d41\u884c\u7684\u5f00\u6e90\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u88ab\u5e7f\u6cdb\u5e94\u7528\u4e8e Web \u5e94\u7528\u3001\u4f01\u4e1a\u7ea7\u8f6f\u4ef6\u548c\u5404\u7c7b\u4fe1\u606f\u7cfb\u7edf\u3002\u60f3\u8c61 MySQL  &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"emotion":"","emotion_color":"","title_style":"","license":"","footnotes":""},"categories":[28,27],"tags":[29,25,32,31,33,35,34,30,36],"class_list":["post-194","post","type-post","status-publish","format-standard","hentry","category-mysql","category-27","tag-acid","tag-mysql","tag-32","tag-31","tag-33","tag-35","tag-34","tag-30","tag-36"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL \u5165\u95e8\u6307\u5357 - \u4ee3\u7801\u604b\u7231\u6307\u5357<\/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:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-\u5165\u95e8\u6307\u5357\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL \u5165\u95e8\u6307\u5357 - \u4ee3\u7801\u604b\u7231\u6307\u5357\" \/>\n<meta property=\"og:description\" content=\"\u7b80\u4ecb MySQL \u662f\u5168\u7403\u6700\u6d41\u884c\u7684\u5f00\u6e90\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u88ab\u5e7f\u6cdb\u5e94\u7528\u4e8e Web \u5e94\u7528\u3001\u4f01\u4e1a\u7ea7\u8f6f\u4ef6\u548c\u5404\u7c7b\u4fe1\u606f\u7cfb\u7edf\u3002\u60f3\u8c61 MySQL ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-\u5165\u95e8\u6307\u5357\/\" \/>\n<meta property=\"og:site_name\" content=\"\u4ee3\u7801\u604b\u7231\u6307\u5357\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-15T16:46:10+00:00\" \/>\n<meta name=\"author\" content=\"beizou\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"beizou\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/\"},\"author\":{\"name\":\"beizou\",\"@id\":\"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737\"},\"headline\":\"MySQL \u5165\u95e8\u6307\u5357\",\"datePublished\":\"2024-12-15T16:46:10+00:00\",\"dateModified\":\"2024-12-15T16:46:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/\"},\"wordCount\":147,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737\"},\"keywords\":[\"ACID\",\"MySQL\",\"\u4e3b\u4ece\u590d\u5236\",\"\u4e8b\u52a1\",\"\u5206\u5e93\",\"\u5206\u7247\",\"\u5206\u8868\",\"\u6570\u636e\u5e93\",\"\u8bfb\u5199\u5206\u79bb\"],\"articleSection\":[\"MySQL\",\"\u6570\u636e\u5e93\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/\",\"url\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/\",\"name\":\"MySQL \u5165\u95e8\u6307\u5357 - \u4ee3\u7801\u604b\u7231\u6307\u5357\",\"isPartOf\":{\"@id\":\"https:\/\/codeloveme.com\/#website\"},\"datePublished\":\"2024-12-15T16:46:10+00:00\",\"dateModified\":\"2024-12-15T16:46:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/codeloveme.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \u5165\u95e8\u6307\u5357\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/codeloveme.com\/#website\",\"url\":\"https:\/\/codeloveme.com\/\",\"name\":\"\u4ee3\u7801\u604b\u7231\u6307\u5357\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/codeloveme.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737\",\"name\":\"beizou\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/codeloveme.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/codeloveme.com\/wp-content\/uploads\/2024\/11\/\u540e\u85e4\u72ec.jpg\",\"contentUrl\":\"https:\/\/codeloveme.com\/wp-content\/uploads\/2024\/11\/\u540e\u85e4\u72ec.jpg\",\"width\":1080,\"height\":1060,\"caption\":\"beizou\"},\"logo\":{\"@id\":\"https:\/\/codeloveme.com\/#\/schema\/person\/image\/\"},\"description\":\"\u5f31\u70b9\uff1a\u7231\u60c5 \u4f18\u70b9\uff1a\u6ca1\u6709\u7231\u60c5\",\"sameAs\":[\"http:\/\/codeloveme.com\"],\"url\":\"https:\/\/codeloveme.com\/index.php\/author\/beizou\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL \u5165\u95e8\u6307\u5357 - \u4ee3\u7801\u604b\u7231\u6307\u5357","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:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-\u5165\u95e8\u6307\u5357\/","og_locale":"zh_CN","og_type":"article","og_title":"MySQL \u5165\u95e8\u6307\u5357 - \u4ee3\u7801\u604b\u7231\u6307\u5357","og_description":"\u7b80\u4ecb MySQL \u662f\u5168\u7403\u6700\u6d41\u884c\u7684\u5f00\u6e90\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u88ab\u5e7f\u6cdb\u5e94\u7528\u4e8e Web \u5e94\u7528\u3001\u4f01\u4e1a\u7ea7\u8f6f\u4ef6\u548c\u5404\u7c7b\u4fe1\u606f\u7cfb\u7edf\u3002\u60f3\u8c61 MySQL ...","og_url":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-\u5165\u95e8\u6307\u5357\/","og_site_name":"\u4ee3\u7801\u604b\u7231\u6307\u5357","article_published_time":"2024-12-15T16:46:10+00:00","author":"beizou","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"beizou","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#article","isPartOf":{"@id":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/"},"author":{"name":"beizou","@id":"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737"},"headline":"MySQL \u5165\u95e8\u6307\u5357","datePublished":"2024-12-15T16:46:10+00:00","dateModified":"2024-12-15T16:46:10+00:00","mainEntityOfPage":{"@id":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/"},"wordCount":147,"commentCount":0,"publisher":{"@id":"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737"},"keywords":["ACID","MySQL","\u4e3b\u4ece\u590d\u5236","\u4e8b\u52a1","\u5206\u5e93","\u5206\u7247","\u5206\u8868","\u6570\u636e\u5e93","\u8bfb\u5199\u5206\u79bb"],"articleSection":["MySQL","\u6570\u636e\u5e93"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/","url":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/","name":"MySQL \u5165\u95e8\u6307\u5357 - \u4ee3\u7801\u604b\u7231\u6307\u5357","isPartOf":{"@id":"https:\/\/codeloveme.com\/#website"},"datePublished":"2024-12-15T16:46:10+00:00","dateModified":"2024-12-15T16:46:10+00:00","breadcrumb":{"@id":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/codeloveme.com\/index.php\/2024\/12\/16\/mysql-%e5%85%a5%e9%97%a8%e6%8c%87%e5%8d%97\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/codeloveme.com\/"},{"@type":"ListItem","position":2,"name":"MySQL \u5165\u95e8\u6307\u5357"}]},{"@type":"WebSite","@id":"https:\/\/codeloveme.com\/#website","url":"https:\/\/codeloveme.com\/","name":"\u4ee3\u7801\u604b\u7231\u6307\u5357","description":"","publisher":{"@id":"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/codeloveme.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/codeloveme.com\/#\/schema\/person\/81a4181217586206bf536360ebdbc737","name":"beizou","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/codeloveme.com\/#\/schema\/person\/image\/","url":"https:\/\/codeloveme.com\/wp-content\/uploads\/2024\/11\/\u540e\u85e4\u72ec.jpg","contentUrl":"https:\/\/codeloveme.com\/wp-content\/uploads\/2024\/11\/\u540e\u85e4\u72ec.jpg","width":1080,"height":1060,"caption":"beizou"},"logo":{"@id":"https:\/\/codeloveme.com\/#\/schema\/person\/image\/"},"description":"\u5f31\u70b9\uff1a\u7231\u60c5 \u4f18\u70b9\uff1a\u6ca1\u6709\u7231\u60c5","sameAs":["http:\/\/codeloveme.com"],"url":"https:\/\/codeloveme.com\/index.php\/author\/beizou\/"}]}},"_links":{"self":[{"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/posts\/194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/comments?post=194"}],"version-history":[{"count":5,"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/posts\/194\/revisions"}],"predecessor-version":[{"id":203,"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/posts\/194\/revisions\/203"}],"wp:attachment":[{"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/media?parent=194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/categories?post=194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codeloveme.com\/index.php\/wp-json\/wp\/v2\/tags?post=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}