Question : We want to use mysql general query log to do real-time monitoring and auditing. Currently our approach is: […]
Tag: log
Mariadb default logs location & –log-error
Question : I am using mariadb and I to investigate some issue I wanted to check the logs. To my […]
PostgreSQL doesn’t log
Question : I’m using ArchLinux and PostgreSQL 9.4.4 and have enabled the logging in the config file: $ sudo egrep […]
Know when MySQL server was slow shutdown? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
How to Log All mysql queries into log file?
Question : I am using Mysql 5.6.12 under Wamp server environment. Now I want to log All queries into “.log” […]
Rotation of bin.log file
Question : I am trying to change the binary log rotation from days to hours. By default there is an […]
In Postgres, set log_rotation_size but my logs are still not rotating
Question : I’m using Postgres 9.5 on Ubuntu 14.04. I wanted to rotate my logs whenever they reach a certain […]
PostgreSQL logging: Statements splits into multiple lines
Question : In PostgreSQL v10 and above, I activated the logging of the statements using the extension pg_stat_statements. My configuration: […]
SET extra_float_digits = 3
Question : I’m using PostgreSQL 9.2 with my web application that has three servlets with three selects. I turn on […]
Investigating specific SELECT queries
Question : For a particular row in a table how can I determine the number of reads done to it […]