Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
4k 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
55 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 ...
1
vote
2answers
714 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
261 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
24 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
794 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
299 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
559 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
756 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
1answer
2k 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
82 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
175 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
233 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
1answer
534 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
52 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
366 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 ...
4
votes
3answers
101 views

Can a MS SQL Server be named different than host computer?

I have a virtual machine that was built by our IT department to host various processes. They named the computer something incomprehensible like "XYSVC105" and I am not allowed to change it. I have ...
1
vote
2answers
2k 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
36 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
328 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 ...
-2
votes
2answers
7k 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
1k 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=...
3
votes
2answers
1k 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
412 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 ...
1
vote
2answers
1k 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
2k 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
3k 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 ...
6
votes
3answers
19k 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
348 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 ...
13
votes
1answer
2k 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
775 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
190 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
112 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 ...
1
vote
1answer
207 views

ALTER DATABASE ARITHABORT configuration minimum privilege needed

What is the minimum privilege needed to execute ALTER DATABASE {db_name} SET ARITHABORT ON? I found that the privilege ALTER ANY DATABASE would suffice this, but I wonder if there isn't any other "...
5
votes
1answer
655 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
430 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?
4
votes
1answer
4k 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
2answers
283 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
2k 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: ...
1
vote
2answers
415 views

MySQL does not read user specific options in ~/.my.cnf

I want the server to run an initial SQL query every time it starts: [mysqld] init-connect='SET NAMES utf8mb4' and I want it to be only user specific not globally. so I created a .my.cnf in my user's ...
2
votes
0answers
57 views

How to set up SQL Server online with public Wi-Fi

I am doing a school project where I have to set up a SQL Server database for my teammates to work on. Currently, I am able to host the server online with my home router, but I am facing problems ...
4
votes
1answer
5k views

How to disable Postgres from listening on IPv6?

I am trying to disable Postgres from listening on IPv6 because of a bunch of strange trace files that are constantly being written to syslog. I'd prefer not to disable IPv6 in the OS itself, so ...
1
vote
1answer
507 views

Always On shared network location

To use the wizard from SSMS, we had to provide full access to "everyone" to the shared network location. Is there a way to avoid this and just limit the access to a specific user? Already tried the ...
5
votes
1answer
518 views

How to limit work_mem on PostgreSQL

As an analyst I love having the ability to turn up the work_mem on occasion when a big sort or index build is in the offing. As a DBA, the idea of random users being able to request an arbitrarily ...
0
votes
1answer
330 views

Using character set en_us.364 in Informix database DB_LOCALE

I am trying to change my db_locale to en_us.364 which is an ASCII character set. It says on IBM's Knowledge Center that 364 is a valid character set: https://www.ibm.com/support/knowledgecenter/en/...
1
vote
1answer
341 views

64k AU size - master, model, msdb

Should master, model and msdb reside on drives with 64k AU size? Is it necessary? Recommended? All of our SQL servers are on VMware. If necessary, I would like to be able to recover a VM from a ...
0
votes
1answer
63 views

MySQL time_zone = SYSTEM not getting correct date on CURRENT_TIME

Via SSH I print the current date of my server, which is correct based on my location: When I run SHOW GLOBAL VARIABLES on MySQL, I have time_zone = SYSTEM - which makes me think MySQL will be using ...
1
vote
1answer
138 views

Exclude application from postgres logs

Currently on one of our dev servers we log everything what happend in database, but lots of traffic in is generated by patroni cluster and is not needed in further investigation. Is possibile to ...
1
vote
0answers
78 views

When the master db fails, the slave db will enable the write mode. How do I synchronize the master db with the information written to the slave db?

have two database. They are db1 and db2. db1 master, slave at db2. d1 have write/read mode. d2 have read mode. I have a problem like this: When the master db fails, The slave db will enable the ...
0
votes
1answer
226 views

What is the MAXDOP value for the server which doesn't have NUMA [duplicate]

Im using a SQL Server with the below configurations. 4 Core. 8 Logical processors. No NUMA. NO hyperthreading. I read this Doc: Recommendations and guidelines for the "max degree of parallelism" ...

1 2 3 4 5 12