
mysql: see all open connections to a given database?
Oct 25, 2009 · With administrative permissions im mysql, how can I see all the open connections to a specific db in my server?
How can I view live MySQL queries? - Stack Overflow
Feb 20, 2009 · How can I trace MySQL queries on my Linux server as they happen? For example I'd love to set up some sort of listener, then request a web page and view all of the queries the engine …
php - Real-time MySQL monitoring - Stack Overflow
1 Mysql Workbench has a server monitoring feature as well. It shows basically most things you need to know in real time. To open it, open a connection with a DB, click on the "Server" tab and then "Server …
logging - Log all queries in mysql - Stack Overflow
Nov 20, 2008 · Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all queries for an hour, and dump the log to a file.
How to connect from windows command prompt to mysql command …
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My …
How to show the last queries executed on MySQL?
Mar 16, 2009 · Is there any query/way to show the last queries executed on ALL servers?
Monitoring used connections on mysql to debug 'too many connections'
Mar 16, 2010 · In Debian Lenny, it is part of the package mysql-client-5.0 and I guess it is available for other distros as well. It is especially powerful in monitoring InnoDB internals, but provides general …
MySQL Monitor Replication - Stack Overflow
Jul 2, 2009 · Does anyone knows any free alternative MySQL Enterprise Monitor? I need some tool, that allows me to monitor my 3 servers with replication without having to open ssh console, and use …
How to monitor MySQL space? - Stack Overflow
Jan 12, 2016 · I downloaded a VM image of a web application that uses MySQL. How can I monitor its space consumption and know when additional space must be added?
How to know MySQL replication status using a select query?
The docs for MySQL 5.6, 5.7, and 8.0 seem to indicate it should be equivalent: "For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and …