Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
-2
votes
1answer
4k 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
785 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
811 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
277 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
674 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
1k 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
2k 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 ...
5
votes
3answers
13k 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
343 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
465 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
158 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
89 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
187 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 "...
4
votes
1answer
509 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
251 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
3k 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
230 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
322 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
54 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
4k 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
358 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
386 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
272 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
303 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
48 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
105 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
74 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
209 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" ...
2
votes
0answers
23 views

During a SQL migration/upgrade, is there an intuitive way to mirror the exact file paths of the old install without manually combing through?

I am performing a migration upgrading from 2008 to 2016 and the requirements are that the file paths need to stay exactly the same as they were, with same drive letters, paths, and folder names due to ...
1
vote
1answer
537 views

oracle-xe (11g) service not mounting the database

A few days ago I did a system upgrade to fedora 27 and since then the oracle service doesn't properly start the database, I mean after running: sudo service oracle-xe start the database still down. ...
0
votes
3answers
192 views

MySQL process takes up to 180% of the CPU (optimisation need)

I have a dedicated server with 128 GB of RAM and an 8 core CPU and 2TB hard drive. I have cPanel and MySQL installed in the same server. In this server I have 12 websites hosted including 5 with a ...
-5
votes
1answer
78 views

What does `QUOTED_IDENTIFIERS` do, exactly?

There is a really obnoxious feature in SQL Server called QUOTED_IDENTIFIERS and I wanted to know more about it. In short, with the option set to ON, which is not the default with the Linux client, ...
-4
votes
1answer
108 views

How do I ensure a relationship is commutative and unique? [closed]

In PostgreSQL, we can ensure the relations stored inside a table a commutative-ly (or bidirectional etc) unique. For instance, CREATE TABLE foo ( a int, b int, UNIQUE ( greatest(a,b), least(a,b)...
1
vote
0answers
24 views

Best setting of MadiaDB database Server (version: 10.1.29-MariaDB) for data about 400GB

I have a single server with 128GB and 64 core CPU. I need to compare multiple tables (about 40 tables) having ~400GB data. The maximum size of a table has ~60GB data for upload as CSV file. With the ...
0
votes
1answer
1k views

How do I set the option use_remote_estimate?

Where do I set the "Cost Estimation Options" for postgres_fdw. Specifically I want to add use_remote_estimate. test=# SET use_remote_estimate=true; ERROR: unrecognized configuration parameter "...
1
vote
2answers
2k views

MongoDB Primary Member of Replica Set High Memory Usage

I currently have a sharded cluster up and running, and I have noticed that the memory usage of the primary member of each replica set is very high, it is 8GB although I started each member with the ...
0
votes
1answer
1k views

Why doesn't nodetool work on my Cassandra Cluster?

I have never been able to get nodetool to operate correctly to give me information about my cluster. We have a simple 3-node cluster of Cassandra 3.11.1 nodes running under CentOS 7.3 -- using the ...
0
votes
1answer
546 views

Best configuration of my.cnf for make fast Magento navigation

I have a Magento 1.7 version site with 7000 configurable products. Site navigation is slow. From the moment I click on a site link to when the address in the url bar changes several seconds pass. ...
1
vote
0answers
314 views

List Roles on cassandra getting NoHostAvailable on one DataCentre

I have a 2 DC cluster, 'main' and 'bi' with a replication factor of 3 and a NetworkTopologyStrategy. When I call LIST HOSTS; in cqlsh, my bi datacentre lists all the roles appropriately, but I get a ...
2
votes
1answer
1k views

Shrink ibdata1 and ib_logfile0

I want to reduce the size of the ibdata1 and ib_logfile0 files on my MySQL server 5.7. However, I do not want to activate the innodb_file_per_table option. What would be the best option to reduce ...
0
votes
2answers
257 views

mysql bad performance on hosting server

I have website running on a shared server and there are some moments that server is extremely loaded, I was able to capture some settings, could you guys take a look and maybe you see something really ...
1
vote
2answers
6k views

How to sync MySQL's time with system time without mysql restart?

On my machine I have a service to synchronise the SYSTEM time (including Time zone), and would like the DB will synchronize with the machine time once in a while. When I change SYSTEM time, MySQL ...
2
votes
1answer
507 views

is restart necessary after a config change in mongodb?

After a configuration change is it necessary to restart the db so that the new config take effect? The configuration was changed via this command: db.getSiblingDB('admin').runCommand( { ...
1
vote
2answers
2k views

Should I turn off GTID to fix this error?

Recently, a query has started failing. It is a query in the Magento software core (not a module) that Reindexes Catalog Search. I have receive the following error. Catalog Search Index index ...
0
votes
2answers
115 views

Firebird Configuration: firebird.conf Parameters Unit of Measurement

Many of the parameters in the firebird.conf configuration file are integers and I'm unsure what unit of measurement (KB, Byte etc.) is being used. For example, if tweaking the TempCacheLimit param, is ...
2
votes
1answer
50 views

Add database to availibility group [closed]

I have two replicas in availability group. Also I have additional instance instance3, with dummy databases that are not in availability group. As time has passed, some new things started to be stored ...
1
vote
0answers
46 views

How to save SSMS 2012 Object Explorer Scripting Settings?

I'm generating a bunch of object creation scripts in SSMS 2012, using the Object Explorer context menu. The default options for these generated scripts are not to my liking (for example, I want the ...
3
votes
1answer
302 views

How to enable CLR on a remote SQL Server?

I have been created a dll for SQL Server 2014 to add some custom functions for my stored procedures for my asp.net websites. I don't have any problem in the local server but can't enable the CLR ...