Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
249
questions
1
vote
2
answers
4k
views
MySQL (on Windows) general log too large to rotate properly?
First off, I'm not sure if this should go to Server Fault or Database Administrators. It could be a Windows Server 2008R2 problem. But I am asking here first in the chance that someone else running ...
- 123
23
votes
1
answer
24k
views
log_min_duration_statement setting is ignored
I am running Postgresql 9.1 on Ubuntu. Exact Postgresql version is 9.1+129ubuntu1 as my package manager shows.
I have 2 databases that are actively in use and they are used from a remote server.
I ...
- 459
3
votes
1
answer
4k
views
Logging Postgres startup errors on Windows
I have been experimenting with Postgres configuration parameters and noticed that when I use settings that prevent Postgres from starting nothing shows up in the pg_log directory logs. I have
...
- 143
1
vote
1
answer
1k
views
Issues with mysqldump after upgrade 5.5 -> 5.6
A few months ago I updated a MySQL setup from 5.5 to 5.6. Since then I've been having problems with a script that I use to dump the various databases so that I can back them up.
The script is a short ...
- 135
1
vote
1
answer
2k
views
DB2 - Archive Mode - on what values to set LOGPRIMARY,LOGSECOND,LOGFILSIZ?
we must set our database from CIRCULAR to ARCHIVE mode in order to enable ONLINE backups.
Backups will be done every 1 day.
Database is now almost 30GB.
Database grows approximately 1GB per month.
...
- 685
8
votes
1
answer
32k
views
MySQL Error: impossible to write to binary log
I have a system (inherited from another development company) and I don't know all its features yet.
Construction:
- web client/application (symfony 1.4)
- DB - MySQL.
Project is deployed on 2 servers:...
- 203
-1
votes
2
answers
9k
views
Write filename, servername/IP and date+time in spool file
I'm having some problems to verify the installation/execution of some oracle scripts in different production servers. I've created a launcher script which executes all the sql scripts in sqlplus and ...
2
votes
2
answers
6k
views
Listener Log Oracle 11g R2
I'm using Oracle 11gR2 in RHEL5. Now a days my application, during run time, is showing exception as below.
Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate ...
- 201
0
votes
1
answer
2k
views
store log of update,insert operation of postgresql user
I have to create postgresql user in postgresql 9.0 and give grant on my database xxx and whose all log of insert and update operation should be stored in one external log file so that i can have all ...
- 11
0
votes
2
answers
1k
views
Lot of log files in $FSLOG generating. How to stop?
I'm using SQL Server 2012 Express Edition and I have a problem with huge amount of files generated in:
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\...
- 19
1
vote
3
answers
1k
views
How to make SQL Server Agent job history less verbose?
So, I've created a SQL Server Agent job, according to the answer to my prev question:
running nightly (at 2:11) according to the schedule:
There are 9 .bak files in 3 subdirectory of d:\backup\ ...
3
votes
3
answers
1k
views
Trace and analyze logs on SQL Server
I am using an SQL Server 2012 on windows datacenter 2012
I have encountered a situation where i think some virus/sql injection had heart my database,
Some data on my table had changed to weird link'...
- 287
0
votes
2
answers
571
views
MySQL row does not persist, but primary key with auto-increment is incremented
I have a MySQL database that is acting oddly. I insert a new row and observe that for a brief period of time (less than 30 seconds), the row persists as expected in the table. After this time, though, ...
3
votes
2
answers
7k
views
INT or TIMESTAMP for the change time column in a logging table?
We're having an argument over what to use for storing change date in a new log table for our site.
One side says, use INT for the timestamp, storing the UNIX timestamp. We can convert the datetime ...
- 642
9
votes
3
answers
24k
views
Transaction Log Maintanance While Using AlwaysOn Availability Group
We are using HADR ( AlwaysOn Availability Group) feature of SQL Server 2012.
Server and AG Configuration as below:
SQL12_SRV1
--> AG1(PRIMARY) - SYNC
-->> DBTest
SQL12_SRV2
--> AG1(SECONDARY)
...
0
votes
2
answers
377
views
MySQL Logging Options
I want to know what logging options are available to me in MySQL; I find a lot more results about binary logging than I do about general/error logging and I'm not sure what options are available to me ...
- 161
4
votes
2
answers
2k
views
Can stable (or immutable) functions call volatile functions?
The PostgreSQL documentation states:
Any function with side-effects must be labeled VOLATILE...
Consider the following function:
CREATE OR REPLACE FUNCTION count_items()
RETURNS integer AS
$...
- 833
0
votes
1
answer
22k
views
How to purge logs by using Flashback feature in Oracle Database
I’ve configured flash recovery area for Oracle Database. My question is: how can I delete Flashback Database log?or is there any retention policy for that?
2- After I’ve enabled archive log mode and ...
- 1,078
13
votes
3
answers
17k
views
How best to maintain SQL log file sizes
I'm somewhat of a new DBA and I'm managing a SQL Server 2012 instance that has a fair amount of activity. I'm running in Full Recovery mode because we need point in time recovery.
Right now, I'm ...
- 705
3
votes
1
answer
2k
views
How to turn off all RAISE NOTICE on production server?
I put a lot of RAISE NOTICE in functions for debugging purpose. I think this will affect performance, so they should be removed on production environment. Is there any way to opt-out those logging/...
- 447
2
votes
2
answers
7k
views
Stress test MySQL with queries captured with general log in MySQL
Is there any tool available which can do stress testing using the log file created by MySQL general log?
After a lot of search on google I found few stress testing tools which only use some benchmarks ...
- 241
3
votes
1
answer
7k
views
Create log file only for my executed queries
I have been using the following to set up the log file:
log_statement='all',
log_collector='on',
log_destination='on',
log_filename='filename'
After that, for testing I just executed a query then ...
- 183
0
votes
1
answer
4k
views
Logging and saving user activity
Database:Oracle 11gR2
OS: Windows 2008 Server R2
I'm not trained DBA, just have to run things on an Oracle database temporarily, which is used to perform OLAP processes.
I need to automatize user ...
- 340
1
vote
1
answer
4k
views
Is storing archive logs on local disk and backups on vendor storage possible?
I am using DB2 9.7.
My LOGARCHMETH1 is set to VENDOR library. Example:
LOGARCHMETH1=VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64
Is it possible to call the following backup command:
db2 backup ...
- 685
1
vote
3
answers
479
views
Anyone want to try a script bash or python?
I need to automate master binary log purging to occur so that purging never goes back further than the last slave has the updated info for.
These slaves are mobile and there are 3 of them, and sync ...
- 19
1
vote
1
answer
1k
views
How can I change SQL Agent Log file to use unicode format?
I've created a database with tables that heavily leverages nvarchar for most of the columns. One of the challenges I'm running into is that when I go to view the SQL Server Agent Log files, I get the ...
- 373
1
vote
1
answer
3k
views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
3
votes
2
answers
3k
views
Tracking changes to a table via the update/insert cmds executed against it daily
We have an oracle database back end for our SAP ECC system. In it we have a table with over a billion records. We would like extract this table to our SAP BW, which happens to be on MSSQL Server. ...
- 133
3
votes
1
answer
19k
views
Error 9001, Severity: 21, State: 1 The log for database 'DB_NAME' is not available [closed]
I have a SQL Server 2008 R2.
I got a mail that the backup had failed, I opened the SQL log viewer and started browsing.
And i found these two errors a bunch of times.
error 1:
Date 31-01-...
- 363
11
votes
1
answer
52k
views
mysql logging activity from specific user or ip
I have mysql server.
The server is accessed by my application, and by external auditor (person using mysql workbench).
The auditor has specific user and password and dedicated IP and it is granted ...
- 223
10
votes
2
answers
13k
views
MySQL binary logs - skip a table
Is there a way to skip a specific table in the binary logs?
I've got binary logs configured as my incremental backup strategy between nightly backups. But we have one huge reference table that we're ...
- 531
4
votes
2
answers
5k
views
Enable slow_query_log tries to write to slow_log.CSV
I'm running MySQL 5.5
I wanted to truncate the slow log file, so I did:
SET GLOBAL slow_query_log = 0;
then truncated the file in filesystem.
But, when I enable it back it fails:
SET GLOBAL ...
- 151
1
vote
2
answers
11k
views
Saving every mysql user login attempts
Is there a way to save the username and the IP from which the user tries to login to a MySQL server??
Enabling general-log seems to log everything but that seems to write too much details taking more ...
- 183
12
votes
1
answer
4k
views
Performance impact of setting PostgreSQL to log all statements
PostgreSQL 9.2.2 on Windows 7 64-bit.
The setting log_statement in the postgresql.conf file specifies what statements to log (none, DDL, data-modifying, or all). To what extent does setting ...
- 223
6
votes
1
answer
7k
views
MySQL Slave Relay Logging but not logging Binary Log
I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of ...
- 63
5
votes
2
answers
6k
views
Large files in wamp\bin\mysql\mysql5.5.24\data directory
I have discovered these files located in the wamp\bin\mysql\mysql5.5.24\data folder on my Windows 2008 server.
They are consuming about 22 GB on a 40 GB drive.
I am using a LMS called moodle, that ...
3
votes
2
answers
1k
views
Redirecting MySQL errors and slow logs into another database
I am running a number of MySQL servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into an external database.
...
- 741
21
votes
1
answer
56k
views
What exactly are iblog files in mysql
I would like to understand these ibdata files as these play vital role in the crash recovery procedure. I could not find proper resources over the web for this.
- 804
16
votes
3
answers
8k
views
Should a log table get an id field or primary key?
I have a log table that captures the datetime stamp of when certain files were exported to another system.
The exportedLog table currently has three fields:
id (primary key)
messageId ...
- 2,032
0
votes
1
answer
226
views
What is stored in mysqld-slow.log?
My MySQL log directory contains the following files:
7.9K mysqld.err-old
4.0G mysqld-slow.log
94 mysql.log
93M mysqld.err
mysqld-slow.log contains a long list of queries with some ...
- 11.5k
5
votes
2
answers
7k
views
Unable to disable SQL statement logging in PostgreSQL 9.1
I am running PostgreSQL 9.1 on Windows Server 2008 R2. I enabled SQL statement logging to the stderr log by modifying my postgresql.conf file, but now I can't seem to disable the logging without ...
- 51
1
vote
1
answer
639
views
What program to use for the best compression ratio for DB2 log files?
What linux program to use to compress DB2 log files with the best compression ratio?
UPDATE
I thought that these log files would be text type files. But viewing them didn't prove this. I tried to ...
- 143
6
votes
2
answers
590
views
SQL Server Transaction Log Initial Data Load
What is the standard process when initially populating a database with 5GB+ to avoid a large transaction log? From my understanding the log file would jump to a large size after the initial load and ...
- 283
3
votes
1
answer
282
views
MySQL - Partially restore binary log
I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500.
How can I do that?
- 135
1
vote
1
answer
7k
views
How to log logon logoff and user activity on mySQL server for audit?
My boss wants to have some kind of log on the server running mysql which would log user activity.
Kind of like:
User blah logged in
User blah ran some query
User blah logedd off
User asdf ...
- 13
1
vote
2
answers
2k
views
Warnings: Why are statements with limit clause unsafe even if there isn't a limit?
I'm a bit irritated because of some warnings in mysql errorlog.
Example 1:
[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
The statement ...
- 637
3
votes
1
answer
247
views
What is recommended level of security for a production database?
I have a production database on our local server. Currently there are two many logins to the database, about 20, half of them are windows authenticated and the other rest are SQL Server authenticated. ...
- 783
2
votes
2
answers
3k
views
What is running right now?
I know I can use "show processlist" to see what is running when I'm in the office. How can I see what is running when I'm not there.
Something is running on my server at 3am every morning that is ...
- 87
5
votes
2
answers
2k
views
Extract query fingerprints and tables from large log files using pt-query-digest
I tried to parse a large log file using pt-query-digest but it gives "Out of memory!" when I try to read the file. I have 3GB RAM, 40GB empty space on HDD, the file is 20GB. I did not found anything ...
- 231
10
votes
3
answers
20k
views
Write to Error Log
Using SQL Server 2008 R2:
How can I write to the SQL Server Error Log? I have a ROLLBACK statement that I'd like to couple with a statement written to the error log for external monitoring.
Example:...
- 603