Skip to content

Instantly share code, notes, and snippets.

@johnsom
Last active July 15, 2016 17:02
Show Gist options
  • Save johnsom/89a3c886bc3befec9f05ae77a4f6c380 to your computer and use it in GitHub Desktop.
Save johnsom/89a3c886bc3befec9f05ae77a4f6c380 to your computer and use it in GitHub Desktop.
mysql> select * from listener_statistics;
+--------------------------------------+----------+-----------+--------------------+-------------------+--------------------------------------+
| listener_id | bytes_in | bytes_out | active_connections | total_connections | amphora_id |
+--------------------------------------+----------+-----------+--------------------+-------------------+--------------------------------------+
| 4f30c4d2-1d05-4a75-885e-5ab790034235 | 144 | 148 | 0 | 2 | 004c3d88-9c2c-4ca6-84c1-b7c28fc04ab4 |
| 4f30c4d2-1d05-4a75-885e-5ab790034235 | 0 | 0 | 0 | 0 | 1cbdbf44-1668-4836-9f69-46e8e8fa663b |
+--------------------------------------+----------+-----------+--------------------+-------------------+--------------------------------------+
2 rows in set (0.00 sec)
LB with 2 listeners in Act/Stby:
mysql> select * from listener_statistics;
+--------------------------------------+----------+-----------+--------------------+-------------------+--------------------------------------+
| listener_id | bytes_in | bytes_out | active_connections | total_connections | amphora_id |
+--------------------------------------+----------+-----------+--------------------+-------------------+--------------------------------------+
| 4f30c4d2-1d05-4a75-885e-5ab790034235 | 144 | 148 | 0 | 2 | 004c3d88-9c2c-4ca6-84c1-b7c28fc04ab4 |
| 4f30c4d2-1d05-4a75-885e-5ab790034235 | 0 | 0 | 0 | 0 | 1cbdbf44-1668-4836-9f69-46e8e8fa663b |
| 8b1c2afe-5a62-4e08-a780-9e5d8c38721c | 77 | 74 | 0 | 1 | 004c3d88-9c2c-4ca6-84c1-b7c28fc04ab4 |
| 8b1c2afe-5a62-4e08-a780-9e5d8c38721c | 0 | 0 | 0 | 0 | 1cbdbf44-1668-4836-9f69-46e8e8fa663b |
+--------------------------------------+----------+-----------+--------------------+-------------------+--------------------------------------+
4 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment