Questions tagged [configuration]
The choice of settings for hardware, firmware, software or other components of a database system.
713 questions
0
votes
0
answers
38
views
Is it possible to change the ERRORLOG files encoding in SQL Server 2019?
We have a security vendor in our company that needs to access the ERRORLOG files in some SQL Server 2019 instances. They say the encoding on our files is unusual [UTF-16 LE BOM] as the standard is [...
- 11
0
votes
1
answer
93
views
Why does old postgresql.conf affect new PostgreSQL version? [closed]
I'm a beginner in administering databases. I use Linux Mint. A couple of weeks ago I decided to start learning PostgreSQL.
I installed PostgreSQL 12, from Mint's repository. After some time I ...
- 1
0
votes
0
answers
22
views
What System Configuration and postgres Configuration Is Needed to Handle 5000 pgRouting Requests at the same time?
`I’m working on a project where we need to process 5000 concurrent pgRouting requests involving PostgreSQL with the pgRouting extension. The requests will mainly involve route planning and shortest ...
0
votes
0
answers
10
views
mariadb .my.cnf, Multiple host, user, pass, db entries support
Exactly same ask as here,
At the moment one can only put a single host, user, pass, db entry in .my.cnf file.
Has such limitation been removed and now support multiple entries yet?
Note,
This is a ...
- 143
1
vote
1
answer
202
views
Query has been cancelled because the estimated cost of this query exceeds the configured threshold
Whenever I run this query:
SELECT trade_detail_id,trade_side_id,id,is_last,is_xml_detail_filled,save_date_time,trade_id,trade_ligne_id,type,xml_detailled_info,xml_state
FROM some_table
WHERE (NOT (...
- 9,682
0
votes
1
answer
37
views
Which file specify Oracle's DB full version (major and minor)? Oracle 19 and up
In some monitoring service I have, I need to detect Oracle DB upgrades/patches, and for that, I want to sample the Database version.
I am aware that creating a connection and running the query select *...
- 113
0
votes
0
answers
30
views
Can I change collation_connection permanently? Having issues running queries in Navicat on a remote MariaDB server
I try to have everything utf8 with utf8mb4_unicode_ci collation. As far as I can see, everything is.
But occasionally in Navicat, I get an error message about an illegal mix of collations - that and ...
- 265
0
votes
0
answers
12
views
Can I merge settings.json files in Azure Data Studio
I want to make a few changes to by settings.json file and use these changes on another installation.
Is there a way of merging a simplified version of settings.json (with only some changes) on another ...
- 2,919
-2
votes
1
answer
22
views
Online docs has incorrect JVM flag unsafe_aggressive_sstable_expiration for TimeWindowCompactionStrategy
I was installing the unsafe_aggressive_sstable_expiration and found out that there is a mistake in the documentation. The documentation told us that we needed to enable in the jvm -Dcassandra....
0
votes
1
answer
42
views
Unsafe_aggressive_sstable_expiration - Procedure to enable unsafe_aggressive_sstable_expiration
I am planning to enable this tag to solve an issue related to some SSTables that are fully expired and are blocking some other expired SSTables from being expired. I have looked for information on ...
0
votes
2
answers
100
views
Making mysql write more to ram and less to SSD
What are some tunning options that could make MySQL (8.0.36) write more to ram memory and less to SSD ? To have less SSD wear not to optimize performance.
Do these two affect amount of bytes written ...
- 204
2
votes
2
answers
107
views
getting the memory settings for all instances in a server
I have a query that shows me all the sql server instances in a server:
DECLARE @GetInstances TABLE
( Value nvarchar(100),
InstanceNames nvarchar(100),
Data nvarchar(100))
Insert into @GetInstances
...
- 16.6k
3
votes
1
answer
402
views
Is sys.dm_os_memory_clerks a good source to use when setting max server memory (MB)?
According to sys.dm_os_memory_clerks, the total RAM usage of my server was 30 GB. Using this information, I set max server memory (MB) to 31,000. I was shocked to then see sys.dm_os_memory_clerks ...
- 823
0
votes
0
answers
27
views
How to enable keyring_file on replication server MySQL?
I recently activated the keyring_file plugin on my master server (5.7.44-enterprise-commercial-advanced-log), so the replication server presented errors when trying to execute alter table xxxxxx ...
1
vote
0
answers
50
views
Using impersonation from External Script?
We're on SQL Server 2022, and want to use Impersonation when accessing another (remote) SQL Server from our Python code (our external script).
I.e., the security credentials on the remote SQL Server ...
- 17.9k
0
votes
0
answers
88
views
Backup Directory Path Ola Maintenance Script: platform agnostic path on Windows q:/backup/folder
We are using configuration management, specifically Chef, to install SQL server on many new VMs. Part of the cookbook specifies the default SQL directories including the backup directory. In order to ...
0
votes
1
answer
111
views
SQL and Management Nodes on same server in NDB cluster. SQL Nodes not connecting
I've setup a ndb cluster with 7 nodes. 3 data nodes on their own servers, and 2 management nodes that each have a sql node on them on 2 servers.
I've narrowed down what I think my issue is. My cluster ...
0
votes
1
answer
105
views
Mongod starting issue on ubuntu
When I try to check the status of mongodb I get the following:
× mongod.service - MongoDB Database Server
Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor preset: enabled)
...
0
votes
1
answer
60
views
Problem with saving data SQL
For some time now I have had a problem with saving data in the database.
The problem is that after a sudden shutdown of the server, the data that was sent a minute earlier from the application was not ...
- 1
0
votes
0
answers
72
views
MySQL 5.7 on Amazon Aurora - how to read the IO Cache vs. Disk Read metric?
I'm trying to determine how often InnoDB is hitting RAM vs. disk.
Does db.Cache.innoDB_buffer_pool_hits.avg mean InnoDB went to the buffer pool?
Does db.Cache.Innodb_buffer_pool_reads.avg mean that ...
- 143
0
votes
0
answers
96
views
Why does a DPM protection group configured for Sync work for some databases in simple recovery model but not others?
I'm using System Center Data Protection Manager 10.22.197.0 to back up SQL Server 2022 CU 10 on Windows Server 2022. DPM agent is also 10.22.197.0 on these SQL servers.
The SQL Server instance was ...
- 203
0
votes
1
answer
84
views
why there are differences between sql server max memory and the actual utilization?
I have just asked infrastructure to add memory to a sql server box, the total memory now is 16Gb
I have set the maximum memory in sql server to 12GB.
when I run the memory query below:
SELECT [...
- 16.6k
0
votes
1
answer
286
views
Best practices when customizing PostgreSQL configuration files
I am customizing my configuration files, both pg_hba.conf to allow LAN clients to access the DB on the machine and postgresql.conf to tweak my DB engine.
By now I am just editing the files I've seen ...
- 101
0
votes
1
answer
415
views
In an Always On configuration, why do I have to open ports of the listener as well for the sql server engine itself for the listener ips?
We use an SQL Server 2019 Always On setup.
2 sql server 2019 nodes in same subnet : server01, server02
1 sql server 2019 node in other subnet : server03
We decided to create only 1 availability group ...
- 1
2
votes
0
answers
146
views
What’s the penalty if I enable `track_commit_timestamp`?
I just learned about PostgreSQL’s xmin system column, pg_xact_commit_timestamp(xid) function and track_commit_timestamp option.
I’m considering enabling this option on my PostgreSQL databases, as a ...
- 213
0
votes
1
answer
43
views
SSRS with remote ReportServer db - where to focus cpus/memory for processing
On an SSRS instance with a remote ReportServer db, where is the processing done? Should the SSRS instance vm get additional cpus and memory or the sql instance where the ReportServer db is? The ...
- 83
1
vote
1
answer
327
views
macos ventura postgres 15 remote connections server closed the connection unexpectedly
macos ventura 13.5.1 postgresql (15.4 (Homebrew))
Remote connections for the server are closed "unexpectedly". I have done all the steps that are needed for postgres to be happy with remote ...
- 13
0
votes
0
answers
79
views
How to check Default Isolation Level at server/instance level
We have installed SQL Server 2017 in 2 servers. Then created 2 databases same way in both servers. In one server I see my database snapshot isolation level is ON and another server its OFF.
So, how ...
0
votes
1
answer
250
views
Manage PostgreSQL client backend
To get currently runnig processes, I run these queries :
I have some questions about outputs:
What is client backend? Why there are a lot of client backend? What does it mean?
How to manage client ...
- 35
1
vote
1
answer
2k
views
Configuration of max_worker_processes in PostgreSQL
We are going to run Hot-Standby Replication for our environment.
In this YouTube link at 24:54, it was mentioned that, to run READ-ONLY queries in Hot-Standby we must increase max_worker_processes ...
- 35
0
votes
1
answer
141
views
How to enhance (the speed of) my database
First of all, I need to say that I have not much formal training for SQL, especially the backend, so anything I tested was a trial and error of advice found on the internet.
I have a DB which stores ...
- 23
0
votes
1
answer
209
views
How much memory using for adaptive hash indexes in MariaDB?
I'm reading about adaptive hash indexes in MariaDB. It is created in memory, so it will be logically to know how much memory usually used for the index table.
For example, my local development ...
- 111
-3
votes
1
answer
50
views
Good training on shrinking / growing files on SQL Server
I am looking for basic file shrinking / growing training for SQL Server. I see a number of similar questions as I post this - will read those answers now
- 11
1
vote
0
answers
198
views
Cannot change logging settings per-user in Postgresql
I have a special database role that only handles passwords, and I want to exclude it from database logs, but include logs from all other users.
In my postgresql.conf file I have these custom settings:
...
1
vote
2
answers
1k
views
Why is the "startup" configuration different with SQL Server 2022
From the Microsoft web page:
SQL Server services are set to Automatic (Delayed Start) start mode
In SQL Server 2022 (16.x), setting the Start Mode for a SQL Server service to Automatic in ...
- 3,257
0
votes
1
answer
2k
views
How to change query tool font and colors in PgAdmin 4?
In PgAdmin III, it is possible to change the font and colors for the query tool editor window in the options menu:
I can't find any similar settings in the preferences window for PgAdmin 4. How and ...
- 121
1
vote
1
answer
125
views
Which SQL Server database settings fall under ALTER DATABASE SCOPED CONFIGURATION vs ALTER DATABASE SET syntax?
I have noticed that there are two command syntaxes to change database configuration settings in SQL Server - ALTER DATABASE SCOPED CONFIGURATION and ALTER DATABASE SET. However, I am unclear on which ...
- 1,219
0
votes
2
answers
71
views
Setting parameter of other connection
I can set log_statement parameter to 'all' on the current connection. I want to do it for a few other connections on my database that are controlled by a connected web application. I know that I can ...
- 101
0
votes
1
answer
54
views
What is the suggested value for guardrail fields_per_udt_warn_threshold?
Cassandra has added guardrails feature some time ago, bust none of the guardrails have any default value set in the configuration file (see cassandra.yaml). I generally wonder how can a db admin know ...
- 103
-1
votes
1
answer
493
views
how to get database settings such as LEGACY_CARDINALITY_ESTIMATION and INTERLEAVED_EXECUTION_TVF
I am moving some database finally to compatibility level 150 using the script below
USE [master]
GO
ALTER DATABASE [DB1] SET COMPATIBILITY_LEVEL = 150
GO
USE [...
- 16.6k
0
votes
3
answers
338
views
How to detect pending settings on db2set, dbm and db cfg level?
On Db2 v11.5.8.0 on Linux x86_64 I have several instances and databases.
I would like to find out if there is some pending setting on:
db2set variables
dbm cfg
dg cfg
level?
Questions:
Is there a ...
- 401
2
votes
2
answers
604
views
Registration of SPNs for Availability Groups
Manually registering SPNs for Availability group -
Do I need to register SPNs for the AG Listener as well as the individual nodes, for both the instance name and the listening ports for the managed ...
- 377
0
votes
1
answer
120
views
postgresl.conf vs conf.d/*: which has greater precedence
If the same parameter it's set on ./postgresql.conf and on ./conf.d/something.conf which one has preference or which one overwrites the other one?
- 297
0
votes
1
answer
522
views
Does it make sense to enlarge "shared_buffers" for writing Postgresql?
I'm using Postgresql-11, with a traditional HDD as the physical storing device.
I need to optimize the performance for writing.
I have changed the wal_buffers from -1 to 512MB, that means that ...
- 359
0
votes
1
answer
401
views
Where is Oracle TNS redirection configured?
The short version,
I need to connect to an Oracle server and I am getting redirected to an IP address that is blocked by the firewall. What do I need to ask to find out what IP addresses I will be ...
- 115
0
votes
0
answers
184
views
How can i configure server in firebird.conf?
I want to connect an FDB database. However, no permission for all paths for this. And my FDB files are not in a path with permission. That's why I wanna make some changes in firebird.conf for server ...
- 35
2
votes
0
answers
122
views
Set custom postgresql.conf for one database on Mac using Postgres.app
I have ~20 PostgreSQL 14 databases on my local development machine running on Postgres.app.
I am trying to pg_restore a single 100GB database to Amazon RDS, but I'm getting some inconsistencies with ...
- 121
0
votes
1
answer
123
views
Is replication on by default on MySQL 8.0.30 ? How to stop it?
I am running MySQL 8.0.30 on Rocky Linux 9.
While importing some ~100GB sql files, I noticed the /var/lib/mysql is filled with binlog.000123 files, over 100GB.
I assume these are created because ...
- 204
0
votes
1
answer
845
views
Catalog cache too small - any method to determinate size?
On Db2/Linux_x86_64 in db2diag.log I constantly see warning about CATALOGCACHE_SZ parameter to be too small like:
2022-12-02-14.40.53.536711+060 E5979903E769 LEVEL: Warning
PID : 4508 ...
- 401
2
votes
1
answer
295
views
MySQL 8 replication: is it possible to specify master side a specific port for replication, and only replication (different than the default 3306)
Master side.
In MySQL 8 for the replication, is it possible to specify master side a specific port for replication, and only replication that is different than the default 3306 where regular clients ...
- 513