Skip to content

Instantly share code, notes, and snippets.

@fukajun

fukajun/status.sql

Last active December 29, 2015 09:49
Show Gist options
  • Save fukajun/7652948 to your computer and use it in GitHub Desktop.
Save fukajun/7652948 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL
Raw
status.sql
-- 接続ホスト接続数 接続時間
select left(host, 20) host_prefix, command, count(*), max(time)/3600 from INFORMATION_SCHEMA.PROCESSLIST group by host_prefix, command order by host_prefix;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment