Skip to content

Instantly share code, notes, and snippets.

@nitinbhojwani

nitinbhojwani/useful_queries.sql

Created April 24, 2016 13:31
Show Gist options
  • Save nitinbhojwani/e03125bd41a5dbbeacb7b43d287ec3d8 to your computer and use it in GitHub Desktop.
Save nitinbhojwani/e03125bd41a5dbbeacb7b43d287ec3d8 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - Useful Queries
Raw
useful_queries.sql
# To Get the list of all the processes
show processlist;
# kill connection or current query of a connection
kill connection <connection_id>
kill query <connection_id>
# Currently Connections Count
show status where `variable_name` = 'Threads_connected';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment