The log tag has no wiki summary.
0
votes
1answer
47 views
MySQL General log not working on Mac OS X
I want to log all queries to the database running on my MacBook Pro (Mac OS X 10.8.1). I created a file /etc/my.cnf with the following content:
[mysqld]
general_log=1
...
7
votes
1answer
224 views
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 ...
0
votes
1answer
117 views
How to Log IP Address for Inbound Connections in MySQL
Is there a way in MySQL 5.5 (on Redhat 6.x) to log the IP address from where a particular query has been run? And have that appear in the general log or even relay and bin logs? I am trying to track ...
2
votes
1answer
113 views
SET extra_float_digits = 3
I'm using postgresql 9.2 with my web application that has three servlet with three select.
I turn on the log.
When i send my first query: 'select * from "Nomi" limit 4'
before this the log show me ...
3
votes
1answer
176 views
Normalized Table Structure for Logging
How can I normalize a table that has four columns for logging the latest activity for a single record:
Created On
Created By
Modified On
Modified By
We have dozens of tables, all with these 4 ...
2
votes
1answer
116 views
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. ...
2
votes
1answer
62 views
Audit tables in different databases
I am studying ways to implement audit tables to my PostgreSQL database and would like to know if it is possible to make a trigger for the data to be written to a table in a database other than the ...
1
vote
0answers
121 views
MySQL: Writing log entries from stored procedure
Is there a standard way to write log messages in MySQL stored procedures?
I can write log messages to a designated log table, but I prefer the standard log mechanism where each message is coupled ...
2
votes
2answers
586 views
MySQL “Statement may not be safe to log in statement format” warning
What is the meaning of the following MySQL warning:
Statement may not be safe to log in statement format.
I have some tens of thousands of these statements every day in my mysqld.err file, and I'm ...
