Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [logs]

A sequential journal of database write operations that facilitates robust atomic write operations.

0
votes
0answers
18 views

How to change the expiration date of binlog files?

I have a server with Ubuntu 18.04 and MySQL 8.0.11 I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate. How to change the expiration date of binlog files ? ...
5
votes
2answers
483 views

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

If I size my log files to evenly split the entire drive they reside on, leaving no extra space available, will log backups still be able to occur successfully? I have several databases, with one log ...
-2
votes
1answer
58 views

Centralized Logs (error, deadlocks, slow queries) For SQL Servers

I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk stack. What is the best and performant way to send these kind of logs to a log collector? I ...
0
votes
0answers
22 views

Log file is growing up and is not releasing space [duplicate]

The database is under Full Recovery Method, the DBCC SQLPERF (LOGSPACE) shows 3 % used. Even after I take Log back ups frequently it is not releasing space. There is no active transaction and ...
0
votes
1answer
465 views

How to log ALL queries made by users in SQL Server 2017 Standard? [duplicate]

Is there a possibility to do this? All queries and actions performed in any database need to be logged, because of in house compliance. I need information (and/or source) if we need MS SQL 2017 ...
1
vote
1answer
143 views

Replay (re-execute) MySQL SELECT queries from a log file

MySQL Benchmarking I would like to evaluate the performance of a different MySQL instance by re-executing real queries from log files. I am aware of tools like mysqlslap, that produces random and ...
1
vote
1answer
128 views

SQL Server logs “blob data”, viewable with journalctl

What does it mean when I run journalctl -u mssql-server.service and it says B blob data, Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine... Sep 06 17:34:44 x230 ...
1
vote
1answer
38 views

Postgres logging_collector probably blocks auto_explain output

Postgres 10.4 Postgres 9.6 Problem on both versions I want to collect postgresql slow queries plan, so I added to my postgresql.conf setting from documentation session_preload_libraries = '...
2
votes
1answer
104 views

How to read mysqld.log files? [closed]

can someone tell me how to read the mysqld.log? I'm curious about the third column. Because every time i start/stop the mysql it give different output. I hope someone can explain to me :). Below is ...
1
vote
2answers
65 views

Why do uncommitted transactions rollback instead of redo after a crash in ARIES?

Since all actions within a transaction are idempotent in crash recovery algorithms like ARIES that use write-ahead logging why do we rollback after a crash during an uncommitted transaction to get ...
0
votes
3answers
68 views

Restore deleted data from a Table which occurred daily

I am not sure whether this is restore data scenario is possible. Scenario: I have a table with few 100 data inserts every day.I didn't realize that because of some reason(identified later as a bug in ...
0
votes
0answers
50 views

Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]

please can anyone help? I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile. I want to change this setup as per best practices by adding 3 additional euqally ...
0
votes
0answers
194 views

MariaDB : Unable to lock ./ibdata1, error: 11

I'm using mariadb 10.1.26. I have added disk space and RAM to my server. When I tried to start the SQL service it is starting, but the error log shows the below error. InnoDB: Can't open './ibdata1'...
1
vote
1answer
125 views

How do I determine the time period to which the SQL Server i/o warning is referring?

SQL Server log shows batches of warnings, of the type: SQL Server has encountered 18757 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\.. SQL Server has ...
0
votes
2answers
2k views

Starting mongod daemon with a config file for a shard

In a Linux machine, I changed the mongod.service file to run a config file I created. ExecStart=/usr/bin/mongod --config /etc/some_name.conf When I start mongod with this config file manually, it ...
1
vote
0answers
325 views

SQL Server Login auditing capturing Logon events when set to Failed logins only

I have an issue where within my SQL Server 2016 Standard instance, Login auditing is set to Failed logins only but within the ERRORLOG file, it is capturing Both failed and succesful logins. Once I ...
3
votes
1answer
42 views

Auditing Failed Logins in SQL Server

Are there ways to understand which password entered when connecting to my server ?
1
vote
1answer
33 views

Log table that grows like flash [closed]

I have my own app that get low traffic (like 100 ppl per day). As part of my research I am 'logging' all the queries done to by the server in a table in the database. An example, if user enters home ...
0
votes
0answers
134 views

The log group capacity

I stumbled across the following lines in mysql error log: 180220 2:14:33 InnoDB: ERROR: the age of the last checkpoint is 990314889, InnoDB: which exceeds the log group capacity 966363956. InnoDB: ...
0
votes
0answers
22 views

Availability of database log-dumps for research purposes

I am looking for dumps of the logs of either key-value stores or relational databases for research purposes. Ideally, I am looking for a time-ordered (not necessarily timestamped) dump of the client ...
1
vote
1answer
72 views

Exclude application from postgres logs

Currently on one of our dev servers we log everything what happend in database, but lots of traffic in is generated by patroni cluster and is not needed in further investigation. Is possibile to ...
1
vote
2answers
155 views

Is there a way to limit log file usage for a transaction in SQL Server?

This question is a follow up on these two: Auto rollback Explicit transactions after X amount of time Database file …_log has a max file size set to x MB. If it runs out of space, the database will ...
1
vote
1answer
323 views

Change logging level programmatically for multiple jobs

I have multiple Sql Agent jobs, with multiple steps each. For a large subset of these jobs, I want to set the logging levels to PERFORMANCE instead of BASIC - the logs are taking a lot of log space, ...
0
votes
1answer
153 views

ODBC SQL tracer file question marks

I have an MS Access query that connects to an Oracle Express database via an ODBC connection. I've figured out a way to trace the SQL that is sent from MS Access to the ODBC connection. This is what ...
1
vote
1answer
49 views

Will logRotate cause any unavailability in MongoDB service?

In another question, I've mentioned that how would I rotate logs in MongoDB Replica Set installed in Windows Server. However, it seems there's no built-in way to get it automatically on Windows - only ...
0
votes
1answer
336 views

Get postgresql exact log file name with sql

I get current log file by using SQL without getting in server via ssh. So I use a query like the one below; SELECT pg_read_binary_file( concat_ws('/', current_setting('log_directory'), '...
0
votes
1answer
64 views

How to properly debug and inspect SQL Queries in PHP File?

My website AdminPanel has a PHP file which takes almost 30-40 seconds in loading. I doubt the queries which are making the mess, but may be it is the code but the code structure seems perfect. I want ...
1
vote
1answer
242 views

Another “log_min_duration_statement is ignored” question

Following the recommendations in log_min_duration_statement setting is ignored I set these two values and then reloaded. log_min_duration_statement = 2000 log_statement = 'none' However, I'm still ...
1
vote
2answers
549 views

MySQL Still purging binary logs and ignoring expire_logs_days

We are running mysql v5.6.17 and I cannot find if there is something else that is causing the binary logs to be purged other than the following: Adding expire_logs_days to the my.ini (and ...
3
votes
1answer
2k views

MySQL audit and general log

May ask for the difference of MySQL Audit log plugin and general log? I looking for any activities done in a MySQL server.
1
vote
1answer
578 views

Log (ldf) file grows continuously

We have a problem with just one of the databases on our SQL2008 Server. For some reason recently the log file is just growing and growing. The server runs the following backups Weekly - Full Daily - ...
2
votes
1answer
162 views

What are the three parts of a LSN?

I am curious about what the 3 parts of a Log Sequence Number (LSN) are and how they are generated. A log sequence number is an ever-increasing, three-part number that uniquely defines the position ...
5
votes
1answer
1k views

Why do I have to backup a transaction log twice for it to shrink?

This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file - that is not the question. If you feel like answering that one should not do ...
4
votes
2answers
1k views

SQL Server : log folder too large

Please note that I'm not talking about transaction logs. I'm referring to a folder within SQL Server called 'Log' where ErrorLog and SQLDrmp files exists. Well, the fact is that this folder is ...
1
vote
1answer
109 views

How to shrink over sized logs in Database Mirroring? [duplicate]

I've searched the forums here at dba.se and other places on the Net and haven't found a specific answer. I know this question looks similar to many, but the ones that I've found only address how to ...
0
votes
1answer
127 views

Huge ASPState database log

We're using SqlServer to store users session state of our webapps. We've recently noticed the ASPState.log_ldf file has reached 50GB. Is it safe to put the web apps down and then drop and recreate ...
5
votes
2answers
4k views

Transaction Log Files Larger Than Data Files [duplicate]

I'm an accidental DBA and need help determining a course of action regarding transaction log files on several databases. I ran Brent Ozar's sp_blitz to see what areas of concern there might be on an ...
1
vote
1answer
75 views

Which database type for log analysis?

I am running a database for log analysis. At the moment I use a MySQL database and the table for my analysis looks like this: UUID REQUEST_ID REQUEST_TIMESTAMP RESPONSE_TIMESTAMP RUNTIME SERVER_NAME ...
0
votes
1answer
509 views

SQL Server Log Shipping Alert Job Issue

We have log shipping taking place between server A and server B. The logs are backed up every 15 minutes on server A. Over on server B, the logs are copied every 15 minutes successfully. The logs are ...
0
votes
1answer
324 views

Sybase ASE server request logs

Is it possible to log each SQL query statement received from clients for a Sybase ASE server 15.7 , same as SET general_log = 1; command for mysql. Thanks
1
vote
1answer
138 views

Is it possible to replicate data changes of a database with triggers using binary logs?

I'm tasked to minimize the downtime of the database update. Unfortunately, I cannot use pt-online-schema-change toolkit because some tables in the current database has MySQL triggers that does further ...
0
votes
0answers
57 views

What index type to use for a log

I have a table in which I will store messages (as in chat messages). The table will be appended to a LOT, rows being inserted as messages fly by, much more often than entries will be updated. Older ...
1
vote
1answer
653 views

SQl Server: Corrupt Logs Files: Why?

I have a SQL Server 2008r2 database server running on Windows Server 2008. On this server every week the log of at least one database throws this error: Backup detected log corruption in database ...
3
votes
0answers
312 views

Amount by which to increase checkpoint_segments (postgresql)

In my postgresql log, I see statements such as checkpoints are occurring too frequently (26 seconds apart). Currently in the conf, checkpoint_segments are 32, checkpoint_timeout is 15 mins and ...
0
votes
1answer
141 views

controlling postgresql log generation

My disk space fills up daily with postgresql logs. One optimzation solution I'm pursuing is that instead of turning off logs, I should overwrite the original log file (i.e. rotate?) once it hits a ...
1
vote
1answer
227 views

Logging procedure, package errors to OS's Syslog

Good day, Setup: Oracle 11G on Solaris 10 x86 We'd like to capture the errors/failures of our nightly scheduled procedures/ packages in the OS's syslog. That log will then be sent to a remote NMS ...
2
votes
1answer
295 views

What do the values after `execute fetch from` mean in postgresql query logs?

We've turned on some slow query logging on a postgres 9.1 cluster and see the following in the logs:: 2016-08-08 13:05:51 AEST LOG: duration: 24126.105 ms execute fetch from S_26/C_775: SELECT ...(...
3
votes
2answers
648 views

Logging all changes made to MySQL database

I have a web application setup where there are separate Apache-Wordpress containers for development and production. Database is hosted externally on a virtual host. When setting up development ...
0
votes
1answer
152 views

postgresql reindex frequency and monitoring

What's up guys. I have a couple of tables where i inserting much of data (and almost never deleting). Periodically i see that insert gains ExclusiveLock on index of table. So i guess that sometimes ...
1
vote
1answer
655 views

Postgresql log rotation

In postgresql, I'm using the following configuration to maintain my weekly logs: log_truncate_on_rotation = on log_rotation_age = 1d log_filename = 'postgresql-%a.log' log_rotation_size = 0 #just ...