Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [configuration]

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

1
vote
1answer
23 views

SSMS 2017 Export SCOPED CONFIGURATION

I reinstalled Windows 10 from scratch. I'm trying to get SSMS options setup the way I like them. When I r-click a DB, then Tasks->GenerateScripts, the result doesn't contain SCOPED CONFIGURATION ...
2
votes
1answer
41 views

System configuration to address poor PostgreSQL INSERT performance

Problem Symptom High CPU usage by postmaster child process associated with client connections attempting to INSERT low-volume rows (results in rows INSERTed 25x slower than using COPY ... FROM STDIN ...
1
vote
0answers
28 views

Error while trying to create a database for SSRS

I have installed SQL Server Reporting Services 2017, and my database engine is developer edition 2017. Now, while trying to configure SSRS from its Configuration Manager I get this error I have found ...
2
votes
1answer
20 views

pt-kill - how to securely allow access to mysql server when running as service

I know how to run pt-kill as systemd service: [Unit] Description = pt-kill myUser After=syslog.target mysql.service Requires=mysql.service [Service] Type = simple PIDFile = /var/run/ptkill.pid ...
0
votes
1answer
97 views

DB server VM's CPU configuration - 1x2Ghz or 2x1Ghz - which is better

We want to set up DB server in cloud hosting for MS SQL Server Express edition - OLTP workload for "just" 6 concurent users - mostly short and small transactions. Hosting company is charging each ...
1
vote
0answers
83 views

Percona 5.6.28-76.1: optimize config for database (Invision Power Board)

At the beginning I would like to explain that I'm not a DB expert. My hosting provider is struggling with DB optimization for my website. Unfortunately seems that they are out of ideas. I would like ...
1
vote
1answer
82 views

MariaDB writes a lot on disk [closed]

Configuration 10.2.15-MariaDB 20 GB RAM Total DB size - 16 GB, almost all tables are MyISAM. Some tables have rather big index files, about 400-700 Mb. Observations Writes about 4 GB per hour ...
2
votes
2answers
177 views

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

In Postgres 11, the CREATE DATABASE command that makes a new catalog has an option ALLOW_CONNECTIONS. The documentation says this option can be used to block all connections to the database: [ ...
0
votes
1answer
35 views

Query for all the Postgres configuration parameters‘ current values?

You can set various configuration parameters for Postgres by either editing the postgresql.conf file manually or by calling ALTER SYSTEM commands. These are two avenues for writing the settings, but ...
1
vote
1answer
47 views

Why is cross db ownership chaining on by default for system DB

I am reading about cross db ownership chaining Server Configuration Option It talks about how and why to use (or not) this option and says Setting cross db ownership chaining to 1 is not ...
5
votes
2answers
103 views

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

TL;DR I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (...
1
vote
1answer
131 views

How to edit `postgresql.conf` with pgAdmin 4?

Same Question as this: How to edit postgresql.conf with pgAdmin 3? but updated for the completely new (total re-write) pgAdmin 4. ➥ How does one edit the configuration files with the pgAdmin 4 app? ...
1
vote
1answer
43 views

how to script out all the permissions in a folder using powershell?

Using the script below I find out where are the data and log folders: declare @rc int, @dir nvarchar(4000) declare @data nvarchar(4000) declare @log nvarchar(4000) ...
-1
votes
1answer
31 views

MongoDB replica set configuration problem

I'm facing some issues when trying the following: I have a three-node MongoDB 4.0 cluster, no sharding, one mongodb instance as primary, the rest as secondaries. When I shut down the primary, one of ...
2
votes
1answer
108 views

Cannot remotely access PostgreSQL on EC2 instance

I was unable to access a remote AWS postgres database via things like psql -h *EC2ExternalIP* -U *me*. I would get: psql -h *EC2ExternalIP* -U *me* psql: could not connect to server: Operation timed ...
1
vote
0answers
71 views

Oracle Warning in Alert Log Regarding PGA_AGGREGATE_LIMIT

Introduction During the startup process of our Oracle instances, we are encountering the following error message in the alert log: WARNING: pga_aggregate_limit value is too high for the amount of ...
0
votes
1answer
145 views

Listing the Microsoft SQL Server configuration with the values set by mssql-conf?

The utility mssql-conf in /opt/mssql/bin/mssql-conf has the setting list which tells you possible keys, $ sudo ./mssql-conf list control.alternatewritethrough Enable optimized write ...
2
votes
2answers
34 views

Availability Group Listener - Dedicated Server?

Should an AG Listener be set up on it's own server? If so, does it require it's own SQL Server license?
1
vote
1answer
306 views

Which file do I need to modify my.cnf MariaDB on Ubuntu 18.04

I want to modify these values: [mysqld] key_buffer_size = 256M max_allowed_packet = 128M thread_stack = 256K query_cache_limit = 64M query_cache_size = 384M innodb_buffer_pool_size = ...
3
votes
1answer
44 views

Steps involved in configuring SQL Server and its components after server is renamed

I have a cloned (duplicate) server with SQL Server on it and the server name had to obviously change once it was copied. This article describes two actions to perform: using below code to manually ...
0
votes
2answers
76 views

Setting isolation level at database level

We have a data warehouse that's being dropped and reproduced every night. We have lots of SSRS reports that use the warehouse. Sometimes an SSRS report goes wrong and will never execute, thus ...
0
votes
1answer
24 views

Set InnoDB as default engine and set a default collation

What should I do to set InnoDB as the default database engine? And is possible to set a default collation when I create a schema and tables (e.g. utf8mb4)? I don't want to have to choose these ...
1
vote
0answers
23 views

Setting up MySQL (Master-Slave) replication with all ready configured databases/tables

I am trying to configure MySQL databases using the Master-Slave Replication. Before I realized that I had to set up my environment using this replication, I already have 2 separate servers running ...
4
votes
1answer
141 views

Turn off telemetry in SQL Server install config file

I'm creating a SQL Server 2017 Image Completion config file, and the automatically generated one has a bunch of stuff about "telemetry". I clicked no to the prompts, but it still put several user ...
1
vote
0answers
80 views

MongoDB Warning impossible to clear

I'm using Ubuntu 16.04 and MongoDB 4.0.1. When I use mongo shell I got this : I STORAGE [initandlisten] I STORAGE [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with ...
1
vote
1answer
80 views

Changing mariadb port

I'm trying to change the default port for mariadb to 52000. I've modifed the port in /etc/MySQL/mariadb.conf.d/50-server.cnf and restarted the service. However, each time it still starts up on the ...
1
vote
2answers
192 views

MySQL consuming memory, seeking advice on how to configure it

I have a small VPS that handles my 3 personal WordPress websites. At a certain time MySQL started consuming more and more memory and actually (for months) the server has been running at 99% RAM usage ...
0
votes
0answers
27 views

TCP / IP SQL configuration

I currently have two instances. Initially, I had only one network card, but I added one more. I have configured the new IP of the second card in the TCP / IP corresponding to one of the instances, the ...
0
votes
1answer
335 views

Where should I store a custom “.my.cnf” file?

I am working in a Vagrant box (for development) and I have a provisioner script written in Bash. The script does install MySQL and setup a few things: basically it does what mysql_secure_installation ...
0
votes
1answer
33 views

What are current values in PG admin configuration editor for postgresql.conf

I am tuning a postgresql.conf file and here is what is shown in PG admin configuration editor What does the current value corresponds to? For the shared buffers (red line), what is the value there?
0
votes
3answers
70 views

I got a 2 core Mysql Server with 25 GB of RAM, 1 TB of Hard drive running on windows server. What is the proper configuration?

I am relatively new in running enterprise db server and as a developer, I am used to running my DB in the default setting on more focused on the code. Now, I saw that the DB is not properly configured ...
0
votes
1answer
90 views

Tempdb Configuration best practices

I've been asked to provide my input on best practices to improve tempdb performance. I realise that this is a case by case basis and tempdb in one estate may have different requirements to another due ...
0
votes
0answers
273 views

Configuration error in installing MYSQL Database as cannot initializing database

I installed wanted mysql programs while installing MYSQL 8.0.1 Enterprise Edition and then I was set up all settings and finally when I applied my configuration settings I continuously getting an ...
0
votes
1answer
93 views

Help with setting up MySQL on a dedicated server - detailed report given

I need help because I do not understand much MySQL settings on a dedicated server. I have one WordPress website installed with medium traffic with W3 Total Cache. The storage engine is InnoDB. ...
0
votes
1answer
48 views

Database organization for mirroring / partitioning / multistore [closed]

I know that is kind of generic question, but there is not other way to find a good answer. I have a requirement to create a network of a server and few simple PCs. My boss wants to have the database ...
1
vote
0answers
136 views

Designing a PostgreSQL database for high-volume updates

I am designing a database for a system that has to handle lots of writes operations (99%+ are updates, sometimes inserts) but at all times it has to provide fast reads. At the moment selects take a ...
1
vote
2answers
273 views

Error when executing “create pfile from spfile”

I just installed Oracle database 12cR2 and am trying to startup a database. I am trying to create a pfile from spfile using following query. create pfile from spfile; Then I get the following ...
0
votes
1answer
29 views

Shrinking the database partition if autogrow is turned off?

I want to know: Are there chances of shrinking the database partition if autogrow is turned off? Also, are there chances of data fragmentation and increase in seek times if we fully extend size ...
0
votes
1answer
134 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...
-3
votes
1answer
818 views

How to set lowercase_table_name

I've been trying to setup lower_case_table_names for ages in MySQL 8.0 without success. What is the procedure to set this up in 8.0? In previous versions of mysql I was able to override the variable ...
0
votes
1answer
215 views

different settings for max_heap_table_size and tmp_table_size (MariaDB 10.1.x)

I run pt-variable-advisor and got a note about different settings for max_heap_table_size and tmp_table_size. With a web search I found only old articles (around 2007). pt-variable-advisor h=...
0
votes
0answers
33 views

Can I allow non-TLS on localhost for MongoDB while requiring TLS for another IP?

The MongoDB net options don't seem to be very flexible. I want to be able to configure allowSSL for 127.0.0.1:27017 and requireSSL for some other interface, is this not possible with MongoDB?
3
votes
2answers
358 views

Will matching SQL Server network packet size to mtu increase performance

We have recently upgraded our production facility to sql server 2017, and moved to clusterless availability groups. There is a primary, a secondary on site, and a remote secondary. We were ...
2
votes
1answer
175 views

SQL SERVER Database IO performance impact of splitting database tables into FileGroups and multiple Files per filegroup

SAN LUN ambiguity wrt performance MSDN says to split read/write operations into a drive, sequential writes to another drive. (PRIMARY filegroup use typically data with read, update, write activity ...
0
votes
2answers
125 views

Recommended Auto Grow settings suitable for database whose size is 867666.25 MB [closed]

I need recommendations for setting/modifying the auto grow options for our production database. size of FUNDSDB 867666.25 MB Also, I have attached the current autogrowth statistics , looks like ...
2
votes
1answer
531 views

SQL Server Processor affinity with trace flag 8002 ON

I have been going through an article that explains the unwanted side effects of Setting a Processor Affinity in SQL Server. What I have come to know is that in most of the cases the default setting ...
0
votes
2answers
614 views

Cannot connect to mongos

Following the MongoDB Sharding Documentation, I start a mongos using a configuration file with the specifics of my config server. It seems rather straightforward, yet I am running into an issue. I ...
2
votes
2answers
4k views

MongoDB — Failed global initialization: Failed to open “/var/log/mongodb/mongod-config.log”

I'm trying to setup the config servers for mongodb sharding. I created a specific config file that is set to log to /var/log/mongodb/mongod-config.log. When I run mongod --config <path-to-config-...
4
votes
1answer
339 views

Can a database be created with no user and/or owner?

Maybe this is a good or a bad question but in my Google research I wasn't able to find out a good answer (maybe because I suck at performing a good search). In a few words: can a DB be created ...
10
votes
1answer
898 views

How do you turn off the croak sound for Toad?

How do you turn off this annoying feature? I don't want my DB manager to croak at me as loud as it can.