Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [log]

161 questions
22
votes
3 answers

How to Log All mysql queries into log file?

I am using Mysql 5.6.12 under Wamp server environment. Now I want to log All queries into ".log" file, the queries which are running by PHP or from PHPMyAdmin, I want to log them...
Qazi
  • 323
  • 1
  • 2
  • 8
20
votes
8 answers

Error Log Location?

Does MySQL write any log file? If yes, what is the path of it (on ubuntu/Linux)?
Maulik Patel
  • 313
  • 1
  • 2
  • 7
15
votes
6 answers

Disable Binary Logs in MySQL 8.0

How can I disable binary logging on MySQL 8.0? I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in the my.cnf and restarted the database. But with…
IGGt
  • 2,266
  • 6
  • 35
  • 49
14
votes
2 answers

How to log custom messages from inside a PostgreSQL transaction?

I have a software that generates transactions and executes them. I would like to asynchronously inspect about the transaction progress in term of the simple proportion of queries executed over total number of queries. I'm able to read both stdout…
pietrop
  • 756
  • 1
  • 7
  • 16
13
votes
2 answers

Logging to a file in PostgreSQL windows service

I need an alternative for running the following command: C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start. This way the server starts and logs to C:\yyy\log\pgsql.log. When I try to register the server as a service…
Vic
  • 449
  • 2
  • 7
  • 13
11
votes
1 answer

Is it possible to exclude specific users in log activity of PostgreSQL?

I need to monitor the activity of users in our databases. I have set the following parameters in postgresql.conf: log_min_duration_statement = 0 log_connections = on log_disconnections = on log_line_prefix = '%t %a %d %h %u |' However, I realize…
Sébastien Clément
  • 1,825
  • 3
  • 19
  • 28
11
votes
1 answer

"truncate log on checkpoint" option in SQL Server

Long story but our long term consultants (former employees) wrote a custom script years back (2006 or so) to interface with Tivoli Storage Manager and it appears to be checking for a SQL Server DB option named truncate log on checkpoint. Their claim…
user3885315
  • 113
  • 1
  • 1
  • 6
11
votes
5 answers

Which major database platforms support TTL?

I need to store some data in a database that will be hosted on Amazon Web Services, and I have complete freedom over choosing which database platform to install, based on what I think will best suit the particular application. One thing to note,…
soapergem
  • 211
  • 1
  • 2
  • 5
10
votes
2 answers

My disk is full of binlog files

I just realized that my server is growing by 2 GB per day, which is not normal. I looked at my folder and the folder / var / lib / mysql reached 26 GB Normally it should be about 4 GB A month ago I migrated my MySQL 5.7 database to MySQL 8.0 I think…
ML61
  • 113
  • 2
  • 2
  • 7
9
votes
2 answers

What is default MySQL binlog retention in AWS RDS?

I tried to retrieve my MySQL RDS binlogs in order to run manual "rollback" for some SQLs. Unfortunately, I noticed that only 2 binlogs for the last 30 minutes are available. "call mysql.rds_show_configuration" provides "binlog retention hours |…
Vitaly Karasik DevOps
  • 623
  • 2
  • 6
  • 14
9
votes
2 answers

SQL Server distribution database log file grows uncontrollably after full database backup

We have a merge replication environment that is pushing to 8 subscribers. This is working fine. Our distribution database is setup in Simple recovery mode. We have a maintenance plan that will backup all database every day at 00:30. Once this…
Koenyn
  • 191
  • 1
  • 2
8
votes
2 answers

PostgreSQL checkpoint log explained

I know what PostgreSQL checkpoint is and when it is happening. I need some additional information about the logs produced by the log_checkpoints = on parameter, so please explain some points of it to me: 2017-09-09 16:31:37 EEST [6428-6524] LOG: …
inivanoff1
  • 183
  • 1
  • 1
  • 3
8
votes
2 answers

PostgreSQL doesn't log

I'm using ArchLinux and PostgreSQL 9.4.4 and have enabled the logging in the config file: $ sudo egrep -v "^[[:blank:]]*($|#|//|/\*| \*|\*/)" /var/lib/postgres/data/postgresql.conf max_connections = 1024 # (change requires…
Kokizzu
  • 1,403
  • 6
  • 18
  • 35
7
votes
3 answers

How to log DML statements executed by a pl/pgsql function?

I have a pl/pgsql function (see below) that lists some fields and clears their contents using dynamically constructed UPDATE commands. When I set log_statement = 'mod', I can see nothing on the log upon execution of the function with SELECT…
Sébastien Clément
  • 1,825
  • 3
  • 19
  • 28
7
votes
1 answer

What is log sequence number ? How it is used in MySQL?

Can anybody give an example or scenario of log sequence number(LSN) used in MySQL
Siva
  • 173
  • 1
  • 1
  • 4
1
2 3
…
10 11