Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [log]

161 questions
20
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
  • 303
  • 1
  • 2
  • 8
19
votes
7 answers

Error Log Location?

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

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
  • 379
  • 2
  • 6
  • 12
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,501
  • 3
  • 14
  • 26
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
10
votes
5 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
  • 1,855
  • 3
  • 21
  • 39
8
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
  • 181
  • 1
  • 2
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,177
  • 4
  • 15
  • 28
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,501
  • 3
  • 14
  • 26
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
7
votes
2 answers

Why is my log file so massive? 22gb. I am running log backups

I can't seem to figure out the answer. I've seen multiple answers like this: Why Does the Transaction Log Keep Growing or Run Out of Space? and everyone talks about running back ups on your log file so it shrinks down. I am doing that, but it…
SventoryMang
  • 181
  • 1
  • 6
7
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
  • 656
  • 1
  • 5
  • 12
7
votes
2 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
  • 171
  • 1
  • 4
6
votes
2 answers

How to enable queries logs in MariaDB

I'm running mysql Ver 15.1 Distrib 5.5.46-MariaDB in CentOS 6.7 server. I'm trying to get queries logged and I'm doing by redirecting log to files as shown below: #/etc/my.cnf.d/server.cnf # this is only for the mysqld standalone…
ReynierPM
  • 1,690
  • 10
  • 29
  • 44
6
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 - Freelancer
  • 573
  • 2
  • 5
  • 11
1
2 3
…
10 11