Skip to content

Instantly share code, notes, and snippets.

@henare

henare/gist:3521931

Created August 30, 2012 03:04
Show Gist options
  • Save henare/3521931 to your computer and use it in GitHub Desktop.
Save henare/3521931 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> show processlist;
+-------+----------+-----------------+---------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+-----------------+---------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 16 | jira | localhost:51978 | jira | Sleep | 3759 | | NULL |
| 31 | collectd | localhost | NULL | Sleep | 8 | | NULL |
| 913 | jira | localhost:53048 | jira | Sleep | 889 | | NULL |
| 17712 | fisheye | localhost:54344 | fisheye | Sleep | 739 | | NULL |
| 20224 | pa_prod | localhost | pa_prod | Query | 3662 | Sending data | SELECT * FROM `alerts` WHERE NOT EXISTS (
SELECT * FROM `applications` WHERE (
|
| 22438 | fisheye | localhost:60078 | fisheye | Sleep | 1437 | | NULL |
| 27273 | jira | localhost:37976 | jira | Sleep | 3768 | | NULL |
| 27371 | jira | localhost:38157 | jira | Sleep | 811 | | NULL |
| 27372 | jira | localhost:38158 | jira | Sleep | 3759 | | NULL |
| 27373 | jira | localhost:38159 | jira | Sleep | 3759 | | NULL |
| 27374 | jira | localhost:38160 | jira | Sleep | 3759 | | NULL |
| 27375 | jira | localhost:38161 | jira | Sleep | 3759 | | NULL |
| 27377 | jira | localhost:38162 | jira | Sleep | 3759 | | NULL |
| 27378 | jira | localhost:38163 | jira | Sleep | 3759 | | NULL |
| 27379 | jira | localhost:38164 | jira | Sleep | 48 | | NULL |
| 27619 | pa_prod | localhost | pa_prod | Query | 2 | Sending data | SELECT `applications`.* FROM `applications` WHERE `applications`.`council_reference` = 'PL09/0593' |
| 28158 | fisheye | localhost:39685 | fisheye | Sleep | 852 | | NULL |
| 28259 | pa_prod | localhost | pa_prod | Query | 5 | Sending data | SELECT COUNT(*) FROM `applications` WHERE (6371.0 * 2 * ASIN(SQRT(POWER(SIN((-27.542402 - applicatio |
| 28260 | pa_prod | localhost | pa_prod | Query | 2 | Sorting result | SELECT applications.*, 6371.0 * 2 * ASIN(SQRT(POWER(SIN((-27.582889 - applications.lat) * PI() / 18 |
| 28261 | pa_prod | localhost | pa_prod | Query | 2 | Sending data | SELECT COUNT(*) FROM `applications` WHERE (6371.0 * 2 * ASIN(SQRT(POWER(SIN((-27.965404 - applicatio |
| 28262 | pa_prod | localhost | pa_prod | Query | 25 | Sending data | SELECT COUNT(*) FROM `applications` WHERE (6371.0 * 2 * ASIN(SQRT(POWER(SIN((-27.542402 - applicatio |
| 28263 | pa_prod | localhost | pa_prod | Query | 2 | Sending data | SELECT COUNT(*) FROM `applications` WHERE (6371.0 * 2 * ASIN(SQRT(POWER(SIN((-27.687212 - applicatio |
| 28675 | fisheye | localhost:40833 | fisheye | Sleep | 481 | | NULL |
| 29068 | fisheye | localhost:41808 | fisheye | Sleep | 1 | | NULL |
| 29069 | fisheye | localhost:41809 | fisheye | Sleep | 476 | | NULL |
| 29197 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+-------+----------+-----------------+---------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
26 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment