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
1answer
18 views

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

In somewhat related questions I notice the discusions of Data Engines. I have some tables set to MyISAM and some set to InnoDB but not sure if this could be causing the problem. I used to connect to ...
1
vote
1answer
25 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 ...
1
vote
1answer
21 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 ...
-2
votes
1answer
46 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 ...
0
votes
2answers
28 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 ...
1
vote
0answers
47 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 ...
0
votes
1answer
45 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 ...
0
votes
1answer
58 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 ...
0
votes
1answer
25 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 ? ...
0
votes
2answers
51 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 ...
0
votes
1answer
69 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 ...
0
votes
1answer
63 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 ...
0
votes
1answer
63 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: ...
0
votes
1answer
181 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 ...
0
votes
5answers
74 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 ...
0
votes
1answer
46 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 ...
0
votes
0answers
44 views

Have two versions of one object in ssdt sql server database project or have objects visible/not visible depending on configuration option selected

I have a database project with 3 tables. 2 of the tables are the same table, but one is configured as a temporal table and the other is not. The 3rd table in the project is the history table for the ...
0
votes
1answer
27 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 ...
0
votes
0answers
103 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 ...
3
votes
2answers
1k 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?
4
votes
0answers
124 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 ...
0
votes
1answer
103 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 ...
0
votes
1answer
81 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 ...
0
votes
0answers
13 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 ...
0
votes
2answers
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] ...
0
votes
0answers
22 views

MySQL Group Replication starts master node with super_read_only

I am trying to set up MySQL group replication. Only problem is, that when I try to start replication group, It starts with super_read_only. Here the configurations in my.cnf file [mysqld] ...
2
votes
1answer
105 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 ...
0
votes
0answers
131 views

How to increase mysql_connect_error on mysqlrouter?

I have an problem with mysqlrouter. I try to increase the max_connect_errors variable on mysqlrouter but is still value 100 in the file log. 2021-03-02 14:30:59 routing INFO [7f31a73f3700] [routing:...
0
votes
1answer
229 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 ...
0
votes
1answer
56 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. ...
1
vote
1answer
57 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 ...
1
vote
1answer
26 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 ...
0
votes
1answer
164 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 | +---...
1
vote
0answers
126 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 ...
0
votes
2answers
107 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 ...
0
votes
1answer
145 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 ...
-1
votes
1answer
38 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 ...
0
votes
2answers
174 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 ...
1
vote
1answer
1k 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 ...
3
votes
1answer
226 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 ...
-1
votes
2answers
74 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 ...
1
vote
0answers
27 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 ( ...
1
vote
1answer
136 views

best practice with RAID0 configuration - to keep all of them in separate drives i.e. tempdb, mdf, ldf, backups [duplicate]

Database size - 145GB Currently our database mdf file, tempdb, backups are in D drive and log files are in C drive. Can we go for the below configuration: D drive - tempdb, E drive - mdf, f drive - ...
0
votes
0answers
42 views

Changing domain, can't connect [duplicate]

I have a server that hosts a SQL Server 2017 Entreprise Edition database. I changed domain on the server (e.g. attds.mg in fdsqq.mg). The problem is that I can't connect my application to the database....
1
vote
2answers
9k views

MongoDB start errors

I was following along a course and entered a command that was given mongod --dbpath=data --bind_ip 127.0.0.1 In the past, I had used mongo and it had worked, but I'm sure I had never entered this ...
1
vote
0answers
23 views

Required WAL settings to permit large queries to run on server which is replicating to standby server

What WAL/conf settings are required to permit large queries in PostgreSQL without breaking replication to the replica server? Is it only a matter of ensuring that: the WAL writes don't time out? the ...
4
votes
1answer
247 views

Problem with enabling System Audit (Firebird's Trace and Audit Services)

I would like to enable System Audit on my Firebird 2.5.9.27139 (x64) database (Windows 10), to inspect all queries performed on it. I've already read some docs about what the configuration file should ...
-1
votes
2answers
111 views

How to create a same user in different PDB while it exists in other PDBs?

I have a list of 100 PDBs in the CDB, say the account_user exists in 50 PDBs and to create the same account_user in other 50 PDBs instead of logging into each PDB and creating user, is there a way to ...
1
vote
0answers
28 views

Finding modifications to model database

There are ways already to compare sp_configure values for an instance and review all non-default settings. Assuming that the model database of an instance has been modified from its original settings, ...
0
votes
2answers
39 views

SQL Server sharing drive location

DBA newbie here. Did some searching online but cannot find a definite answer on this. Is it acceptable to share the drive where .MDF files reside with other non-SQL Server files such as applications ...

1
2 3 4 5
13