This script shows how to measure client traffic by session.

MySQL Proxy is a simple program that sits between your client and MySQL server that can monitor, analyze or transform their communication. See http://forge.mysql.com/wiki/MySQL_Proxy for more information.

local bandwidth = 0
 
function read_query (packet )
    bandwidth = bandwidth + string.len(packet)
    proxy.queries:append(1, packet )
    return proxy.PROXY_SEND_QUERY
end
 
function read_query_result(inj)
    local fields = inj.resultset.fields
    if fields then
        for i = 1, #fields do
            bandwidth = bandwidth + (fields[i] and fields[i].name:len() or 0)
        end
        if rows then
            for row in inj.resultset.rows do
              for i = 1, #inj.resultset.fields do
                    bandwidth = bandwidth + (row[i] and row[i]:len() or 0)
                end
            end
        end
    end
    print (proxy.connection.server['thread_id'],bandwidth)
end

Current Tags

You must be logged in to tag this tool