Thanks - I'll give these a try should it happen again.
Jeff
On 9/17/2017 3:10 PM, Eric Broch wrote:
And, here's another one:
mysql -u root -ppassword -BNe "select host,count(host) from
processlist group by host;" information_schema
Explanation:
Display the number of connections to a
And, here's another one:
mysql -u root -ppassword -BNe "select host,count(host) from processlist
group by host;" information_schema
Explanation:
Display the number of connections to a MySQL Database
Count the number of active connections to a MySQL database.
The MySQL command "show
Hi Jeff,
Here are some commands you can run to determine the number of
connections (to determine if this is the issue) to the MariaDB in the
event that this happens again:
1) echo "show full processlist" | mysql -u root -ppassword
2) doveadm who
3) ps aux | grep vpopmail | grep dovecot
For about a 15 minutes period users couldn't receive emails - emails
were bouncing back saying the users did not exist. We traced the problem
to the dovecot log where we saw this:
Sep 15 12:16:23 auth-worker: Error: vmysql: sql error[3]: Table
'vpopmail.users' doesn't exist
Sep 15 12:16:23
