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

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

0
votes
0answers
15 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
28 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
29 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
65 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
32 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
63 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
33 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
69 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
42 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
60 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
15 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
22 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
73 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
53 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
40 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
107 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
133 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
28 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
62 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
65 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
207 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
68 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
47 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
92 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
181 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
28 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
97 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
429 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
138 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
30 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
274 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
145 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
101 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
359 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
393 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 ...
1
vote
2answers
3k 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
803 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.
3
votes
3answers
98 views

How to set up the SQL Server to read a database from external hard disk or a different hard disk from my PC

Is it possible for SQL Server to access a database from a different location? My Primary Hard Disk (C:) is almost full, however I have a second Hard Disk in my computer. When I try to restore the ...
1
vote
1answer
72 views

Why would anyone ever disable `index_condition_pushdown` (ICP)?

I'm just wondering if there is every a valid reason to disable index_condition_pushdown? Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using ...
0
votes
1answer
43 views

AG replicas across two FCIs

I have the following setup: One Windows cluster consisting of four cluster nodes: A, B, C, D. Cluster nodes A and B in one data centre, cluster nodes C and D in a second data centre. SQL failover ...
0
votes
0answers
16 views

Exact encryption being used by Oracle 12

Working with an existing Oracle 12c database which has been configured for encrypted tables. Existing DBA says that it has been configured with AES256 CBC encryption. I was able to find the AES256 ...
0
votes
1answer
56 views

ALTER DATABASE ARITHABORT configuration minimum privelege needed

What is the minimun previlege needed to execute 'ALTER DATABASE {db_name} SET ARITHABORT ON'? I found that the previlege 'ALTER ANY DATABASE' would suffice this, but I wonder if there isn't any other ...
3
votes
1answer
110 views

Give a “super” user more work_mem

One common pattern I’ve noticed over the years is that people tend to keep increasing working memory as their data size increases, so that more complex queries can still take full advantage of memory ...
1
vote
1answer
68 views

How do I change the default external text editor in psql?

I want to change the external editor in psql. But the command select-editor does not work. How can I change it? How do I run the command?
1
vote
1answer
882 views

How to enable force ssl on AWS Aurora Postgres?

In AWS's direct postgres offering RDS Postgres, you can require SSL by setting the parameter group item rds.force_ssl to 1. This is as per the RDS postgres documentation: https://docs.aws.amazon.com/...
1
vote
0answers
28 views

Has anyone seen any benefit of having -E startup param for OLAP system? [closed]

In the configuration manager you have the option to add different parameters. By adding the -E flag, you force SQL Server to allocate more extents at a time to each file, which in theory allows better ...
0
votes
1answer
79 views

Upgrade Single Config Server to Replica Set

Recently we wanted to upgrade our Config Server to Replica Set. Since it is a development environment, we only have one Config Server running. However, the official mongoDB documentation "Upgrade ...
1
vote
2answers
365 views

extension “pg_buffercache” already exists and relation “pg_buffercache” does not exist

When I try to create the extension pg_buffercahe using the following command: ➤ psql://postgres@postgresql-95-2:5432/postgres CREATE EXTENSION pg_buffercache; ...it returns the error: ERROR: ...