Comments - MariaDB configure slow logs to only log certain commands
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Is it possible to remove the long_query_time
because i want to log every select/delete/update/post that has been made on the db
If you want to log all of these queries, you may want to look at the general query log rather. One option is to write the output to a table, which lets you filter easily with SELECT statements., or delete those that don't interest you.
you're an angel
one last question, i hope. Is it possible to have my slow logs in a file and my general logs in a table as it's interesting to keep track of both
The log_output variable sets the destination for both, so they can either both be written to file, both to table, or both to both file and table.
I want to thank you for all the help you've given me and of course the quick replies!
My logs are up and running and looking very dandy!