Statistics about sql connections
Hello, is it possible to get statistics about configured sql connections? At least how many threads are used? Thanks, Andrea -- ---------------------------------------------------------------- Missing your cat? Try looking under my tires. ---------------------------------------------------------------- Ing. Andrea Gabellini Email: andrea.gabellini@telecomitalia.sm Skype: andreagabellini Tel: (+378) 0549 886111 Fax: (+378) 0549 886188 Telecom Italia San Marino S.p.A. Via XXVIII Luglio, 212 - Piano -2 47893 Borgo Maggiore Republic of San Marino http://www.telecomitalia.sm
On Mar 14, 2018, at 8:49 AM, Andrea Gabellini <andrea.gabellini@telecomitalia.sm> wrote:
is it possible to get statistics about configured sql connections? At least how many threads are used?
The server doesn't use threads per SQL connection. There aren't really any stats available for the connections. What kind of statistics are you looking for? Alan DeKok.
Hello, I'm looking for how many connection are open to the various databases. I would like to monitor them to tuning the configuration and eventually generate alarms. Thanks, Andrea Il 14/03/2018 10:34, Alan DeKok ha scritto:
On Mar 14, 2018, at 8:49 AM, Andrea Gabellini <andrea.gabellini@telecomitalia.sm> wrote:
is it possible to get statistics about configured sql connections? At least how many threads are used? The server doesn't use threads per SQL connection.
There aren't really any stats available for the connections.
What kind of statistics are you looking for?
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- ---------------------------------------------------------------- This will shut down Windows, do you want to play another game ? ---------------------------------------------------------------- Ing. Andrea Gabellini Email: andrea.gabellini@telecomitalia.sm Skype: andreagabellini Tel: (+378) 0549 886111 Fax: (+378) 0549 886188 Telecom Italia San Marino S.p.A. Via XXVIII Luglio, 212 - Piano -2 47893 Borgo Maggiore Republic of San Marino http://www.telecomitalia.sm
Hi Andrea, try this: $ netstat -ant --inet | egrep ':(1521|3306|5432)\s' | awk '{print $5}' | cut -d: -f2 | sort | uniq -c Regards, George On 03/14/2018 02:12 PM, Andrea Gabellini wrote:
Hello,
I'm looking for how many connection are open to the various databases. I would like to monitor them to tuning the configuration and eventually generate alarms.
Thanks, Andrea
Il 14/03/2018 10:34, Alan DeKok ha scritto:
On Mar 14, 2018, at 8:49 AM, Andrea Gabellini <andrea.gabellini@telecomitalia.sm> wrote:
is it possible to get statistics about configured sql connections? At least how many threads are used? The server doesn't use threads per SQL connection.
There aren't really any stats available for the connections.
What kind of statistics are you looking for?
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Alan DeKok -
Andrea Gabellini -
George Chelidze