Skip to main content

Questions tagged [configuration]

The choice of settings for hardware, firmware, software or other components of a database system.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 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 ...
Manngo's user avatar
  • 2,849
-2 votes
1 answer
11 views

Billing Model in PieCloudDB

I'm using PieCloudDB Cloud Edition right now, and I noticed that PieCloudDB supports pay-as-you-go billing model. I want to know if it supports other billing models. I want to measure the cost of ...
Shinichi Kudo's user avatar
-2 votes
0 answers
10 views

Wrong Documentation for Time Window CompactionStrategy | unsafe_aggressive_sstable_expiration

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....
Jon Corral's user avatar
0 votes
0 answers
18 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 ...
Jon Corral's user avatar
0 votes
2 answers
39 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 ...
adrianTNT's user avatar
  • 194
2 votes
2 answers
75 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 ...
Marcello Miorelli's user avatar
3 votes
1 answer
297 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 ...
J. Mini's user avatar
  • 555
0 votes
0 answers
21 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 ...
alexandredelcol's user avatar
1 vote
0 answers
36 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 ...
Tibor Karaszi's user avatar
0 votes
0 answers
57 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 ...
many questions few answers's user avatar
0 votes
1 answer
45 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 ...
Mr. Berzerk's user avatar
0 votes
1 answer
50 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) ...
Rime Tazi's user avatar
0 votes
1 answer
52 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 ...
DanPil's user avatar
  • 1
0 votes
0 answers
40 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 ...
mstrom's user avatar
  • 133
0 votes
0 answers
71 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 ...
M Herbener's user avatar
0 votes
1 answer
68 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 [...
Marcello Miorelli's user avatar
0 votes
1 answer
147 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 ...
Kodeeo's user avatar
  • 101
0 votes
1 answer
21 views

Network bottlenecks is concentrated on a specific host during query

I have deployed a CoC version of PieCloudDB in a private cloud environment. My S3 service consists of a cluster of three machines. During the deployment of PieCloudDB database, I specified one of the ...
Joe's user avatar
  • 5
0 votes
1 answer
193 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 ...
PekeDBA's user avatar
0 votes
0 answers
25 views

Ho to stop SSMS from reverting font settings

(Is this the correct forum for this question?) I teach Microsoft SQL for a training organisation. For teaching purposes, we’re using SQL Server Express and SSMS. I don’t like some of the defaults in ...
Manngo's user avatar
  • 2,849
2 votes
0 answers
96 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 ...
user2233709's user avatar
0 votes
1 answer
33 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 ...
Bobogator's user avatar
1 vote
0 answers
254 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 ...
boar's user avatar
  • 13
0 votes
0 answers
62 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 ...
Imran Qadir Baksh - Baloch's user avatar
0 votes
1 answer
177 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 ...
Mofarah's user avatar
  • 25
0 votes
1 answer
1k 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 ...
Mofarah's user avatar
  • 25
0 votes
1 answer
117 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 ...
herhor67's user avatar
0 votes
1 answer
174 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 ...
rzlvmp's user avatar
  • 111
-3 votes
1 answer
44 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
Debbie S's user avatar
0 votes
0 answers
137 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: ...
Primordial_Hamster's user avatar
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 ...
Dominique Boucher's user avatar
0 votes
1 answer
1k 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 ...
Joe M's user avatar
  • 121
0 votes
1 answer
93 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 ...
Fajela Tajkiya's user avatar
0 votes
2 answers
47 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 ...
Trismegistos's user avatar
0 votes
1 answer
47 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 ...
Piotr Smaroń's user avatar
-1 votes
1 answer
403 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 [...
Marcello Miorelli's user avatar
0 votes
3 answers
266 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 ...
folow's user avatar
  • 357
1 vote
2 answers
492 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 ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
92 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?
Héctor's user avatar
  • 297
0 votes
1 answer
388 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 ...
Leon's user avatar
  • 357
0 votes
1 answer
318 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 ...
user1683793's user avatar
0 votes
0 answers
141 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 ...
sunShine's user avatar
2 votes
0 answers
118 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 ...
sscirrus's user avatar
  • 121
0 votes
1 answer
104 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 ...
adrianTNT's user avatar
  • 194
0 votes
1 answer
689 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 ...
folow's user avatar
  • 357
2 votes
1 answer
239 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 ...
Déjà vu's user avatar
  • 483
16 votes
2 answers
3k views

Why is SQL Server setup recommending MAXDOP 8 here?

I'm running SQL Server 2022 RC1 setup on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether. Setup is recommending MAXDOP 8: But if you ...
Brent Ozar's user avatar
0 votes
1 answer
2k views

Setting custom MariaDB max_allowed_packet value in Debian 11?

[This is more of an OS config file question, but I have had no response on Unix.SE, so I am hoping that the 'join' of DB admins and sysadmins here may result in better luck…] Our Moodle server, ...
dave559's user avatar
  • 121
1 vote
1 answer
3k views

password authentication failed for user "postgres"

The sample.sql is simple. create database test; The settings on /etc/postgresql/13/main/pg_hba.conf. local all postgres md5 local all all ...
showkey's user avatar
  • 334
1 vote
2 answers
211 views

Make data rotation with MariaDB database

We have a small local computer that we use as a temporary database backup to automatically recover data from sensors when we lost connection to the main cloud server or when we have to make ...
Afaeld's user avatar
  • 23

1
2 3 4 5
15