Displaying 4 results from an estimated 4 matches for "total_connect".
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
2019 Oct 30
0
Dovecot and MySQL aborted connections.
...0 | 0 | 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_schem...
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_schem...
2010 May 29
0
User Error during memcached integration
...g the problem
and run ''stats'', I get
STAT pid 16136
STAT uptime 7398638
STAT time 1275059978
STAT version 1.2.8
STAT pointer_size 64
STAT rusage_user 7.085922
STAT rusage_system 13.275981
STAT curr_items 10878
STAT total_items 11441
STAT bytes 2020180
STAT curr_connections 5
STAT total_connections 306
STAT connection_structures 11
STAT cmd_flush 0
STAT cmd_get 457326
STAT cmd_set 11441
STAT get_hits 412184
STAT get_misses 45142
STAT evictions 0
STAT bytes_read 22600329
STAT bytes_written 53036649
STAT limit_maxbytes 30064771072
STAT threads 5
STAT accepting_conns 1
STAT listen_disabled_n...