3 ms·
Can you explain how this is a better option than just enabling the general log for MySQL as needed?
by stephenr 8mo ago
Can you explain how this is a better option than just enabling the general log for MySQL as needed?
- anonymous344 8mo agoyes, this was my first question. why would i inspect this data, because maybe trying to find a cause to a problem.. are there any other reasons
- ahoka 8mo agoOr log_statement = 'all' in Postgres.
- luckylion 8mo agoYou don't need to access (or even have access to) the DB server itself (e.g. to read the query-log), you can do everything by just setting a different host to connect to.
- kopirgan 8mo agoLol yeah.. Anyway in any serious application queries fly past like crazy, create temporary tables, pull the columns from several, and do stuff that's hard to interpret on the fly. Especially a software you just use, didn't write. Turning on logging is likely more useful. Have done that to understand inner workings of some financial apps.