{"id":1992,"date":"2023-04-01T11:25:50","date_gmt":"2023-04-01T03:25:50","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=1992"},"modified":"2023-04-22T07:41:11","modified_gmt":"2023-04-21T23:41:11","slug":"getting-started-with-redis-lua-script-tree-structure-storage-and-query","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/04\/01\/getting-started-with-redis-lua-script-tree-structure-storage-and-query\/","title":{"rendered":"\u73a9\u8f6cRedis-Lua\u811a\u672c\u5165\u95e8\u5230\u5b9e\u6218-\u6811\u5f62\u7ed3\u6784\u5b58\u50a8\u53ca\u67e5\u8be2"},"content":{"rendered":"<h2>\u80cc\u666f<\/h2>\n<p>\u5728toB\u516c\u53f8\u8d1f\u8d23\u4e2d\u53f0\u4e1a\u52a1\uff0c\u4f17\u591a\u4f01\u4e1a\u7684\u90e8\u95e8\u5173\u7cfb\u662f\u6811\u5f62\u7ed3\u6784\uff0c\u524d\u6bb5\u65f6\u95f4\u6709\u4e1a\u52a1\u8bc9\u6c42\u662f\u201c\u5728\u5927\u6570\u636e\u91cf\u4e0b\u9ad8\u6548\u67e5\u8be2\u6307\u5b9a\u90e8\u95e8\u7684\u6240\u6709\u4e0a\u7ea7\u90e8\u95e8\uff0c\u4f01\u4e1a\u7684\u90e8\u95e8\u6811\u5f62\u5173\u7cfb\u53ef\u80fd\u968f\u65f6\u53d8\u66f4\u201d\u3002\u5728MySQL\u7684\u57fa\u7840\u4e0a\u9042\u60f3\u5230\u4e86\u5229\u7528Redis\u7f13\u5b58\u6811\u5f62\u7ed3\u6784\u5e76\u5b9e\u73b0\u9ad8\u6548\u67e5\u8be2\u3002<\/p>\n<h2>\u6811\u5f62\u7ed3\u6784\u7684\u5e38\u89c1\u573a\u666f\u53ca\u89e3\u51b3\u65b9\u6848<\/h2>\n<p><!-- more --><\/p>\n<h3>\u6811\u5f62\u7ed3\u6784\u7684\u5e38\u89c1\u573a\u666f<\/h3>\n<p>\u751f\u6d3b\u4e2d\u6211\u4eec\u6709\u5f88\u591a\u6811\u5f62\u7ed3\u6784\u7684\u6570\u636e\u573a\u666f\uff0c\u6bd4\u5982\uff1a<\/p>\n<ul>\n<li>\u56fd\u5bb6\u884c\u653f\u533a\u57df\u7f16\u7801<\/li>\n<li>\u4f01\u4e1a\u7ec4\u7ec7\u67b6\u6784<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/www.yezhou.me\/AppBlog\/images\/\u6280\u672f\/Redis-\u56fd\u5bb6\u884c\u653f\u533a\u57df\u7f16\u7801.png\" alt=\"\u56fd\u5bb6\u884c\u653f\u533a\u57df\u7f16\u7801\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.yezhou.me\/AppBlog\/images\/\u6280\u672f\/Redis-\u4f01\u4e1a\u7ec4\u7ec7\u67b6\u6784.png\" alt=\"\u4f01\u4e1a\u7ec4\u7ec7\u67b6\u6784\" \/><\/p>\n<p>\u6811\u5f62\u7ed3\u6784\u6570\u636e\u7684\u7279\u5f81\u662f \u6709\u660e\u663e\u7684\u6240\u5c5e\u5173\u7cfb\uff0c\u6bd4\u5982 \u201c\u884c\u653f\u533a\u57df\u7f16\u7801\u201d\u793a\u4f8b\u4e2d\u201c\u671d\u9633\u533a\u201d\u5c5e\u4e8e\u201c\u5317\u4eac\u5e02\u201d\uff0c\u201c\u7ec4\u7ec7\u67b6\u6784\u201d\u793a\u4f8b\u4e2d\u201c\u793e\u4ea4\u4ea7\u54c1\u90e8\u201d\u5c5e\u4e8e\u201c\u4ea7\u54c1\u4e2d\u5fc3\u201d\u3002<\/p>\n<h3>\u6811\u5f62\u7ed3\u6784\u7684\u89e3\u51b3\u65b9\u6848<\/h3>\n<h4>\u90bb\u63a5\u8868<\/h4>\n<p>\u4e1a\u754c\u6700\u5e38\u4f7f\u7528\u7684\u65b9\u6848\u6050\u6015\u5c31\u662f\u201c\u90bb\u63a5\u8868\u201d\u4e86\uff0c\u7b80\u800c\u8a00\u4e4b\uff0c\u201c\u90bb\u63a5\u8868\u201d\u7684\u6bcf\u6761\u6570\u636e\u90fd\u5b58\u50a8\u4e86\u201c\u4e0a\u7ea7\u6570\u636eID\u201d\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u6570\u636eID<\/th>\n<th style=\"text-align: left;\">\u6570\u636e\u540d\u79f0<\/th>\n<th style=\"text-align: left;\">\u4e0a\u7ea7\u6570\u636eID<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">zhangsan<\/td>\n<td style=\"text-align: left;\">\u4ea7\u54c1\u4e2d\u5fc3<\/td>\n<td style=\"text-align: left;\">\u603b\u516c\u53f8ID<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">lisi<\/td>\n<td style=\"text-align: left;\">\u793e\u4ea4\u4ea7\u54c1\u90e8<\/td>\n<td style=\"text-align: left;\">zhangsan<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">wangwu<\/td>\n<td style=\"text-align: left;\">\u529e\u516c\u4ea7\u54c1\u90e8<\/td>\n<td style=\"text-align: left;\">zhangsan<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">zhaoliu<\/td>\n<td style=\"text-align: left;\">\u529e\u516c\u4ea7\u54c1\u4e00\u7ec4<\/td>\n<td style=\"text-align: left;\">wangwu<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">zhouqi<\/td>\n<td style=\"text-align: left;\">\u529e\u516c\u4ea7\u54c1\u4e8c\u7ec4<\/td>\n<td style=\"text-align: left;\">wangwu<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u201c\u90bb\u63a5\u8868\u201d\u7684\u4f18\u70b9\uff1a<\/p>\n<ul>\n<li>\u6dfb\u52a0\u6570\u636e\u9ad8\u6548<\/li>\n<li>\u4fee\u6539\u6570\u636e\u7684\u4e0a\u7ea7\u9ad8\u6548<\/li>\n<li>\u5220\u9664\u53f6\u5b50\u8282\u70b9\u6570\u636e\u9ad8\u6548<\/li>\n<\/ul>\n<p>\u201c\u90bb\u63a5\u8868\u201d\u7684\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>\u5220\u9664\u4e2d\u95f4\u8282\u70b9\u9700\u79fb\u52a8\u5176\u5b50\u8282\u70b9<\/li>\n<li>\u67e5\u8be2\u8282\u70b9\u7684\u6240\u6709\u53f6\u5b50\u8282\u70b9\u3001\u6240\u6709\u7236\u8282\u70b9\u590d\u6742\uff08\u8fd9\u91cc\u6307MySQL\uff0cOracle\u662f\u652f\u6301\u9012\u5f52\u67e5\u8be2\u7684\uff09<\/li>\n<\/ul>\n<h4>\u8def\u5f84\u679a\u4e3e<\/h4>\n<p>\u53e6\u4e00\u4e2a\u6bd4\u8f83\u5e38\u7528\u7684\u65b9\u6848\u5c31\u662f\u201c\u8def\u5f84\u679a\u4e3e\u201d\u4e86\uff0c\u5176\u6838\u5fc3\u601d\u60f3\u662f\uff0c\u6bcf\u6761\u6570\u636e\u90fd\u6709\u5b57\u6bb5\u5b58\u50a8\u4e86\u5176\u6240\u6709\u7684\u4e0a\u7ea7\u4fe1\u606f\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u6570\u636eID<\/th>\n<th style=\"text-align: left;\">\u6570\u636e\u540d\u79f0<\/th>\n<th style=\"text-align: left;\">\u8def\u5f84<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">1<\/td>\n<td style=\"text-align: left;\">\u4e2d\u56fd<\/td>\n<td style=\"text-align: left;\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">11<\/td>\n<td style=\"text-align: left;\">\u5317\u4eac\u5e02<\/td>\n<td style=\"text-align: left;\">1,11<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">110105<\/td>\n<td style=\"text-align: left;\">\u671d\u9633\u533a<\/td>\n<td style=\"text-align: left;\">1,11,110105<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">51<\/td>\n<td style=\"text-align: left;\">\u56db\u5ddd\u7701<\/td>\n<td style=\"text-align: left;\">1,51<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">5101<\/td>\n<td style=\"text-align: left;\">\u6210\u90fd\u5e02<\/td>\n<td style=\"text-align: left;\">1,51,5101<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">510104<\/td>\n<td style=\"text-align: left;\">\u9526\u6c5f\u533a<\/td>\n<td style=\"text-align: left;\">1,51,5101,510104<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u201c\u8def\u5f84\u679a\u4e3e\u201d\u7684\u4f18\u70b9\uff1a<\/p>\n<ul>\n<li>\u67e5\u8be2\u8282\u70b9\u7684\u6240\u6709\u7236\u8282\u70b9\u9ad8\u6548\uff1a<code>select \u8def\u5f84 where \u6570\u636eID = &#039;\u8282\u70b9ID&#039;;<\/code><\/li>\n<li>\u67e5\u8be2\u8282\u70b9\u7684\u6240\u6709\u5b50\u8282\u70b9\u9ad8\u6548\uff1a<code>select \u6570\u636eID where \u8def\u5f84 like &#039;1,51%&#039;;<\/code><\/li>\n<\/ul>\n<p>\u201c\u8def\u5f84\u679a\u4e3e\u201d\u7684\u7f3a\u70b9\uff1a<\/p>\n<ul>\n<li>\u4f9d\u8d56\u590d\u6742\u903b\u8f91\u7ef4\u62a4\u8def\u5f84<\/li>\n<li>\u8def\u5f84\u957f\u5ea6\u53ef\u80fd\u5931\u63a7<\/li>\n<li>\u975e\u53f6\u5b50\u8282\u70b9\u5220\u9664\u6216\u53d8\u66f4\u4e0a\u7ea7\u8282\u70b9\u65f6\uff0c\u6240\u6709\u5b50\u8282\u70b9\u90fd\u5c06\u53d8\u52a8<\/li>\n<\/ul>\n<p>\u9664\u4e86\u201c\u90bb\u63a5\u8868\u201d\u3001\u201c\u8def\u5f84\u679a\u4e3e\u201d\uff0c\u8fd8\u6709\u5b58\u50a8\u5b50\u5b59\u8282\u70b9\u8303\u56f4\u7684\u201c\u5d4c\u5957\u96c6\u201d\u3001\u7ef4\u62a4\u72ec\u7acb\u6570\u636e\u8868\u5b58\u50a8\u6240\u6709\u5b50\u5b59\u8282\u70b9\u5173\u7cfb\u7684\u201c\u95ed\u5305\u8868\u201d\u7b49\u65b9\u6848\u7528\u4e8e\u5b58\u50a8\u6811\u5f62\u7ed3\u6784\u6570\u636e\u3002\u7531\u4e8e\u4e0d\u662f\u672c\u6587\u91cd\u70b9\uff0c\u6b64\u5904\u4e0d\u518d\u8d58\u8ff0\u3002<\/p>\n<p>\u5728\u5b9e\u9645\u7684\u751f\u4ea7\u65b9\u6848\u4e2d\uff0c\u6211\u4eec\u4e5f\u4e0d\u7528\u62d8\u6ce5\u4e8e\u4ee5\u4e0a\u67d0\u4e2a\u65b9\u6848\uff0c\u9002\u5f53\u7684\u5c06\u65b9\u6848\u6574\u5408\u4f7f\u7528\uff0c\u5f80\u5f80\u4e8b\u534a\u529f\u500d\u3002\u6bd4\u5982\u6211\u4eec\u7684\u751f\u4ea7\u7cfb\u7edf\uff0c\u5c31\u6709\u5c06\u201c\u90bb\u63a5\u8868\u201d\u3001\u201c\u8def\u5f84\u679a\u4e3e\u201d\u65b9\u6848\u6df7\u5408\u4f7f\u7528\u7684\u573a\u666f\uff0c\u7efc\u5408\u6027\u80fd\u4e5f\u76f8\u5f53\u51fa\u8272\u3002<\/p>\n<p>\u4e0d\u7ba1\u9ed1\u732b\u767d\u732b\uff0c\u6293\u5230\u8017\u5b50\u5c31\u662f\u597d\u732b\u3002<\/p>\n<h2>Redis\u4e0b\u6811\u5f62\u7ed3\u6784\u7684\u5b58\u50a8<\/h2>\n<p>\u5728\u9610\u8ff0\u5b58\u50a8\u65b9\u6848\u524d\uff0c\u6211\u4eec\u5148\u8be6\u7ec6\u68b3\u7406\u4e0b\u73b0\u6709\u7684\u4e1a\u52a1\u573a\u666f\uff0c\u6280\u672f\u90fd\u662f\u4e3a\u4e1a\u52a1\u670d\u52a1\u7684\u3002<\/p>\n<p>toB\u7cfb\u7edf\uff0c\u7cfb\u7edf\u4e2d\u6709\u4f17\u591a\u4f01\u4e1a\uff08company1 ~ company666\uff09\uff0c\u6bcf\u4e2a\u4f01\u4e1a\u90fd\u6709\u81ea\u5df1\u7684\u90e8\u95e8\u6811\u3002\u793a\u4f8b\uff1a\u67d0\u516c\u53f8 A0 \u4e0b\u6709 B1 ~ B50 \u8fd9 50 \u4e2a\u4e00\u7ea7\u90e8\u95e8\uff1b\u6bcf\u4e2a\u4e00\u7ea7\u90e8\u95e8\u4e0b\u53c8\u6709\u82e5\u5e72\u4e2a\u4e8c\u7ea7\u90e8\u95e8\uff08\u6bd4\u5982 B1 \u4e0b\u6709 CB1-1 ~ CB1-30 \u8fd9 30 \u4e2a\u4e8c\u7ea7\u90e8\u95e8\uff0cB3 \u4e0b\u6709 CB3-1 ~ CB3-40 \u8fd9 40 \u4e2a\u4e8c\u7ea7\u90e8\u95e8\uff09\uff1b\u540c\u7406\uff0c\u6bcf\u4e2a\u4e8c\u7ea7\u90e8\u95e8\u4e0b\u53c8\u6709\u82e5\u5e72\u4e2a\u4e09\u7ea7\u90e8\u95e8\u3002\u5bf9\u4e8e\u5927\u4f01\u4e1a\u800c\u8a00\uff0c\u90e8\u95e8\u8fbe\u5230\u51e0\u5343\u4e0a\u4e07\u3002\u6b64\u5916\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u4f01\u4e1a\u7684\u90e8\u95e8\u4fe1\u606f\u662f\u53ef\u80fd\u968f\u65f6\u53d8\u52a8\u7684\u3002\u800c\u73b0\u5728\u6211\u4eec\u7684\u8bc9\u6c42\u662f\uff1a\u67e5\u8be2\u7b2cN\u7ea7\u67d0\u4e2a\u90e8\u95e8\u7684\u6240\u6709\u4e0a\u7ea7\u90e8\u95e8\u4fe1\u606f\u3002<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.yezhou.me\/AppBlog\/images\/\u6280\u672f\/Redis-\u6811\u5f62\u7ed3\u6784\u7684\u5b58\u50a8.png\" alt=\"\u6811\u5f62\u7ed3\u6784\u7684\u5b58\u50a8\" \/><\/p>\n<p>\u5728MySQL\u573a\u666f\u4e0b\uff0c\u6211\u4eec\u53ef\u4ee5\u201c\u90bb\u63a5\u8868\u201d\u6216\u8005\u201c\u8def\u5f84\u679a\u4e3e\u201d\u65b9\u6848\uff0c\u751a\u81f3\u4e8e\u50cf\u4e0a\u9762\u63d0\u53ca\u7684\u9700\u8981\u505a\u65b9\u6848\u6df7\u5408\u3002\u5bf9\u4e8e\u8bc9\u6c42\u201c\u67e5\u8be2\u8282\u70b9\u7684\u6240\u6709\u7236\u8282\u70b9\u201d\uff0c\u901a\u8fc7\u5148\u524d\u7684\u65b9\u6848\u5206\u6790\uff0c\u201c\u8def\u5f84\u679a\u4e3e\u201d\u662f\u8f83\u4f18\u7684\u65b9\u6848\u3002\u4f46\u5982\u679c\u5f53QPS\u5f88\u9ad8\uff0c\u9700\u8981\u8fdb\u4e00\u6b65\u63d0\u5347\u6027\u80fd\u5462\uff0c\u9664\u4e86\u63d0\u5347DB\u7684\u6027\u80fd\u54cd\u5e94\u5916\uff0c\u6211\u4eec\u662f\u5426\u8fd8\u6709\u5176\u4ed6\u7684\u51fa\u8def\uff1f<\/p>\n<p>\u9ad8\u6027\u80fd\u7684Redis\u8fdb\u5165\u4e86\u6211\u4eec\u7684\u89c6\u91ce\uff0c\u90a3\u4e48\u5982\u4f55\u4f7f\u7528Redis\u5b8c\u6210\u6811\u578b\u7ed3\u6784\u7684\u5b58\u50a8\u5462\uff1f<\/p>\n<p>\u6b64\u5904\u6211\u4eec\u4f7f\u7528\u7684Redis\u6570\u636e\u7ed3\u6784\u662f Hash\uff0cRedis\u7684key\u4e3a\u4f01\u4e1aID\uff08depttree:\u4f01\u4e1aID\uff09\uff0cfield \u4e3a \u90e8\u95e8ID\uff0cfield \u5bf9\u5e94\u7684value\u662f \u8be5\u90e8\u95e8ID\u5bf9\u5e94\u7684\u4e0a\u7ea7\u90e8\u95e8ID\u3002\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.yezhou.me\/AppBlog\/images\/\u6280\u672f\/Redis-Hash\u5b9e\u73b0\u6811\u578b\u7ed3\u6784\u5b58\u50a8.png\" alt=\"Hash\u5b9e\u73b0\u6811\u578b\u7ed3\u6784\u5b58\u50a8\" \/><\/p>\n<p><strong>\u4e1a\u52a1\u903b\u8f91<\/strong>\uff1a<\/p>\n<ul>\n<li>\u67e5\u8be2\u6240\u6709\u7236\u90e8\u95e8\u65f6\uff0c\u5148\u4ece\u7f13\u5b58\u4e2d\u67e5\u8be2\uff0c\u7f13\u5b58\u7f3a\u5931\u65f6\u4eceDB\u67e5\u8be2\u5e76\u66f4\u65b0\u5230Redis<\/li>\n<li>\u90e8\u95e8\u5173\u7cfb\u53d8\u66f4\u65f6\uff0c\u5219\u5220\u9664Redis\u7f13\u5b58<\/li>\n<li>\u90e8\u95e8\u5220\u9664\u65f6\uff0c\u5219\u5220\u9664Redis\u7f13\u5b58<\/li>\n<li>Redis\u4e2d\u7684\u6570\u636e\u5b58\u50a8\u91c7\u7528\u7684\u662f\u201c\u90bb\u63a5\u8868\u201d\u7684\u65b9\u5f0f<\/li>\n<li>\u7531\u4e8e\u4efb\u610f\u90e8\u95e8\u7684\u7236\u90e8\u95e8\u90fd\u53ef\u80fd\u53d8\u52a8\uff0cRedis\u4e2d\u7684\u6570\u636e\u5b58\u50a8\u4e0d\u91c7\u7528\u201c\u8def\u5f84\u679a\u4e3e\u201d\u65b9\u6848<\/li>\n<\/ul>\n<p>\u9700\u8981\u6ce8\u610f\u7684\u662f\uff1a<\/p>\n<ul>\n<li>\u66f4\u65b0Redis\u65f6\u91c7\u7528\u6279\u91cf\u66f4\u65b0\u63d0\u5347\u6027\u80fd\uff0c<code>HMSET key field value [field value \u2026]<\/code><\/li>\n<li>\u5b9e\u9645\u751f\u4ea7\u4e2d\uff0c\u6211\u4eec\u91c7\u7528\u7684\u662f\u4e8c\u7ea7\u7f13\u5b58\uff0c\u65b9\u6848\u66f4\u590d\u6742\uff0c\u6b64\u5904\u4e0d\u5c55\u5f00<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">HMSET depttree:\u4f01\u4e1a001 B1 A0 B2 A0 B3 A0 CB1-1 B1<\/code><\/pre>\n<h2>Redis\u4e2d\u5982\u4f55\u4f7f\u7528Lua\u811a\u672c<\/h2>\n<p>\u5728\u4e0a\u4e00\u8282\u4e2d\u90e8\u95e8\u5173\u7cfb\u6570\u636e\u5df2\u7ecf\u5b58\u5230Redis\u4e86\uff0c\u4ecehash\u7684\u7ed3\u6784\u770b\uff0c\u65e0\u6cd5\u4e00\u6b21\u6027\u67e5\u8be2\u6307\u5b9a\u90e8\u95e8\u7684\u6240\u6709\u4e0a\u7ea7\u90e8\u95e8\uff0c\u6240\u4ee5\u6211\u4eec\u9700\u8981\u4f7f\u7528\u5230 Lua \u811a\u672c\u3002\u6b63\u5f0f\u5b9e\u6218\u4e4b\u524d\uff0c\u6211\u4eec\u5148\u5b66\u4e60\u4e0bRedis\u4e2d\u5982\u4f55\u4f7f\u7528 Lua \u811a\u672c\u3002<\/p>\n<p>Redis 2.6.0 \u7248\u672c\u5f00\u59cb\u652f\u6301 Lua \u811a\u672c\u3002Redis\u4e2d\u4f7f\u7528 Lua \u811a\u672c\u5e94\u76f4\u63a5\u63d0\u4f9b\u7a0b\u5e8f\u4f53\uff0c\u4e0d\u9700\u8981\u4e5f\u4e0d\u80fd\u5b9a\u4e49\u4e00\u4e2a\u51fd\u6570\u3002\u4e0b\u9762\u6211\u4eec\u6765\u5f00\u59cbRedis Lua\u811a\u672c\u7684\u5165\u95e8\u5427\u3002<\/p>\n<h3>Redis\u652f\u6301\u7684Lua\u811a\u672c\u547d\u4ee4\u7b80\u8ff0<\/h3>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u547d\u4ee4<\/th>\n<th style=\"text-align: left;\">\u529f\u80fd<\/th>\n<th style=\"text-align: left;\">\u53c2\u6570<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\"><code>EVAL<\/code><\/td>\n<td style=\"text-align: left;\">\u6267\u884cLua\u811a\u672c<\/td>\n<td style=\"text-align: left;\"><code>EVAL script numkeys key [key \u2026] arg [arg \u2026]<\/code><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"><code>SCRIPT LOAD<\/code><\/td>\n<td style=\"text-align: left;\">\u5c06\u811a\u672c\u5185\u5bb9\u5bfc\u5165Redis\u7684\u811a\u672c\u7f13\u5b58<\/td>\n<td style=\"text-align: left;\"><code>SCRIPT LOAD script<\/code><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"><code>EVALSHA<\/code><\/td>\n<td style=\"text-align: left;\">\u901a\u8fc7\u5bfc\u5165\u811a\u672c\u7684SHA1\u6458\u8981\u503c\u6267\u884c\u811a\u672c<\/td>\n<td style=\"text-align: left;\"><code>EVALSHA sha1 numkeys key [key \u2026] arg [arg \u2026]<\/code><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"><code>SCRIPT EXISTS<\/code><\/td>\n<td style=\"text-align: left;\">\u5224\u65ad\u6307\u5b9aSHA1\u6458\u8981\u503c\u7684\u811a\u672c\u662f\u5426\u5b58\u5728<\/td>\n<td style=\"text-align: left;\"><code>SCRIPT EXISTS sha1 [sha1 \u2026]<\/code><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"><code>SCRIPT FLUSH<\/code><\/td>\n<td style=\"text-align: left;\">\u6e05\u7a7a\u6240\u6709\u7684Lua\u811a\u672c\u7f13\u5b58<\/td>\n<td style=\"text-align: left;\"><code>SCRIPT FLUSH<\/code><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"><code>SCRIPT KILL<\/code><\/td>\n<td style=\"text-align: left;\">\u6740\u6b7b\u6b63\u5728\u6267\u884c\u7684\u6ca1\u6709\u5199\u64cd\u4f5c\u7684Lua\u811a\u672c<\/td>\n<td style=\"text-align: left;\"><code>SCRIPT KILL<\/code><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\"><code>SCRIPT DEBUG<\/code><\/td>\n<td style=\"text-align: left;\">\u8bbe\u7f6eLua\u811a\u672cdebug\u6a21\u5f0f<\/td>\n<td style=\"text-align: left;\"><code>SCRIPT DEBUG YES | SYNC | NO<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Redis\u652f\u6301\u7684Lua\u811a\u672c\u547d\u4ee4\u8be6\u89e3<\/h3>\n<h4>EVAL<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1a<code>EVAL script numkeys key [key \u2026] arg [arg \u2026]<\/code><\/li>\n<li>\u529f\u80fd\uff1a\u6267\u884cLua\u811a\u672c<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a2.6.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1a\u53d6\u51b3\u4e8e\u6267\u884c\u7684\u811a\u672c<\/li>\n<li>\u53c2\u6570\u8bf4\u660e\uff1a<\/li>\n<li>\n<ul>\n<li><code>script<\/code>\uff1a\u811a\u672c\u5185\u5bb9<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li><code>numkeys<\/code>\uff1akey\u7684\u4e2a\u6570<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li><code>[key \u2026]<\/code>\uff1akey\u503c\uff0c\u4e2a\u6570\u5fc5\u987b\u548cnumkeys\u5339\u914d<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li><code>[arg \u2026]<\/code>\uff1a\u9644\u52a0\u53c2\u6570\uff0c[key \u2026]\u540e\u7684\u5747\u4e3a\u9644\u52a0\u53c2\u6570\uff0c\u4e2a\u6570\u4e0d\u56fa\u5b9a<\/li>\n<\/ul>\n<\/li>\n<li>\u8fd4\u56de\u503c\uff1a\u811a\u672c\u6267\u884c\u7ed3\u679c<\/li>\n<li>\u5907\u6ce8\uff1aLua \u811a\u672c\u4e2d\u901a\u8fc7<code>KEYS[1]<\/code>\u3001<code>KEYS[2]<\/code>\u3001<code>ARGV[1]<\/code>\u83b7\u53d6\u4f20\u5165\u7684\u53c2\u6570<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; eval &quot;return redis.call(&#039;set&#039;,&#039;\u516c\u4f17\u53f7&#039;,&#039;appblog.cn&#039;)&quot; 0\nOK\n\n127.0.0.1:6379&gt; eval &quot;return redis.call(&#039;set&#039;,KEYS[1],&#039;bar&#039;)&quot; 1 foo\nOK<\/code><\/pre>\n<h4>SCRIPT LOAD<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1aSCRIPT LOAD script<\/li>\n<li>\u529f\u80fd\uff1a\u5c06\u811a\u672c\u5185\u5bb9\u5bfc\u5165Redis\u7684\u811a\u672c\u7f13\u5b58<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a2.6.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1aO(N)\uff0cN\u53d6\u51b3\u4e8e\u811a\u672c\u5b57\u8282\u957f\u5ea6<\/li>\n<li>\u53c2\u6570\u8bf4\u660e\uff1a<\/li>\n<li>\n<ul>\n<li>script\uff1a\u811a\u672c\u5185\u5bb9<\/li>\n<\/ul>\n<\/li>\n<li>\u8fd4\u56de\u503c\uff1a\u5bfc\u5165\u811a\u672c\u7684SHA1\u6458\u8981\u503c<\/li>\n<li>\u5907\u6ce8<\/li>\n<li>\n<ul>\n<li>\u540c\u4e00\u4e2a\u811a\u672c\u8fde\u7eed\u5bfc\u5165\u8fd4\u56de\u7684SHA1\u6458\u8981\u503c\u76f8\u540c<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>\u5bfc\u5165\u7684\u811a\u672c\u5c06\u7528\u4e8e\u5b58\u653e\u5728Redis\u7684\u811a\u672c\u7f13\u5b58\u91cc\uff0c\u9664\u975e\u4f7f\u7528 FLUSH \u547d\u4ee4\u5220\u9664<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>\u4f7f\u7528<code>redis-cli<\/code>\u4ea4\u4e92\u65f6\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528<code>$(cat .\/luascript\/xxx.lua)<\/code>\u7684\u65b9\u5f0f\u5bfc\u5165\u6307\u5b9a\u8def\u5f84\u4e0b\u7684lua\u811a\u672c<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>\u5982\u679c\u5df2\u7ecf\u8fdb\u5165Redis\u4ea4\u4e92shell\uff0c\u5219\u4e0d\u80fd\u4f7f\u7528\u6b64\u65b9\u5f0f\u4e86<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; SCRIPT LOAD &quot;return 1&quot;\n&quot;e0e1f9fabfc9d4800c877a703b823ac0578ff8db&quot;<\/code><\/pre>\n<pre><code class=\"language-bash\">\/\/ redis-cli \u5bfc\u5165\u6307\u5b9a\u8def\u5f84\u4e0b\u7684lua\u811a\u672c\uff0c\u516c\u4f17\u53f7 zxiaofan\n\n.\/redis-cli -a password -p 6379 script load &quot;$(cat .\/luascript\/xxx.lua)&quot;\nWarning: Using a password with &#039;-a&#039; or &#039;-u&#039; option on the command line interface may not be safe.\n&quot;8144f1139110991cf3f085b70f807a4ef261b727&quot;<\/code><\/pre>\n<h4>EVALSHA<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1a<code>EVALSHA sha1 numkeys key [key \u2026] arg [arg \u2026]<\/code><\/li>\n<li>\u529f\u80fd\uff1a\u901a\u8fc7\u5bfc\u5165\u811a\u672c\u7684SHA1\u6458\u8981\u503c\u6267\u884c\u811a\u672c<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a2.6.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1a\u53d6\u51b3\u4e8e\u6267\u884c\u7684\u811a\u672c<\/li>\n<li>\u53c2\u6570\u8bf4\u660e\uff1a<\/li>\n<li>\n<ul>\n<li><code>sha1<\/code>\uff1a\u5bfc\u5165\u811a\u672c\u7684 sha1 \u6458\u8981\u503c<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li><code>numkeys<\/code>\uff1akey\u7684\u4e2a\u6570<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li><code>[key \u2026]<\/code>\uff1akey\u503c\uff0c\u4e2a\u6570\u5fc5\u987b\u548cnumkeys\u5339\u914d<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li><code>[arg \u2026]<\/code>\uff1a\u9644\u52a0\u53c2\u6570\uff0c[key \u2026]\u540e\u7684\u5747\u4e3a\u9644\u52a0\u53c2\u6570\uff0c\u4e2a\u6570\u4e0d\u56fa\u5b9a<\/li>\n<\/ul>\n<\/li>\n<li>\u8fd4\u56de\u503c\uff1a\u811a\u672c\u6267\u884c\u7ed3\u679c<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; evalsha e0e1f9fabfc9d4800c877a703b823ac0578ff8db 0\n&quot;1&quot;<\/code><\/pre>\n<h4>SCRIPT EXISTS<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1a<code>SCRIPT EXISTS sha1 [sha1 \u2026]<\/code><\/li>\n<li>\u529f\u80fd\uff1a\u5224\u65ad\u6307\u5b9a SHA1 \u6458\u8981\u503c\u7684\u811a\u672c\u662f\u5426\u5b58\u5728<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a2.6.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1aO(N)\uff0cN\u53d6\u51b3\u4e8e SHA1 \u6458\u8981\u503c\u6570\u91cf\uff0c\u5355\u4e2a\u5224\u65ad\u7684\u65f6\u95f4\u590d\u6742\u5ea6\u662fO(1)<\/li>\n<li>\u53c2\u6570\u8bf4\u660e\uff1a<\/li>\n<li>\n<ul>\n<li>[sha1 \u2026]\uff1aSHA1 \u6458\u8981\u503c\u5217\u8868<\/li>\n<\/ul>\n<\/li>\n<li>\u8fd4\u56de\u503c<\/li>\n<li>\n<ul>\n<li>1\uff1a\u811a\u672c\u5b58\u5728<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>0\uff1a\u811a\u672c\u4e0d\u5b58\u5728<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; SCRIPT EXISTS e0e1f9fabfc9d4800c877a703b823ac0578ff8db e0e1f9fabfc9d4800c877a703b823ac0578ff8db2\n1) (integer) 1\n2) (integer) 0<\/code><\/pre>\n<h4>SCRIPT FLUSH<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1a<code>SCRIPT FLUSH<\/code><\/li>\n<li>\u529f\u80fd\uff1a\u6e05\u7a7a\u6240\u6709\u7684Lua\u811a\u672c\u7f13\u5b58<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a2.6.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1aO(N)\uff0cN\u662fRedis \u811a\u672c\u7f13\u5b58\u4e2d\u811a\u672c\u7684\u4e2a\u6570<\/li>\n<li>\u53c2\u6570\u8bf4\u660e\uff1a\u65e0\u53c2\u6570<\/li>\n<li>\u8fd4\u56de\u503c\uff1aOK\uff1a\u6e05\u9664\u6210\u529f<\/li>\n<li>\u5907\u6ce8\uff1aFLUSH\u547d\u4ee4\u65e0\u5dee\u522b\u653b\u51fb\uff0c\u4e0d\u80fd\u6e05\u9664\u6307\u5b9a\u7684\u811a\u672c<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; SCRIPT FLUSH\nOK<\/code><\/pre>\n<h4>SCRIPT KILL<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1a<code>SCRIPT KILL<\/code><\/li>\n<li>\u529f\u80fd\uff1a\u6740\u6b7b\u6b63\u5728\u6267\u884c\u7684\u6ca1\u6709\u5199\u64cd\u4f5c\u7684Lua\u811a\u672c<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a2.6.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1aO(1)<\/li>\n<li>\u53c2\u6570\u8bf4\u660e\uff1a\u65e0\u53c2\u6570<\/li>\n<li>\u5907\u6ce8\uff1aKILL\u547d\u4ee4\u65e0\u5dee\u522b\u653b\u51fb\uff0c\u4e0d\u80fd\u6740\u6b7b\u6307\u5b9a\u7684\u811a\u672c<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; SCRIPT KILL\n(error) NOTBUSY No scripts in execution right now.<\/code><\/pre>\n<h4>SCRIPT DEBUG<\/h4>\n<ul>\n<li>\u53c2\u6570\uff1a<code>SCRIPT DEBUG YES|SYNC|NO<\/code><\/li>\n<li>\u529f\u80fd\uff1a\u8bbe\u7f6eLua\u811a\u672cdebug\u6a21\u5f0f<\/li>\n<li>\u53ef\u7528\u7248\u672c\uff1a3.2.0<\/li>\n<li>\u65f6\u95f4\u590d\u6742\u5ea6\uff1a<code>O(1)<\/code><\/li>\n<li>\u53c2\u6570\u8bf4\u660e<\/li>\n<li>\n<ul>\n<li>YES\uff1a\u8bbe\u7f6edebug\u6a21\u5f0f\u4e3a\u5f02\u6b65\u6a21\u5f0f\uff0c\u8c03\u8bd5\u811a\u672c\u4e0d\u963b\u585e\uff0c\u6240\u6709\u7684\u6539\u53d8\u5728\u5bf9\u8bdd\u5173\u95ed\u540e\u5c06\u56de\u6eda<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>SYNC\uff1a\u8bbe\u7f6edebug\u6a21\u5f0f\u4e3a\u540c\u6b65\u6a21\u5f0f\uff0c\u8c03\u8bd5\u811a\u672c\u5c06\u963b\u585e\uff0c\u6240\u6709\u7684\u6539\u53d8\u5c06\u4fdd\u5b58\u5230Redis<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>NO\uff1a\u7981\u7528\u811a\u672c\u8c03\u8bd5\u6a21\u5f0f<\/li>\n<\/ul>\n<\/li>\n<li>\u8fd4\u56de\u503c\uff1aOK<\/li>\n<li>\u5907\u6ce8\uff1a\u6ca1\u6709\u65b9\u5f0f\u53ef\u4ee5\u67e5\u770b\u5f53\u524d\u7684\u811a\u672c\u8c03\u8bd5\u6a21\u5f0f<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">\/\/ \u6307\u5b9adebug\u6a21\u5f0f\u8c03\u8bd5\u811a\u672c\uff1b\n\n.\/redis-cli --ldb-sync-mode --eval \/tmp\/script.lua<\/code><\/pre>\n<h3>Redis\u5982\u4f55\u8c03\u8bd5Lua\u811a\u672c<\/h3>\n<p>Redis\u4e2d\u5305\u542b\u4e00\u4e2a\u5b8c\u6574\u7684 Lua\u8c03\u8bd5\u5668\uff08Lua debugger\uff09\uff0c\u4ee3\u53f7 LDB<\/p>\n<ul>\n<li>\u8c03\u8bd5\u547d\u4ee4 s\uff1a\u5355\u6b65\u6267\u884c<\/li>\n<li>\u8c03\u8bd5\u547d\u4ee4 p\uff1a\u6253\u5370\u6240\u6709\u53d8\u91cf\u503c<\/li>\n<li>Lua \u811a\u672c\u4e2d\u52a0\u5165<code>redis.debug()<\/code>\u7528\u4e8e\u8c03\u8bd5\u65f6\u6253\u5370\u4fe1\u606f\u5230\u63a7\u5236\u53f0<\/li>\n<li>Lua \u811a\u672c\u52a0\u5165<code>redis.breakpoint()<\/code>\uff0c\u5f53\u4e0b\u4e00\u884c\u6709\u65ad\u70b9\u65f6\u6682\u505c<\/li>\n<\/ul>\n<p>\u5176\u4ed6\u8be6\u7ec6\u8c03\u8bd5\u547d\u4ee4\u8bf4\u660e\u89c1\u4e0b\u6587\u7684\u6ce8\u91ca\uff1a<\/p>\n<pre><code class=\"language-bash\">[redis@redis redis]$.\/redis-cli --ldb --eval \/tmp\/script.lua mykey key1 arg1 arg2\n\nLua debugging session started, please use:\nquit    -- End the session.\nrestart -- Restart the script in debug mode again.\nhelp    -- Show Lua script debugging commands.\n\n\/\/ \u8f93\u5165 help \u53ef \u67e5\u770b\u8c03\u8bd5\u547d\u4ee4\uff0c\u7528\u7684\u6700\u591a\u7684\u5e94\u8be5\u662f s\uff08\u5355\u6b65\u6267\u884c\uff09\n\nlua debugger&gt; help\nRedis Lua debugger help:\n[h]elp               Show this help.\n[s]tep               Run current line and stop again. \u5355\u6b65\u6267\u884c\uff1b\n[n]ext               Alias for step. \u5355\u6b65\u6267\u884c\uff0c\u540cs\uff1b\n[c]continue          Run till next breakpoint. \u6267\u884c\u5230\u4e0b\u4e00\u4e2a\u65ad\u70b9\uff1b\n[l]list              List source code around current line. \u5c55\u793a\u5f53\u524d\u884c\u6e90\u7801\uff1b\n[l]list [line]       List source code around [line].\n                     line = 0 means: current position.\u5c55\u793a\u6307\u5b9a\u884c\u6e90\u7801\uff1b\n[l]list [line] [ctx] In this form [ctx] specifies how many lines\n                     to show before\/after [line]. \u4ece\u7b2c[line]\u884c\u5f00\u59cb\uff0c\u5c55\u793a[ctx]\u884c\u6e90\u7801\uff1b\n[w]hole              List all source code. Alias for &#039;list 1 1000000&#039;. \u5c55\u793a\u6240\u6709\u6e90\u7801\uff1b\n[p]rint              Show all the local variables.\u6253\u5370\u6240\u6709\u53d8\u91cf\u503c\uff1b\n[p]rint &lt;var&gt;        Show the value of the specified variable.\n                     Can also show global vars KEYS and ARGV.\u6253\u5370\u6307\u5b9a\u53d8\u91cf\u503c\uff1b\n[b]reak              Show all breakpoints.\u5c55\u793a\u6240\u6709\u65ad\u70b9\uff1b\n[b]reak &lt;line&gt;       Add a breakpoint to the specified line.\u5728\u6307\u5b9a\u884c\u6dfb\u52a0\u4e00\u4e2a\u65ad\u70b9\uff1b\n[b]reak -&lt;line&gt;      Remove breakpoint from the specified line.\u79fb\u9664\u6307\u5b9a\u884c\u65ad\u70b9\uff1b\n[b]reak 0            Remove all breakpoints.\u79fb\u9664\u6240\u6709\u65ad\u70b9\uff1b\n[t]race              Show a backtrace.\u67e5\u770b\u5f53\u524d\u6267\u884c\u6808\uff1b\n[e]eval &lt;code&gt;       Execute some Lua code (in a different callframe). \u72ec\u7acb\u7684\u6808\u4e2d\u6267\u884cLua\u4ee3\u7801\uff1b\n[r]edis &lt;cmd&gt;        Execute a Redis command.\u6267\u884c\u4e00\u4e2aRedis\u6307\u4ee4\uff1b \n[m]axlen [len]       Trim logged Redis replies and Lua var dumps to len.\n                     Specifying zero as &lt;len&gt; means unlimited.\n[a]bort              Stop the execution of the script. In sync\n                     mode dataset changes will be retained. \u7ec8\u6b62\u811a\u672c\u6267\u884c\uff0csync\u6a21\u5f0f\u4e0b\u5199\u5165\u7684\u6570\u636e\u5c06\u88ab\u4fdd\u7559\uff1b\n\nDebugger functions you can call from Lua scripts:\nredis.debug()        Produce logs in the debugger console.\nredis.breakpoint()   Stop execution like if there was a breakpoint in the\n                     next line of code.<\/code><\/pre>\n<h2>Lua\u811a\u672c\u5b9e\u6218Redis\u6811\u5f62\u7ed3\u6784<\/h2>\n<p>\u524d\u6587\u201cRedis\u4e0b\u6811\u5f62\u7ed3\u6784\u7684\u5b58\u50a8\u201d\u5df2\u8bb2\u8ff0Redis\u4e0b\u6811\u5f62\u7ed3\u679c\u6570\u636e\u7684\u5b58\u50a8\uff0c\u6b64\u5904\u4e3b\u8981\u8bb2\u89e3 \u5982\u4f55\u901a\u8fc7 Lua \u811a\u672c \u5feb\u901f\u67e5\u8be2\u6307\u5b9a\u8282\u70b9\u7684\u6240\u6709\u4e0a\u7ea7\u8282\u70b9<\/p>\n<p>\u811a\u672c\u5165\u53c2\u603b\u5171\u67094\u4e2a\uff1a<\/p>\n<ul>\n<li>rediskey \uff1aRedis\u7684key\uff0ckey\u7684\u6570\u636e\u7ed3\u6784\u662fHash<\/li>\n<li>currentDeptNo \uff1a\u5f85\u67e5\u8be2\u7684\u6307\u5b9a\u90e8\u95e8<\/li>\n<li>utilDeptNo \uff1a\u67e5\u8be2\u4e0a\u7ea7\u90e8\u95e8\u7684\u7ec8\u6b62\u8282\u70b9\uff0c\u67e5\u5230\u6b64\u90e8\u95e8\u4e3a\u6b62<\/li>\n<li>maxGetTimes\uff1a\u8fed\u4ee3\u67e5\u8be2\u6700\u5927\u6b21\u6570\uff0c\u907f\u514d\u810f\u6570\u636e\u5f62\u6210\u6b7b\u5faa\u73af<\/li>\n<li>\n<ul>\n<li>\u6700\u5927\u503c 100\uff0c\u82e5\u4f20\u5165\u7684 maxGetTimes \u8d85\u8fc7 100 \u5c06\u5f3a\u5236\u8d4b\u503c\u4e3a 100<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>\u56e0\u4e3a\u5b9e\u9645\u7684\u90e8\u95e8\u5c42\u7ea7\u6ca1\u6709\u8d85\u8fc7100\u7684<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code class=\"language-bash\">\/\/ \u6570\u636e\u521d\u59cb\u5316\uff0c1 \u7684\u4e0a\u7ea7\u662f 2, 2 \u7684\u4e0a\u7ea7\u662f 3, 3 \u7684\u4e0a\u7ea7\u662f 4\n\n127.0.0.1:6378&gt; HMSET depttree:001 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10\nOK\n\n\/\/ \u6267\u884c\u811a\u672c\n\/\/ \u67e5\u627e \u8282\u70b91 \u7684\u6240\u6709\u4e0a\u7ea7\uff0c\u76f4\u5230\u67e5\u5230\u8282\u70b9 3 \u4e3a\u6b62\uff0c\u6700\u591a\u67e5\u8be2 66 \u6b21\u3002\n\n[redis@redis redis]$ .\/openredis.sh 6378 &quot;--eval luascript\/lua_getAllSupDept.lua depttree:001 1 3 66&quot;\n&quot;1,2,3&quot;<\/code><\/pre>\n<p>lua_getAllSupDept.lua \u811a\u672c\u5df2\u5728github\u5f00\u6e90\uff0c\u6301\u7eed\u5b8c\u5584\u66f4\u65b0\uff1a<a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/github.com\/zxiaofan\/OpenSource_Study\/blob\/master\/redis_scripts\/lua_getAllSupDept.lua\">https:\/\/github.com\/zxiaofan\/OpenSource_Study\/blob\/master\/redis_scripts\/lua_getAllSupDept.lua<\/a><\/p>\n<p>\u5728Lua\u811a\u672c\u4e2d\uff0cRedis \u8fd4\u56de\u7684\u7ed3\u679c\u4e3a (nil) \u65f6\uff0c\u5176\u771f\u5b9e\u7684\u6570\u636e\u7c7b\u578b\u4e3a boolean\uff0c\u6240\u4ee5\u6570\u636e\u4e0d\u5b58\u5728 \u7684\u5224\u65ad\u65b9\u5f0f\u662f<code>if (tempDept == false )<\/code>\u3002<\/p>\n<pre><code class=\"language-lua\">-- Redis Lua\u811a\u672c\uff1a\u67e5\u8be2\u6307\u5b9a\u90e8\u95e8\u7684\u6240\u6709\u4e0a\u7ea7\u90e8\u95e8\n-- \u811a\u672c\u4fdd\u5b58\u4e3a lua_getAllSupDept.lua\uff1b\n\n--[[\n    luaScriptName: getAllSupDept;\n    function: get all Super Dept of currentDeptNo;\nparam:\n    rediskey: the key of redis, the data structures is Hashes;\n    currentDeptNo: the current DeptNo;\n    utilDeptNo: query super dept until the utilDeptNo;\n    maxGetTimes: the max times of query to prevent dead loop.\nresult:\n    a. the whole super detp data;\n    b. the super detp data but not until specified dept(utilDeptNo);\n    c. return currentDeptNo when no data;\n    d. return error &quot;error: the times of query exceeded the maxGetTimes!&quot;;\n    --]]\n\nlocal rediskey = KEYS[1];\nlocal currentDeptNo = KEYS[2];\nlocal utilDeptNo = KEYS[3];\nlocal maxGetTimes = tonumber(KEYS[4]);\n\n-- redis.debug(&quot;rediskey: %q&quot;,rediskey);\n-- redis.debug(&quot;currentDeptNo: %q&quot;,currentDeptNo);\n-- redis.debug(&quot;utilDeptNo: %q&quot;,utilDeptNo);\n-- redis.debug(&quot;maxGetTimes: %q&quot;,maxGetTimes);\n\n    if(currentDeptNo == utilDeptNo) then\n        return currentDeptNo;\n    end\n\n    if(maxGetTimes &gt; 100) then\n        maxGetTimes = 100;\n    end\n\n    local time = 1;\n\n    local result = currentDeptNo;\n    local tempDept = currentDeptNo;\n\n    while(tempDept ~= utilDeptNo)\n    do\n        if(time &gt; maxGetTimes) then\n            return &quot;error: the times of query exceeded the maxGetTimes!&quot;;\n        end\n\n        tempDept = redis.call(&#039;hget&#039;,rediskey , tempDept);\n        -- redis.debug(&quot;tempDept: %q&quot;,tempDept);\n\n        if(tempDept == false or tempDept == &quot;NULL&quot;) then\n            return result;\n        end\n\n        result = result .. &quot;,&quot; .. tempDept;\n        time = time + 1 ;\n    end\n\n    return result;<\/code><\/pre>\n<h2>Redis\u4e2d\u4f7f\u7528Lua\u811a\u672c\u7684\u6ce8\u610f\u4e8b\u9879<\/h2>\n<p>\uff081\uff09\u811a\u672c\u662f\u4e00\u4e2a<strong>\u7a0b\u5e8f\u4f53<\/strong>\uff0c\u4e0d\u80fd\u5b9a\u4e49\u51fd\u6570<\/p>\n<p>\uff082\uff09\u811a\u672c\u6267\u884c\u662f<strong>\u539f\u5b50\u6027<\/strong>\u7684\uff0c\u811a\u672c\u6267\u884c\u65f6\u4e0d\u4f1a\u6709\u5176\u4ed6\u811a\u672c\u6216Redis\u547d\u4ee4\u6267\u884c<\/p>\n<ul>\n<li>\u907f\u514d\u4f7f\u7528 Lua \u6162\u811a\u672c<\/li>\n<\/ul>\n<p>\uff083\uff09Lua\u811a\u672c\u4e2d\u7684\u53d8\u91cf<strong>\u5fc5\u987b\u662f \u5c40\u90e8\u53d8\u91cf<\/strong><\/p>\n<p>\uff084\uff09Lua\u811a\u672c\u53ef\u901a\u8fc7 redis.conf \u4e2d\u7684<code>lua-time-limit<\/code><strong>\u8bbe\u7f6e\u6700\u5927\u8fd0\u884c\u65f6\u95f4<\/strong><\/p>\n<ul>\n<li><code>lua-time-limit<\/code>\uff1a\u9ed8\u8ba45000\uff0c\u53735\u79d2<\/li>\n<li>\u811a\u672c\u8fd0\u884c\u8d85\u8fc7\u65f6\u95f4\u9650\u5236\u540e\uff0cRedis \u5c06\u63a5\u6536\u5176\u4ed6\u6307\u4ee4\uff0c\u4f46\u7531\u4e8e\u8981<strong>\u4fdd\u8bc1\u811a\u672c\u7684\u539f\u5b50\u6027\uff0c\u811a\u672c\u4e0d\u4f1a\u88ab\u7ec8\u6b62\uff0c\u5176\u4ed6\u6307\u4ee4\u5c06\u8fd4\u56de\u201cBUSY\u201d\u9519\u8bef<\/strong><\/li>\n<li>\u53ef\u901a\u8fc7<code>SCRIPT KILL<\/code>\u6740\u6389\u6b63\u5728\u8fd0\u884c\u7684 Lua\u811a\u672c<\/li>\n<li><code>SCRIPT KILL<\/code>\u5c06<strong>\u4e0d\u80fd\u6740\u6b7b\u6b63\u5728\u8fd0\u884c\u7684\u5305\u542b\u4fee\u6539\u64cd\u4f5c\u7684\u811a\u672c<\/strong>\uff0c\u6b64\u65f6\u9700\u8981\u6267\u884c<code>SHUTDOWN NOSAVE<\/code>\u547d\u4ee4\u6765<strong>\u5f3a\u884c\u7ec8\u6b62 Redis<\/strong><\/li>\n<\/ul>\n<p>\uff085\uff09Lua\u811a\u672c\u6267\u884c\u5b8c\u6bd5\u540e\uff0c\u547d\u4ee4\u624d\u8ffd\u52a0\u5199\u5165\u5230AOF\u4e2d<\/p>\n<p>\uff086\uff09\u811a\u672c\u5185\u5bb9\u63d0\u524d\u5bfc\u5165Redis\u4e2d\uff0c\u518d\u5229\u7528<code>EVALSHA sha1<\/code>\u6267\u884c Lua \u811a\u672c\u53ef\u63d0\u5347\u6027\u80fd\uff0c\u5982\u679c\u811a\u672c\u8f83\u5927\uff0c\u8fd8\u53ef\u4ee5\u8282\u7701\u5e26\u5bbd<\/p>\n<blockquote>\n<p><code>SHUTDOWN NOSAVE<\/code>\u548c<code>SHUTDOWN<\/code>\u7684\u533a\u522b\u5728\u4e8e<code>SHUTDOWN NOSAVE<\/code>\u4e0d\u4f1a\u8fdb\u884c\u6301\u4e45\u5316\u64cd\u4f5c\uff0c\u4e5f\u5c31\u662f\u8bf4\u5728\u4e0a\u4e00\u6b21\u5feb\u7167\u540e\u7684\u6570\u636e\u4fee\u6539\u90fd\u5c06\u4e22\u5931<\/p>\n<\/blockquote>\n<pre><code class=\"language-bash\">\/\/ \u6b64\u811a\u672c\u53ef\u88ab SCRIPT KILL \u6740\u6b7b\n\neval &#039;while(true) do print(&quot;1&quot;) end&#039; 0<\/code><\/pre>\n<pre><code class=\"language-bash\">\/\/ \u6b64\u811a\u672c \u4e0d\u53ef\u88ab SCRIPT KILL \u6740\u6b7b\n\neval &quot;redis.call(&#039;set&#039;,&#039;\u516c\u4f17\u53f7&#039;,&#039;appblog&#039;) while true do end&quot; 0<\/code><\/pre>\n<pre><code class=\"language-bash\">\/\/ Lua\u811a\u672c\u6267\u884c\u8d85\u65f6\u540e\uff0c\u65e5\u5fd7\u91cc\u5c06\u6709\u8b66\u544a\n\nLua slow script detected: still in execution after 5000 milliseconds. You can try killing the script using the SCRIPT KILL command. Script SHA1 is: 3245e4edc1a1e2a9bac3c52e99466f9ccabf65c0<\/code><\/pre>\n<pre><code class=\"language-bash\">\/\/ jedis \u63d0\u793a Lua \u811a\u672c\u8d85\u65f6\u4fe1\u606f\uff1b\n\nredis.clients.jedis.exceptions.JedisDataException: BUSY Redis is busy running a script. You can only call SCRIPT KILL or SHUTDOWN NOSAVE.<\/code><\/pre>\n<p><strong>Redis\u96c6\u7fa4\u6a21\u5f0f\u4e0bLua\u811a\u672c\u6ce8\u610f\u4e8b\u9879<\/strong>\uff1a<\/p>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; eval &quot;return {KEYS[1],KEYS[2],ARGV[1],ARGV[2]}&quot; 2 key1 key2 \u516c\u4f17\u53f7 appblog\n(error) CROSSSLOT Keys in request don&#039;t hash to the same slot<\/code><\/pre>\n<p>Redis Cluster \u64cd\u4f5c\u591akey\u65f6\uff0c\u8981\u6c42\u547d\u4ee4\u4e2d\u7684\u6240\u6709key\u90fd\u5c5e\u4e8e\u4e00\u4e2aslot\uff0c\u5426\u5219\u4f1a\u629b\u51fa\u5f02\u5e38<code>CROSSSLOT Keys in request don&#039;t hash to the same slot<\/code><\/p>\n<p>\u901a\u8fc7\u67e5\u770bjedis\u7684<code>getSlot<\/code>\u6e90\u7801\uff0c\u6211\u4eec\u53ef\u4ee5\u53d1\u73b0\uff0c\u5982\u679c key \u5305\u542b<code>{}<\/code>\uff0c\u5219\u4f1a\u4f7f\u7528\u7b2c\u4e00\u4e2a<code>{}<\/code>\u4e2d\u7684\u5b57\u7b26\u4e32\u4f5c\u4e3a hash key\uff0c\u6240\u4ee5\u96c6\u7fa4\u6a21\u5f0f\u4e0b\u6211\u4eec\u53ef\u4ee5\u5c06 Redis key \u7684\u76f8\u540c\u5185\u5bb9\u4f7f\u7528<code>{}<\/code>\u5305\u88c5\u8d77\u6765\u3002<\/p>\n<p>\u6240\u4ee5\u5c06\u4e0a\u9762\u62a5\u9519\u7684\u8bed\u53e5\u7684 key1 key2 \u4fee\u6539\u4e3a<code>{key}1 {key}2<\/code>\u5373\u53ef\u6b63\u5e38\u8fd0\u884c<\/p>\n<pre><code class=\"language-bash\">127.0.0.1:6379&gt; eval &quot;return {KEYS[1],KEYS[2],ARGV[1],ARGV[2]}&quot; 2 {key}1 {key}2 \u516c\u4f17\u53f7 appblog\n1) &quot;{key}1&quot;\n2) &quot;{key}2&quot;\n3) &quot;\u516c\u4f17\u53f7&quot;\n4) &quot;appblog&quot;<\/code><\/pre>\n<blockquote>\n<p>\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c<code>{}<\/code>\u6a21\u5f0f\u867d\u7136\u80fd\u5c06\u4e0d\u540c\u7684 key hash \u5230\u76f8\u540c<code>solt<\/code>\uff0c\u4f46\u6570\u636e\u91cf\u8fc7\u5927\u65f6\uff0c\u6781\u6613\u9020\u6210<strong>\u6570\u636e\u503e\u659c<\/strong>\uff0c\u4ece\u800c\u5f71\u54cd\u7cfb\u7edf\u7684\u7a33\u5b9a\u6027\u3002\u6240\u4ee5\u4f7f\u7528\u524d\u8bf7\u5145\u5206\u5206\u6790\u8bc4\u4f30\u6570\u636e\uff0c\u6309\u9700\u7075\u6d3b\u5904\u7406<\/p>\n<\/blockquote>\n<pre><code class=\"language-java\">\/\/ \u96c6\u7fa4\u6a21\u5f0fgetSlot\u64cd\u4f5c\n\/\/ \u6e90\u7801\u6765\u81ea\uff1ahttps:\/\/github.com\/redis\/jedis\/blob\/6ed1441ca4c5de7e66648edfeafa16854707482c\/src\/main\/java\/redis\/clients\/jedis\/util\/JedisClusterCRC16.java\n\npublic static int getSlot(byte[] key) {\n    if (key == null) {\n        throw new JedisClusterOperationException(&quot;Slot calculation of null is impossible&quot;);\n    }\n\n    int s = -1;\n    int e = -1;\n    boolean sFound = false;\n    for (int i = 0; i &lt; key.length; i++) {\n        if (key[i] == &#039;{&#039; &amp;&amp; !sFound) {\n            s = i;\n            sFound = true;\n        }\n        if (key[i] == &#039;}&#039; &amp;&amp; sFound) {\n            e = i;\n            break;\n        }\n    }\n    if (s &gt; -1 &amp;&amp; e &gt; -1 &amp;&amp; e != s + 1) {\n        return getCRC16(key, s + 1, e) &amp; (16384 - 1);\n    }\n    return getCRC16(key) &amp; (16384 - 1);\n}<\/code><\/pre>\n<h2>\u540e\u8bb0<\/h2>\n<p>Lua \u811a\u672c\u6cd5\u529b\u65e0\u8fb9\uff0c\u4f46\u4e5f\u9700\u614e\u4e4b\u53c8\u614e\uff0c\u907f\u514d\u8d85\u65f6\u963b\u585e\uff0c\u907f\u514d\u6570\u636e\u503e\u659c<\/p>\n<p>\u751f\u4ea7\u73af\u5883\u4f7f\u7528 Lua \u811a\u672c\u65f6\uff0c\u5fc5\u987b\u6709\u4e25\u683c\u7684\u68c0\u67e5\u8bc4\u5ba1\u673a\u5236<\/p>\n<p>\u53c2\u8003\u6587\u6863\uff1a<\/p>\n<ul>\n<li><a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/redis.io\/commands\/eval\">https:\/\/redis.io\/commands\/eval<\/a><\/li>\n<li><a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/redis.io\/topics\/ldb\">https:\/\/redis.io\/topics\/ldb<\/a><\/li>\n<\/ul>\n<blockquote>\n<p>\u8f6c\u8f7d\u81f3\uff1a<a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/zxiaofan.blog.csdn.net\/article\/details\/111146879\">https:\/\/zxiaofan.blog.csdn.net\/article\/details\/111146879<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u80cc\u666f \u5728toB\u516c\u53f8\u8d1f\u8d23\u4e2d\u53f0\u4e1a\u52a1\uff0c\u4f17\u591a\u4f01\u4e1a\u7684\u90e8\u95e8\u5173\u7cfb\u662f\u6811\u5f62\u7ed3\u6784\uff0c\u524d\u6bb5\u65f6\u95f4\u6709\u4e1a\u52a1\u8bc9\u6c42\u662f\u201c\u5728\u5927\u6570\u636e\u91cf\u4e0b\u9ad8\u6548\u67e5\u8be2\u6307\u5b9a\u90e8 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[88],"class_list":["post-1992","post","type-post","status-publish","format-standard","hentry","category-redis","tag-lua"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1992"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1992\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}