mysql数据累加的并发

START TRANSACTION;
SELECT order_count FROM orders WHERE id = 1 FOR UPDATE;
UPDATE orders SET order_count = order_count + 1 WHERE id = 1;
COMMIT;

START TRANSACTION;
SELECT order_count, version FROM orders WHERE id = 1;
UPDATE orders SET order_count = order_count + 1, version = version + 1 WHERE id = 1 AND version = old_version;
COMMIT;

UPDATE orders SET order_count = order_count + 1 WHERE id = 1;

import redis
import time

r = redis.Redis()

def acquire_lock(lock_name, acquire_timeout=10):
    identifier = str(uuid.uuid4())
    end = time.time() + acquire_timeout
    while time.time() < end:
        if r.setnx(lock_name, identifier):
            return identifier
        time.sleep(0.001)
    return False

def release_lock(lock_name, identifier):
    with r.pipeline() as pipe:
        while True:
            try:
                pipe.watch(lock_name)
                if pipe.get(lock_name) == identifier:
                    pipe.multi()
                    pipe.delete(lock_name)
                    pipe.execute()
                    return True
                pipe.unwatch()
                break
            except redis.WatchError:
                pass
    return False

# 使用示例
lock_name = 'order_count_lock'
identifier = acquire_lock(lock_name)
if identifier:
    try:
        # 执行累加操作
        r.incr('order_count')
    finally:
        release_lock(lock_name, identifier)