Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
2 votes
1 answer
198 views

SQL Server timeout on DB and into connection string

Recently i have discovered (i have to premit i am not a DBA) that there is the possibility to configure a timeout into SQL Serve property (which apply to all DB into the SQL Server instance) : ...
user avatar
  • 287
0 votes
0 answers
3 views

Is it possible to automate importing vssettings in SSMS?

I have a few settings which I distribute to students as a .vssettings file to be imported into SSMS. Importing the file isn’t too difficult, but I wondered whether it is possible to somehow automate ...
user avatar
  • 2,337
1 vote
0 answers
39 views

mariaDB 10.2: sql mode has changed

The Upgrading from MariaDB 10.1 to MariaDB 10.2 states: SQL_MODE has been changed; in particular, NOT NULL fields with no default will no longer fall back to a dummy value for inserts which do not ...
user avatar
  • 151
2 votes
0 answers
23 views

mysql stopped working after no free space on file system [corruption]

I am experiencing the following error when launching MySQL. can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket '/var/...
user avatar
  • 21
1 vote
1 answer
290 views

Change SQL Server 2019 instance Collation After installation, and new problem

How to made this problem on SQL Server 2019 Install SQL Server with wrong collation 2month ago Revived a report from SharePoint admin about has a problem with collation Resolve problem with MSSQLTIPs ...
user avatar
0 votes
1 answer
58 views

Postgres autovacuum keeps transaction id's around to 10% limit, causing aggressive vacuuming to trigger now and then which locks tables

We run multiple Postgres clusters in our infrastructure with 10-30 DB per cluster, ranging from 10 GB size to 1TB in size. I have recently noticed that on all our clusters the wraparound id is always ...
user avatar
0 votes
1 answer
27 views

How to query for Amazon RDS instance configuration?

From within a plpgsql script run on an Amazon RDS Postgres instance, is it possible to get information about instance configuration? How do I retrieve the DB instance ID, ARN (Amazon Resouce Name) or ...
user avatar
0 votes
1 answer
41 views

How to change default compression mode in mariaDB Columnstore?

In mariaDB there is a way to disable columnstore compression in session level (and set the disable flag in each session). Is there any way to change the default compression mode?
user avatar
3 votes
2 answers
163 views

Command to validate a postgresql configuration file?

I am generating postgresql configuration files via ansible, and putting them in /etc/postgresql/XX/main/conf.d/whatever.conf. I accidentally made a syntax error and broke my postgresql, requiring ...
user avatar
0 votes
0 answers
41 views

possible to show maximum query text in trino?

We have some queries that are hundreds or thousands of lines long that create a QUERY_TEXT_TOO_LARGE error. Is there a query I can run to show the maximum query text length in Trino/hdfs? I couldn't ...
user avatar
  • 234
0 votes
1 answer
110 views

How to create a custom database with 32k block size via DBCA silent mode?

I am trying to create an Oracle 19c single instance (warehouse) with dbca silent mode. The problem is, when I try the command below, it gets a warning: "Ora-0058: DB_BLOCK_SIZE must be 8192 to ...
user avatar
1 vote
1 answer
118 views

After a database upgrade from MariaDB 10.1 to 10.6 new ODBC connections are returning wrong values [closed]

I had a total meltdown after installing "Feature update to Windows 10, version 21H2". A month into this I am now suspect that somehow this update reconfigured the way user System is handled. ...
user avatar
  • 133
1 vote
1 answer
130 views

Postgres initdb with custom timezone directory

How can I run Postgres initdb with a custom timezone folder? I've tried to use the -L flag and PGSHAREDIR env var to control where initdb searches for Postgres share data. However, those options don't ...
user avatar
  • 139
1 vote
1 answer
100 views

Temp files and work_mem

My Postgres instance is logging things like this: 2021-11-16 22:18:52.491 UTC [1808765]: [3-1] db=xxx,user=xxx LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp1808765.0", size 262144 My ...
user avatar
-2 votes
1 answer
57 views

How to recover from setting maximum server memory too low? [closed]

On SQL Server 2019, it is possible to configure the server for a smaller than minimum amount of memory (in my case, 100mb). After doing this, the server crashes on startup. Some other forums pointed ...
user avatar
0 votes
2 answers
47 views

MySQL configuration. Query doesnt get returned result (DataGrip, DBeaver, PHP). Something times out [closed]

I am running a simple INSERT INTO ... SELECT ... ON DUPLICATE KEY UPDATE ... query using either DataGrip or DBeaver or PHP and it always doesnt register the result. The SELECT inside takes about 10 ...
user avatar
1 vote
0 answers
65 views

PostgreSQL 11 - Tuning of the background writer process (maxwritten_clean)

I notice that the metric maxwritten_clean in the table pg_stat_bgwriter increases (for example going from 0 to 1000 in several seconds). I guess this is understandable as it happens while there are ...
user avatar
0 votes
1 answer
62 views

pg_settings.statement_timeout changing constantly between 0 and 30000?

When I run the following query constantly every few seconds over a 30 second time period, I sometimes get a value of 0 and other times a value of 30000. The value changes constantly and I don't know ...
user avatar
0 votes
1 answer
133 views

MariaDB on Ubuntu mysteriously goes away after 15 minutes [closed]

I have an issue I've never seen before...my MariaDB goes away after 1800 seconds, despite having the default configuration for wait_timeout of 28800 seconds. I checked all my my.cnf files, and there ...
user avatar
0 votes
1 answer
27 views

MySql Important Linux System Configuration [closed]

Last month I'm trying to find a "formula" for optimal Linux system configuration for MySql installation. But I didn't find anything related in those fields: Should I disable swapping ? ...
user avatar
0 votes
2 answers
145 views

changing SSMS settings via Powershell

in order to enable the dark theme to SSMS (not available on the picture below as you see): following this webpage: SQL SERVER Management Studio 18 - Enable Dark Theme - SQL Authority with Pinal Dave ...
user avatar
0 votes
1 answer
71 views

Should I change parallelism (MaxDop and Threshold)?

Seems like I have problems with parallelism because largest wait types are CXCONSUMER and CXPACKET. Server has 8 cores. So I am planning to bump up Cost Threshold to 50 and MaxDop to 4 Currently I ...
user avatar
  • 637
0 votes
1 answer
67 views

Storage configuration for faster queries [closed]

Please advise on setting up storage allocation for a new SQL Server 2019 machine. Ryzen 7 8Core with 64GB Ram 4 local drives (2TBNVMe PCIe4 + 1TBNVMe PCIe3 + 2TBSSD + 4TBHDD) I am going to allocate ...
user avatar
0 votes
1 answer
88 views

What is the proper configuration for max open connection, max idle connection and max connection life postgreSQL?

We have an app that serves small to moderate kinds of traffic. our server spec: 6 node of micro/small aws ec2 for client 1 db.r5.2xlarge for writer 1 db.r5.large for reader our app/client setting: ...
user avatar
  • 1
0 votes
1 answer
318 views

MongoDB: F CONTROL [main] Failed global initialization: FileNotOpen: Failed to open "/data1/mongodb/log/mongod.log"

I am trying to install mongodb 3.4 on Redhat 7.9. When I start mongodb systemctl start mongod I get the below error FileNotOpen: Failed to open "/data1/mongodb/log/mongod.log, But when I start ...
user avatar
  • 1
0 votes
5 answers
96 views

mysqld process performance [closed]

I'm running in problems that I can't solve by myself. Mysqld process go over 100%, sometimes over 500% in web peaks. Idk why mysql running only one process, websites works fast without any problem ...
user avatar
0 votes
1 answer
100 views

How can the size of the notification queue be configured?

The documentation for NOTIFY states The queue is quite large (8GB in a standard installation) and should be sufficiently sized for almost every use case Is it possible to configure the size of the ...
user avatar
0 votes
1 answer
41 views

Configure listen_addresses automatically in custom installation

I have included Postgres in a custom installer for a Windows application. I do not use the installer binary, but extract the Postgres zip archive for installation and then run initdb from a batch ...
user avatar
  • 111
0 votes
0 answers
160 views

PostgreSQL remote connection failing

I've recently installed PostgreSQL on my PC as a requirement for my DB class, and as a practice, I decided to try and setup a remote connection for it so I can access it via online services. But after ...
user avatar
4 votes
2 answers
3k views

How to set statement timeout per user?

I have multiple users in Postgres. I would like to set up different statement timeouts for different users. Eg: Guest 5 minutes and Admin 10 minutes. Is it possible in Postgres 11.11?
user avatar
4 votes
0 answers
289 views

SQL Server Network Packet Size

During the analysis of network traffic from Citrix clients to our database server, we noticed that we had a lot of RETRANSMITs occurring during the transport of TCP packets. The packets were being ...
user avatar
  • 14.9k
0 votes
1 answer
171 views

IP Addresses tab is not showing a specific IP Address

I have SQL SERVER 2008 R2 installed on windows Server 2016, it runs smoothly on a LAN network interface. I Added a USB MODEM (4G) to the server and went to the IP Addresses tab in network ...
user avatar
0 votes
1 answer
150 views

Why turning off condition_fanout_filter speed up query

bin/mysqld_safe --user=mysql --optimizer-switch=condition_fanout_filter=off --innodb-flush-method=O_DIRECT & Query (from TPC-H query-19): SELECT Sum(l_extendedprice * ( 1 - l_discount )) AS ...
user avatar
  • 83
0 votes
0 answers
35 views

My Mongos can't authenticate to my replica set

I have 3 config servers in a replica set and when I use the command: sudo mongos --configdb crs/the 3 config servers:port# --keyfile "Keyfile", I keep getting this error: [mongosMain] Unable ...
user avatar
0 votes
2 answers
2k views

mysql: [ERROR] unknown variable 'default-authentication-plugin=mysql_native_password' [closed]

When I installed MySQL 8.0, I selected sha256 password authentication method instead of legacy, When I tried to return to native password authentication it shows an error message: mysql: [ERROR] ...
user avatar
2 votes
1 answer
151 views

Choosing the right blocksize for Oracle Database tablespaces with lobs

We are currently switching from an older character set to Unicode using impdp/expdp on Oracle Database 19c. We had to changed several data types. We changed tables with LOBs from basicfile to ...
user avatar
  • 868
0 votes
1 answer
395 views

Postgres `log_disconnections = on` does not log disconnects

I have surely a basic problem and am undoubtedly overlooking a simple issue.. I have configured Postgres 12.4 with log_disconnections, but the log file does not show any disconnects. (It is logging ...
user avatar
0 votes
1 answer
88 views

why HDD is more sensitive to the change of innodb_fsync_threshold than SSD

What am I doing: I want to do some experiments to find some interesting facts in DBMS when changing configurations above different physical storage media. Disk: Intel P45 SSD vs. SATA HDD 7200 RPM. ...
user avatar
  • 83
1 vote
1 answer
81 views

Why does PostgreSQL ignore auto_explain.log_analyze = 0 in is postgresql.conf file and how can I turn on auto_explain for all sessions?

I have a strange problem with PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit (that was the complete output from select version();). My problem ...
user avatar
1 vote
1 answer
27 views

CSS-like dynamic properties cascading configuration table? [closed]

Have an idea in mind, not interested in inventing an existing wheel, but can't find info on the subject so I'm turning to the community. My goal is to define a "dynamic properties cascading ...
user avatar
0 votes
1 answer
248 views

Why is MySQL not connecting when reading from mylogin.cnf?

On Ubuntu 20.04, I can log into a server by specifying the log credentials on the CLI: $ mysql -h172.30.0.2 -uroot -p bar -e "SELECT id FROM users LIMIT 1;" Enter password: +----+ | id | +---...
user avatar
  • 1,048
1 vote
0 answers
169 views

What would cause slow disk access on an AWS EBS SQL Server? (PAGEIOLATCH_SH)

I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in EBS access. This machine has a 7TB mounted gp2 volume, with 16,000 IOPS, which is mounted and contains a SQL Server database ...
user avatar
0 votes
2 answers
124 views

Help me tune my.conf MySQL [closed]

Currently, I have been surfing around for ideas and copying some of the processes and details found and playing around with my Server and now seems to be pretty good but with some anomalies in ...
user avatar
0 votes
1 answer
179 views

Affinity side effects / TF 8002- how to measure

Environment: We have Microsoft SQL Server 2016 (SP2-CU15) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0. We have multiple SE instances on one physical server. We use processor ...
user avatar
  • 1,228
-1 votes
1 answer
40 views

How do I log the actual script's name in csvlog? [duplicate]

I have PostgreSQL CSV-log its errors according to this structure: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG Sadly, from what I can tell, it neither ...
user avatar
0 votes
2 answers
266 views

What's the meaning of "resources external to the SQL Server computer are needed" in Microsoft's SQL documentation?

In Microsoft's SQL Server documentation on Windows service account configuration, the decision to use either a VA (virtual account) or a MSA (managed service account) hinges on whether resources ...
user avatar
1 vote
1 answer
2k views

Disable auto-start of postgres server on boot (Mac)

Running a Mac. I installed Postgresql 9 many years ago and configured it to auto-start. Now I have upgraded to version 12 using brew, but on system restart version 9 server is still starting ...
user avatar
  • 155
3 votes
1 answer
290 views

Understanding DBCC TRACEON and TRACEOFF Globally and Session-wise

For those of you that keep track of what I discuss in The Heap™ you might have been following my endeavours whilst migrating a database from SQL Server 2008 R2 to SQL Server 2016 and battling with ...
user avatar
  • 14.9k
-1 votes
2 answers
111 views

How do I make PostgreSQL not log specific errors?

ERROR: deadlock detected at character 13 My PG log is full of this, but the thing is, I already handle it (after years of frustrations) in my application. I detect them and repeat until they go ...
user avatar
1 vote
0 answers
28 views

Extreme slow query for a simple indexed selection - Why? [duplicate]

i have a table in my database that is described as follows: -- Table: public.devicemeasurement_mqtt -- DROP TABLE public.devicemeasurement_mqtt; CREATE TABLE public.devicemeasurement_mqtt ( ...
user avatar
  • 171

1
2 3 4 5
14