Displaying 4 results from an estimated 4 matches for "current_connections".
2019 Oct 30
2
Dovecot and MySQL aborted connections.
We also spotted these sql connections getting aborted, upon upgrading
MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!)
Turning on mysql general query logging we can see it is Dovecot's mysql
connections that inquire about or update quota usage in particular:
*** /logs//mysql.log ***
2019-10-30T10:52:22.624690-07:00 2 Connect dovecot at localhost on
npomail using
1999 Nov 20
1
openssh and DOS
...Initializes the server options to special values that indicate that they
--- openssh-1.2pre13/sshd.c.orig Fri Nov 19 21:00:51 1999
+++ openssh-1.2pre13/sshd.c Sat Nov 20 00:01:48 1999
@@ -117,6 +117,9 @@
the private key. */
RSA *public_key;
+/* Number of connections open at present. */
+int current_connections = 0;
+
/* Prototypes for various functions defined later in this file. */
void do_connection();
void do_authentication(char *user);
@@ -316,7 +319,12 @@
{
int save_errno = errno;
int status;
- wait(&status);
+
+ /* Reap all the children that are dead. */
+ while (waitpid (0, &s...
2019 Oct 30
0
Dovecot and MySQL aborted connections.
...6071 |
+-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
5 rows in set (0.00 sec)
Only vmail (postfix) has dropped connections (you need performance schema enabled):
mysql> SELECT ess.user, ess.host, (a.total_connections - a.current_connections) - ess.count_star as not_closed, ((a.total_connections - a.current_connections) - ess.count_star) * 100 / (a.total_connections - a.current_connections) as pct_not_closed FROM performance_schema.events_statements_summary_by_account_by_event_name ess JOIN performance_schema.accounts a on (ess.user =...
2019 Oct 31
2
Dovecot and MySQL aborted connections.
...-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
> 5 rows in set (0.00 sec)
>
> Only vmail (postfix) has dropped connections (you need performance schema enabled):
>
> mysql> SELECT ess.user, ess.host, (a.total_connections - a.current_connections) - ess.count_star as not_closed, ((a.total_connections - a.current_connections) - ess.count_star) * 100 / (a.total_connections - a.current_connections) as pct_not_closed FROM performance_schema.events_statements_summary_by_account_by_event_name ess JOIN performance_schema.accounts a on (ess.user =...