4 ms·
As a stopgap solution, enabling the slow query log can also be very helpful.
by perlgeek 11y ago
As a stopgap solution, enabling the slow query log can also be very helpful.
- protomyth 11y agoYep. A lot of databases have some form of system tables that can tell you a lot about a running system with just some queries. I know Sybase and MS SQL server have the tables to find all the current queries and what they are doing. Ingress had a neat graph (seeing FSM should illicit a panic in most DBAs) and a log monitor. Read up on what is part of the database and write some tools.