Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
3
votes
0answers
37 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
28 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
19 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
9 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
1answer
120 views

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

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
10 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] ...
1
vote
1answer
38 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
18 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
33 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
23 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
26 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
25 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
0answers
26 views

MariaDB doesn't read all options from /etc/mysql/conf.d/ after upgrade

I am using Ubuntu 20.04LTS. I upgraded Mariadb 10.5.5 to 10.5.8 using mariadb's own repositories. After upgrade I noticed API server was unable to connect to DB server through private network. After ...
0
votes
0answers
40 views

64k disk cluster size and vSAN [duplicate]

It's time to ask again this popular question: "Is it still valuable for the I/O performance to manage disk cluster size?" But this time I'm interested in a case with vSAN as storage. I've ...
0
votes
1answer
58 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
66 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
100 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
66 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
33 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
48 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 ...
0
votes
1answer
336 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
103 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
37 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
94 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
40 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
0answers
21 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 ...
0
votes
0answers
72 views

Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE' vulnerability for Windows 2008 R2 SQL

I have a MSSQL Windows 2008 R2 server. Vulnerability for "Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE'" has been found. Current ...
3
votes
1answer
94 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
61 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 ...
0
votes
1answer
44 views

Mysql - which cnf file to update

I have mysql 8 running on a ubuntu 20.4 server. I want to apply some setting to optimize the database so that it uses less ram for a web application. typically switching of the performance_schema. ...
2
votes
1answer
25 views

Is there a reason I should not set my default data location to google drive when setting up PostgreSQL?

I'm brand new to working with databases and am setting up a PostgreSQL database which will be used for personal projects. I'm setting it up with the postgis extension and will use both for some basic ...
1
vote
1answer
143 views

pg_basebackup not running even after trying all the methods

I configured pg_basebackup on another server, where it is running perfectly, but in one of the servers pg_basebackup is not running at all. Below are the error details. I tried multiple ways to ...
1
vote
1answer
740 views

How to properly configure my.ini for MySQL? [closed]

I've just installed on my new server MySQL 5.0.24 64bit (till now i've used same version of MySQL but 32bit on another server), on the old server i've changed in my.ini the parameters of ...
0
votes
0answers
25 views

How to set the view format of pgAdmin4's query results?

I'm learning to use pgAdmin4 in my work, but the query results are hard to be read since every columns are too long. For example, there is a column in a query result, whose type is double. In fact I ...
0
votes
1answer
133 views

Why doesn't MariaDB server recognise Server Audit settings in config file?

I'm trying to implement the Server Audit plugin that is built-in with MariaDB 10.4. I've added the settings to the my.ini config file, running on Windows 10. [server] ... #Audit Settings ...
1
vote
1answer
46 views

Should an account be set up and used solely to install SQL Server?

I'd like to follow best practices. However, is it overkill to create a new service account (with minimal access and no special rights) and then use that account to install SQL Server? Are there ...
1
vote
3answers
581 views

Sql Server replication: Initial snapshot for publication is not yet available?

I had setup transactional replication and my distributor, publisher are on same windows server and 2 subscriber one on same server and another on other windows server both using push snapshot. I am ...
3
votes
2answers
1k views

MySQL Tuner returns: MySQL's maximum memory usage is dangerously high

Can someone help me optimize my MSQL configuration. I run Zabbix and Grafana on a Ubuntu 18.4. MySQL Tuner shows me that my memory usage is dangerously high, but when I use the free command it shows ...
0
votes
2answers
200 views

Why SQL Server port number is not default 1433?

Installed latest SQL Server. It is listening on port number 62628 according to server log. Why is the port number is not the default of 1433? How to change the port number back to the default 1433? ...
1
vote
1answer
610 views

Using NUMA Nodes with SQL Server

I have a question to understand better how NUMA nodes help in SQL Server: In our current set up, we have 4 NUMA nodes with 20 cores and hyper threading enabled, making a total of 40 logical ...
0
votes
1answer
40 views

How to get the settings associated with a stored procedure in relation to filtered indexes?

I quite like using filtered indexes in the proper context. I have added the following filtered index: USE [COLA]; CREATE UNIQUE NONCLUSTERED INDEX F_InterviewReport ON [dbo].[...
0
votes
2answers
85 views

What triggers the SSRS to generate a log file or modify a current one?

When running a trace on my new SSRS Reporting Services 2016, after troubleshooting some problems related to migrating from SSRS 2008, I find the following pattern running continuously: Here is the ...
1
vote
2answers
2k views

PostgreSQL: Allow connection by host name and not IP?

As background when connecting from remote (eg home mostly using JDBC) due to how the VPN works I always get a different IP address and hence I can't connect because the IP isn't listed in pg_hba.conf. ...
-1
votes
1answer
31 views

MySQL - Which options in the configuration file have an impact on memory usage?

I've been wondering how to manage MySQL memory usage since by default it takes up to 350MB while idle on my machine, I don't have memory issues, I honestly just wondered how could it be done. I found ...
2
votes
2answers
224 views

Less obvious “The table 'mytable' is full” error

Error in mysqld.log: 2020-02-02T01:17:32.133974Z 3069 [ERROR] /usr/sbin/mysqld: The table 'IS_DUT_IFID' is full None of the many threads I've found about this error have helped me to resolve this ...
1
vote
1answer
2k views

Setup innodb_io_capacity

I want to configure the innodb_io_capacity option for my MariaDB server. In the documentation I found the following: Faster hard drives, RAID configurations, and solid state drives (SSDs) benefit ...
0
votes
1answer
2k views

mongodb conf node won't start - compatibility error

I recently upgraded a dev sharded-cluster from 3.6 to 4.0 - one of the conf servers is now failing to start: 2020-01-30T13:19:02.972-0600 F CONTROL [initandlisten] ** IMPORTANT: UPGRADE PROBLEM:...

1
2 3 4 5
13