{"id":123975,"date":"2026-11-08T15:33:14","date_gmt":"2026-11-08T07:33:14","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/123975.html"},"modified":"2026-11-08T15:33:14","modified_gmt":"2026-11-08T07:33:14","slug":"100%e4%bb%b6%e5%ba%93%e5%ad%98%e5%8d%96%e5%87%ba%e5%8e%bb130%e4%bb%b6%ef%bc%9aflask%e7%a7%92%e6%9d%80redis%e9%a2%84%e6%89%a3%e5%ba%93%e5%ad%98%e5%8a%a0lua%e5%8e%9f%e5%ad%90%e6%89%a3%e5%87%8f","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/123975.html","title":{"rendered":"100\u4ef6\u5e93\u5b58\u5356\u51fa\u53bb130\u4ef6\uff1aFlask\u79d2\u6740Redis\u9884\u6263\u5e93\u5b58\u52a0Lua\u539f\u5b50\u6263\u51cf"},"content":{"rendered":"

\u26a0\ufe0f \u514d\u8d23\u58f0\u660e：\u672c\u6587\u9879\u76ee\u4ec5\u4f9b\u6280\u672f\u5b66\u4e60\u53c2\u8003，\u4e25\u7981\u76f4\u63a5\u4f5c\u4e3a\u6bd5\u4e1a\u8bbe\u8ba1\u6216\u8bfe\u7a0b\u4f5c\u4e1a\u63d0\u4ea4，\u66f4\u4e0d\u5f97\u7528\u4e8e\u4efb\u4f55\u672a\u6388\u6743\u7684\u771f\u5b9e\u7cfb\u7edf\u6d4b\u8bd5\u3002\u6240\u6709\u6f14\u793a\u5747\u5728\u672c\u4eba\u672c\u5730\u9879\u76ee\u4e0a\u8fdb\u884c\u3002\u5b66\u672f\u8bda\u4fe1\u3001\u5408\u6cd5\u5408\u89c4\u4ece\u6211\u505a\u8d77 🙂<\/p>\n

\n

\u5148\u8bf4\u7ed3\u8bba<\/h3>\n

\u6bd5\u8bbe\u60f3\u52a0\u5206，\u52a0\u4e2a\u79d2\u6740\u6700\u5212\u7b97\u3002\u8001\u5e08\u4e00\u773c\u5c31\u80fd\u770b\u51fa\u4f60\u78b0\u8fc7\u9ad8\u5e76\u53d1\u3002<\/p>\n

\u53ef\u5b83\u4e5f\u662f\u7ffb\u8f66\u6700\u72e0\u7684\u5730\u65b9\u3002\u6211\u7b2c\u4e00\u6b21\u538b\u6d4b，100 \u4ef6\u5e93\u5b58\u5356\u51fa 130 \u4ef6\u3002\u90a3\u591a\u51fa\u6765\u7684 30 \u5355，\u4e0d\u662f\u53d1\u8d27\u8d54\u94b1，\u5c31\u662f\u9000\u6b3e\u6328\u9a82\u3002<\/p>\n

\u539f\u56e0\u7279\u522b\u571f：\u6211\u5148\u67e5\u5e93\u5b58，\u518d\u6263\u5e93\u5b58，\u4e2d\u95f4\u9694\u4e86\u51e0\u6beb\u79d2\u3002\u5e76\u53d1\u4e00\u8d77\u6765，10 \u4e2a\u8bf7\u6c42\u540c\u65f6\u770b\u5230"\u8fd8\u5269 1 \u4ef6"，10 \u4e2a\u4eba\u5168\u6263\u6210\u529f\u3002<\/p>\n

\u8fd9\u7bc7\u6211\u6309\u5b9e\u9645\u8e29\u5751\u7684\u987a\u5e8f\u5199\u2014\u2014\u5148\u8ba9\u8d85\u5356\u73b0\u5f62，\u518d\u4e00\u5c42\u5c42\u5f80\u4e0a\u52a0\u65b9\u6848，\u6700\u540e\u8bb2\u5e93\u5b58\u600e\u4e48\u5bf9\u8d26\u3002\u4ee3\u7801\u53ef\u4ee5\u76f4\u63a5\u6284\u8fdb\u4f60\u7684\u9879\u76ee\u3002<\/p>\n

\n

\u4e00\u3001\u5148\u8ba9\u95ee\u9898\u66b4\u9732\u51fa\u6765<\/h3>\n

\u4e0d\u538b\u6d4b，\u4f60\u6c38\u8fdc\u4e0d\u77e5\u9053\u81ea\u5df1\u591a\u8106\u3002\u6211\u7528\u7684\u5c31\u662f\u6700\u571f\u7684 ab：<\/p>\n

# 200 \u5e76\u53d1，\u603b\u5171 1000 \u6b21\u8bf7\u6c42<\/span>
\nab -n<\/span> 1000<\/span> -c<\/span> 200<\/span> http:\/\/127.0.0.1:5000\/seckill\/1<\/p>\n

\u7b2c\u4e00\u7248\u4ee3\u7801\u957f\u8fd9\u6837：<\/p>\n

@app.<\/span>route<\/span>(<\/span>'\/seckill\/<int:goods_id>'<\/span>,<\/span> methods=<\/span>[<\/span>'POST'<\/span>]<\/span>)<\/span>
\n@login_required<\/span>
\ndef<\/span> seckill<\/span>(<\/span>goods_id)<\/span>:<\/span>
\n goods =<\/span> Goods.<\/span>query.<\/span>get_or_404(<\/span>goods_id)<\/span><\/p>\n

# \u274c \u67e5<\/span>
\n if<\/span> goods.<\/span>stock <=<\/span> 0<\/span>:<\/span>
\n return<\/span> jsonify(<\/span>{<\/span>'code'<\/span>:<\/span> 1<\/span>,<\/span> 'message'<\/span>:<\/span> '\u5df2\u552e\u7f44'<\/span>}<\/span>)<\/span><\/p>\n

# \u274c \u4e2d\u95f4\u9694\u4e86\u4e00\u6bb5\u65f6\u95f4，\u522b\u4eba\u4e5f\u67e5\u5230\u4e86\u540c\u6837\u7684\u5e93\u5b58<\/span>
\n time.<\/span>sleep(<\/span>0.001<\/span>)<\/span> # \u6a21\u62df\u4e1a\u52a1\u8017\u65f6，\u771f\u5b9e\u9879\u76ee\u91cc\u662f\u67e5\u4f18\u60e0\u5238\u3001\u7b97\u4ef7\u683c<\/span><\/p>\n

# \u274c \u6263<\/span>
\n goods.<\/span>stock -=<\/span> 1<\/span>
\n db.<\/span>session.<\/span>commit(<\/span>)<\/span><\/p>\n

order =<\/span> OrderInfo(<\/span>user_id=<\/span>current_user.<\/span>id<\/span>,<\/span> goods_id=<\/span>goods_id,<\/span> .<\/span>.<\/span>.<\/span>)<\/span>
\n db.<\/span>session.<\/span>add(<\/span>order)<\/span>
\n db.<\/span>session.<\/span>commit(<\/span>)<\/span><\/p>\n

return<\/span> jsonify(<\/span>{<\/span>'code'<\/span>:<\/span> 0<\/span>}<\/span>)<\/span><\/p>\n

\u8dd1\u5b8c\u4e00\u770b\u5e93：stock \u53d8 -30，\u8ba2\u5355\u8868\u8eba\u7740 130 \u6761\u3002<\/p>\n

\u8fd9\u5c31\u662f\u8d85\u5356\u3002 \u6839\u5b50\u4e0d\u5728\u4ee3\u7801\u5199\u9519，\u5728"\u67e5"\u548c"\u6263"\u662f\u4e24\u4ef6\u4e8b，\u4e2d\u95f4\u7559\u4e86\u4e2a\u7a97\u53e3，\u5e76\u53d1\u8bf7\u6c42\u5168\u4ece\u8fd9\u513f\u94bb\u8fdb\u6765\u3002<\/p>\n

\n

\u4e8c\u3001\u7b2c\u4e00\u5c42：\u628a\u5224\u65ad\u548c\u6263\u51cf\u585e\u8fdb\u4e00\u6761 SQL<\/h3>\n

\u6700\u7701\u4e8b\u7684\u4fee\u6cd5，\u662f\u8ba9\u6570\u636e\u5e93\u81ea\u5df1\u4fdd\u8bc1\u539f\u5b50\u6027：<\/p>\n

@app.<\/span>route<\/span>(<\/span>'\/seckill\/<int:goods_id>'<\/span>,<\/span> methods=<\/span>[<\/span>'POST'<\/span>]<\/span>)<\/span>
\n@login_required<\/span>
\ndef<\/span> seckill<\/span>(<\/span>goods_id)<\/span>:<\/span>
\n # \u2705 \u5224\u65ad\u548c\u6263\u51cf\u5728\u540c\u4e00\u4e2a UPDATE \u91cc\u5b8c\u6210<\/span>
\n affected =<\/span> db.<\/span>session.<\/span>execute(<\/span>
\n text(<\/span>"UPDATE goods SET stock = stock – 1 WHERE id = :gid AND stock > 0"<\/span>)<\/span>,<\/span>
\n {<\/span>'gid'<\/span>:<\/span> goods_id}<\/span>
\n )<\/span>.<\/span>rowcount<\/p>\n

if<\/span> affected ==<\/span> 0<\/span>:<\/span>
\n db.<\/span>session.<\/span>rollback(<\/span>)<\/span>
\n return<\/span> jsonify(<\/span>{<\/span>'code'<\/span>:<\/span> 1<\/span>,<\/span> 'message'<\/span>:<\/span> '\u5df2\u552e\u7f44'<\/span>}<\/span>)<\/span><\/p>\n

# \u6263\u6210\u529f\u624d\u5efa\u8ba2\u5355<\/span>
\n order =<\/span> OrderInfo(<\/span>user_id=<\/span>current_user.<\/span>id<\/span>,<\/span> goods_id=<\/span>goods_id,<\/span> .<\/span>.<\/span>.<\/span>)<\/span>
\n db.<\/span>session.<\/span>add(<\/span>order)<\/span>
\n db.<\/span>session.<\/span>commit(<\/span>)<\/span><\/p>\n

return<\/span> jsonify(<\/span>{<\/span>'code'<\/span>:<\/span> 0<\/span>}<\/span>)<\/span><\/p>\n

\u5173\u952e\u662f WHERE stock > 0\u3002\u6570\u636e\u5e93\u6267\u884c UPDATE \u65f6\u4f1a\u7ed9\u8fd9\u4e00\u884c\u52a0\u9501，\u540e\u9762\u7684\u8bf7\u6c42\u5f97\u7b49\u524d\u4e00\u4e2a\u63d0\u4ea4\u5b8c\u624d\u80fd\u8bfb，\u8bfb\u5230\u7684\u5c31\u662f\u6263\u8fc7\u4e4b\u540e\u7684\u5e93\u5b58\u3002rowcount \u662f 0，\u8bf4\u660e\u6ca1\u6263\u5230，\u76f4\u63a5\u8fd4\u56de\u552e\u7f44\u3002<\/p>\n

\u518d\u538b\u4e00\u6b21：\u5e93\u5b58 0，\u8ba2\u5355 100 \u6761\u3002 \u8d85\u5356\u6ca1\u4e86\u3002<\/p>\n

\u7b54\u8fa9\u53ef\u4ee5\u8fd9\u4e48\u8bf4：\u628a"\u8bfb-\u6539-\u5199"\u4e09\u4e2a\u52a8\u4f5c\u538b\u6210\u4e00\u6761\u539f\u5b50\u8bed\u53e5，\u7528\u6570\u636e\u5e93\u7684\u884c\u9501\u4fdd\u8bc1\u4e92\u65a5，\u6d88\u6389\u68c0\u67e5\u4e0e\u6267\u884c\u4e4b\u95f4\u7684\u7ade\u6001\u7a97\u53e3\u3002<\/p>\n

\u4f46\u8fd9\u6761\u65b9\u6848\u6709\u4e2a\u786c\u4f24：\u6240\u6709\u8bf7\u6c42\u90fd\u6253\u5728\u6570\u636e\u5e93\u4e0a\u3002200 \u5e76\u53d1\u7684\u65f6\u5019 MySQL \u8fde\u63a5\u6c60\u76f4\u63a5\u6253\u6ee1，\u54cd\u5e94\u65f6\u95f4\u4ece 20ms \u98d9\u5230 3 \u79d2\u3002\u5e93\u5b58\u662f\u51c6\u4e86，\u670d\u52a1\u4e5f\u5feb\u6302\u4e86\u3002<\/p>\n

\n

\u4e09\u3001\u7b2c\u4e8c\u5c42：\u628a\u5e93\u5b58\u642c\u5230 Redis<\/h3>\n

\u79d2\u6740\u662f\u5178\u578b\u7684\u8bfb\u591a\u5199\u5c11\u3001\u77ac\u65f6\u9ad8\u5e76\u53d1\u3002\u8fd9\u79cd\u6d3b\u6570\u636e\u5e93\u5e72\u4e0d\u597d，Redis \u5728\u884c\u3002<\/p>\n

\u601d\u8def\u5c31\u4e00\u53e5：\u6d3b\u52a8\u5f00\u59cb\u524d\u628a\u5e93\u5b58\u9884\u70ed\u8fdb Redis，\u8bf7\u6c42\u6765\u4e86\u5148\u5728 Redis \u91cc\u6263，\u6263\u6210\u529f\u518d\u5f02\u6b65\u843d\u5e93\u3002\u6570\u636e\u5e93\u4ece"\u6bcf\u79d2\u51e0\u767e\u6b21"\u6389\u5230"\u6bcf\u79d2\u51e0\u5341\u6b21"\u3002<\/p>\n

\u9884\u70ed<\/h4>\n

def<\/span> preload_stock<\/span>(<\/span>goods_id)<\/span>:<\/span>
\n """\u6d3b\u52a8\u5f00\u59cb\u524d\u8c03\u7528，\u628a\u6570\u636e\u5e93\u5e93\u5b58\u5199\u8fdb Redis"""<\/span>
\n goods =<\/span> Goods.<\/span>query.<\/span>get(<\/span>goods_id)<\/span>
\n if<\/span> not<\/span> goods:<\/span>
\n return<\/span> False<\/span>
\n redis_client.<\/span>set<\/span>(<\/span>f'seckill:stock:<\/span>{<\/span>goods_id}<\/span><\/span>'<\/span><\/span>,<\/span> goods.<\/span>stock)<\/span>
\n # \u7528\u6237\u96c6\u5408，\u7528\u6765\u9632\u91cd\u590d\u4e0b\u5355，\u6d3b\u52a8\u7ed3\u675f\u8bb0\u5f97\u5220<\/span>
\n redis_client.<\/span>delete(<\/span>f'seckill:users:<\/span>{<\/span>goods_id}<\/span><\/span>'<\/span><\/span>)<\/span>
\n return<\/span> True<\/span><\/p>\n

\u4f46\u53ea\u7528 Redis \u4e5f\u4e0d\u5b89\u5168<\/h4>\n

\u5f88\u591a\u4eba\u89c9\u5f97"Redis \u662f\u5355\u7ebf\u7a0b\u7684，\u600e\u4e48\u4f1a\u8d85\u5356"，\u7136\u540e\u5199\u51fa\u8fd9\u6837\u7684\u4ee3\u7801：<\/p>\n

# \u274c \u8fd9\u6837\u5199\u7167\u6837\u8d85\u5356<\/span>
\nstock =<\/span> int<\/span>(<\/span>redis_client.<\/span>get(<\/span>f'seckill:stock:<\/span>{<\/span>gid}<\/span><\/span>'<\/span><\/span>)<\/span> or<\/span> 0<\/span>)<\/span>
\nif<\/span> stock <=<\/span> 0<\/span>:<\/span>
\n return<\/span> '\u552e\u7f44'<\/span>
\nredis_client.<\/span>decr(<\/span>f'seckill:stock:<\/span>{<\/span>gid}<\/span><\/span>'<\/span><\/span>)<\/span><\/p>\n

Redis \u5355\u7ebf\u7a0b，\u8bf4\u7684\u662f"\u5355\u6761\u547d\u4ee4"\u539f\u5b50\u6267\u884c，\u4e0d\u662f"\u591a\u6761\u547d\u4ee4"\u6574\u4f53\u539f\u5b50\u3002 GET \u548c DECR \u4e4b\u95f4，\u5176\u4ed6\u5ba2\u6237\u7aef\u7684\u547d\u4ee4\u7167\u6837\u80fd\u63d2\u8fdb\u6765\u3002\u6240\u4ee5\u8fd9\u6761\u770b\u7740\u6ca1\u6bdb\u75c5\u7684\u4ee3\u7801，\u538b\u6d4b\u7167\u6837\u8d85\u5356\u3002<\/p>\n

\n

\u56db\u3001\u7b2c\u4e09\u5c42：Lua \u811a\u672c，\u628a\u591a\u6b65\u538b\u6210\u4e00\u6b65<\/h3>\n

Redis \u8dd1 Lua \u811a\u672c\u65f6，\u6574\u4e2a\u811a\u672c\u88ab\u5f53\u6210\u4e00\u4e2a\u6574\u4f53\u6267\u884c，\u4e2d\u95f4\u63d2\u4e0d\u8fdb\u5176\u4ed6\u5ba2\u6237\u7aef\u7684\u4efb\u4f55\u547d\u4ee4\u3002\u8fd9\u6b63\u662f\u6211\u4eec\u8981\u7684\u539f\u5b50\u6027\u3002<\/p>\n

\u987a\u624b\u628a"\u9632\u91cd\u590d\u4e0b\u5355"\u4e5f\u585e\u4e86\u8fdb\u53bb\u3002<\/p>\n

\u811a\u672c<\/h4>\n

\u65b0\u5efa lua\/seckill.lua：<\/p>\n

— KEYS[1] = \u5e93\u5b58 key<\/span>
\n— KEYS[2] = \u5df2\u8d2d\u7528\u6237\u96c6\u5408 key<\/span>
\n— ARGV[1] = \u5f53\u524d\u7528\u6237 ID<\/span><\/p>\n

local<\/span> stock_key =<\/span> KEYS[<\/span>1<\/span>]<\/span>
\nlocal<\/span> user_key =<\/span> KEYS[<\/span>2<\/span>]<\/span>
\nlocal<\/span> user_id =<\/span> ARGV[<\/span>1<\/span>]<\/span><\/p>\n

— 1. \u5df2\u7ecf\u4e70\u8fc7\u5c31\u76f4\u63a5\u62d2\u7edd<\/span>
\nif<\/span> redis.<\/span>call<\/span>(<\/span>'SISMEMBER'<\/span>,<\/span> user_key,<\/span> user_id)<\/span> ==<\/span> 1<\/span> then<\/span>
\n return<\/span> –<\/span>2<\/span>
\nend<\/span><\/p>\n

— 2. \u5e93\u5b58\u4e0d\u8db3<\/span>
\nlocal<\/span> stock =<\/span> tonumber<\/span>(<\/span>redis.<\/span>call<\/span>(<\/span>'GET'<\/span>,<\/span> stock_key)<\/span> or<\/span> '0'<\/span>)<\/span>
\nif<\/span> stock <=<\/span> 0<\/span> then<\/span>
\n return<\/span> –<\/span>1<\/span>
\nend<\/span><\/p>\n

— 3. \u539f\u5b50\u6263\u51cf + \u8bb0\u5f55\u7528\u6237<\/span>
\nredis.<\/span>call<\/span>(<\/span>'DECR'<\/span>,<\/span> stock_key)<\/span>
\nredis.<\/span>call<\/span>(<\/span>'SADD'<\/span>,<\/span> user_key,<\/span> user_id)<\/span><\/p>\n

return<\/span> stock –<\/span> 1<\/span><\/p>\n

\u811a\u672c\u8fd4\u56de\u4e09\u4e2a\u503c，\u8c03\u7528\u65b9\u597d\u5224\u65ad：<\/p>\n