Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
252 questions
0
votes
2
answers
136
views
How to avoid writing to the error log when changing instance configuration?
If you look at how to temporarily change the sql server settings in order to do a task and when finished revert back? there is a way to save SQL Server settings before enabling them, so you can ...
- 17.3k
0
votes
1
answer
189
views
MariaDB, where's the GLOBAL general_log file?
SHOW VARIABLES LIKE 'general_log%';
+------------------+------------------+
| Variable_name | Value |
+------------------+------------------+
| general_log | ON |
| ...
- 143
0
votes
1
answer
675
views
How to delete "SQL Server Agent" logs from "Log File Viewer"?
On "SQL Server 2019" on Windows 2019:
I have opened Microsoft SQL Server Management Studio.
I logged into database server.
I clicked on "SQL Server Agent" and clicked on "...
- 523
0
votes
0
answers
277
views
Analyze MariaDB error logs to get information what were happened on server
Can you help me understand what was happen on MariaDB server. I wasn't able to connect to this server because there was 'Too many connections'. This is one of our slave in replication so non of main ...
- 500
0
votes
1
answer
329
views
How is the current sequence number in the control file used during recovery?
During recovery, how is the current sequence number used to determine the redo log files used to re-construct the database as well as the order in which to apply the changes recorded in them?
- 131
0
votes
2
answers
1k
views
What's inside a redo record in Oracle's Redo log?
While reading the Redo log wiki page, I was confronted with the following statement:
For example, if a user UPDATEs a salary-value in a table containing employee-related data, the DBMS generates a ...
- 131
4
votes
1
answer
6k
views
MySQL 8.0.30+: redo_log_capacity vs log_file_size?
Cheers. We're trying to track down the cause of a significant increase in IO load after switching from MySQL 5.7 to 8.0.30, and one issue we've noticed is related to this part of documentation:
The ...
- 43
0
votes
1
answer
363
views
Cassandra has stopped producing log files
I've recently taken up the role of managing a Cassandra Cluster that has been running in production for a few years. This is my first time working with Cassandra so I would appreciate any insights.
It ...
3
votes
1
answer
502
views
PostgreSQL time series table with composite partitions
I am investigating how I might structure a PostgreSQL table to store a large amount of time stamped data that also needs to be portioned by another field.
My expected data structure will be something ...
- 45
3
votes
1
answer
1k
views
How to enable authentication logs in Firebird 2.5?
I downloaded Firebird 2.5 from the official website and installed on a Linux machine. The install location is /opt/firebird.
I want to be able to view authentication attempt logs for security reasons (...
0
votes
1
answer
535
views
Database alters MOUNT mode after reboot
We have Oracle XE 10.2.0.1.0 running on CentOS 6.9.
The Database works stable all the time, except the system reboots.
If reboot command is issued in the OS terminal, the Database enters MOUNT mode.
...
1
vote
0
answers
114
views
SSIS in Azure: operation_messages_scaleout event_messages_scaleout tables not populating
We are running SSIS packages in AZure. I am finding that for some reason we have stopped populating the SSISDB tables (operation_messages_scaleout, event_messages_scaleout). It does appear that the ...
- 11
0
votes
1
answer
333
views
How to log deadlocks for each database separately
I have MariaDB 10.6.5 server with several databases.
I added a line innodb_print_all_deadlocks = 1 to config file.
Now all deadlocks are logged to one file /var/log/mysql/mariadb.err
Is there any way ...
- 1
0
votes
1
answer
371
views
Do we need additional license to dump goldengate trail logs to kafka?
We have a Oracle (12c) GoldenGate license only (we do not have an oracle goldengate for big data).
We need to transfer the gg trail logs to kafka then to hdfs.
Do we need to buy the oracle goldengate ...
- 3
0
votes
0
answers
183
views
Log files are still created even when general_log is OFF - MySQL (MariaDB)
I have a MySQL server (10.4.21-MariaDB) installed by the XAMPP stack on ubuntu.
I notice in the mysql folder (/opt/lampp/var/mysql) several files:
ip-172-31-14-21.err
ip-172-31-14-21.log
ip-172-31-14-...
- 111