暂停一个会话但继续处理其他会话

似乎在 Lua 中延迟会话是不可能的，但如果使用 MySQL 服务器来外包延迟，这同样有效，因为它也会强制交错。

local DEBUG = true

local qoi = "SELECT loginattempts,uid FROM mybb_users WHERE username='user1' LIMIT 1"

function read_query(packet)
        ret = nil
        comp_query = qoi
        if string.byte(packet) == proxy.COM_QUERY then
                query = packet:sub(2)
                if query == comp_query then
                        if DEBUG then
                                print("found matching query " .. packet:sub(2))
                                print("insert sleep")
                        end
                        inj_query = "SELECT sleep(30);"
                        new_packet = string.char(proxy.COM_QUERY) .. inj_query
                        proxy.queries:append(1, new_packet, { resultset_is_needed = true })
                        proxy.queries:append(2, packet, { resultset_is_needed = true })
                        ret = proxy.PROXY_SEND_QUERY
                end
        end
        return ret
end

function read_query_result(inj)
        if inj.id == 1 then
                if DEBUG then
                        print("sleep query returns")
                end
                return proxy.PROXY_IGNORE_RESULT
        end
        if inj.id == 2 then
                if DEBUG then
                        print("regular query returns")
                end
                return
        end
        return
end