Question : So I recently realized my /var directory was growing but couldn’t find anything using du, then find out […]
Tag: logs
SQL Server Event Log Summary [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Can stable (or immutable) functions call volatile functions?
Question : The PostgreSQL documentation states: Any function with side-effects must be labeled VOLATILE… Consider the following function: CREATE OR […]
How to properly debug and inspect SQL Queries in PHP File?
Question : My website AdminPanel has a PHP file which takes almost 30-40 seconds in loading. I doubt the queries […]
Centralized Logs (error, deadlocks, slow queries) For SQL Servers
Question : I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk […]
Postgresql log rotation
Question : In postgresql, I’m using the following configuration to maintain my weekly logs: log_truncate_on_rotation = on log_rotation_age = 1d […]
DB2 ARCHIVE mode – Can all archive logs be deleted after doing the FULL OFFLINE backup?
Question : I am interested in one thing, if I understood correctly. DB2 is in Archive mode (online backups are […]
Unable to show binary logs how to remove logs from mysql?
Question : Server version: 5.1.50-log MySQL Community Server (GPL) Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the […]
How to list all past remote login information
Question : Instead of using “Remote Desktop” for connecting to SQL Server, I and my co-workers are using SQL Server […]
If archiving is disabled and the last redo log file is full, why LGWR continues by overwriting the first available active file, not inactive file?
Question : I found the following sentence from Oracle documentation. If archiving is disabled (the database is in NOARCHIVELOG mode), […]