processlist.lua 376 B

1234567891011121314
  1. --链接数
  2. local M = {}
  3. local mysqldbx = require "mysqldbx"
  4. local tools = require "tools"
  5. local skynet = require "skynet"
  6. local md5 = require "md5"
  7. function M.search(msg_body)
  8. local sql = "SELECT COUNT(*) AS total FROM information_schema.processlist WHERE HOST LIKE '192.168.1.49%'"
  9. local total = mysqldbx.query(sql)
  10. return true,{},total[1].total
  11. end
  12. return M