Stack Exchange Network

Stack Exchange network consists of 175 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 results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [configuration]

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

1
vote
2answers
34 views

Can a user with readonly access change SQL server settings

Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings. In their query I can see this at the beginning: SET ...
0
votes
2answers
65 views

Configuring the max_connections setting in MySQL

I've gone through a number of docs and forums but can't quite find the right answer for how to determine the number of maximum connections I should set. I tried using MySQLTuner, that gave me: ...
3
votes
1answer
56 views

Are innodb_large_prefix and innodb_file_format settings backwards compatible?

I got the following message when I tried to install a piece of software trough the command line. I use a mySQL db. * innodb_large_prefix = ON is required. * innodb_file_format = Barracuda is ...
3
votes
1answer
78 views

how to prevent replication to stop if there is no activity for some time?

On one of my transaction replication publications, when there is no any activity, after some time, the replication stops. Where can I see these replication settings? what to put in place to prevent ...
0
votes
1answer
33 views

SQL Server Configuration on Multiple Instance Server

I have a 2016 Standard edition server with two instances. The server has 8 logical processors and 40GB memory (it's a testing server on hyper-v so the spec isn't high!) and it doesn't have any ...
0
votes
2answers
59 views

How to change the expiration date of binlog files?

I have a server with Ubuntu 18.04 and MySQL 8.0.11 I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate. How to change the expiration date of binlog files ? ...
8
votes
4answers
2k views

MAXDOP Settings for SQL Server 2014

I know this question has been asked number of times and also has answers to it but, I still need a bit more guidance on this subject. Below is the details of my CPU from SSMS: Below is CPU tab from ...
0
votes
2answers
88 views

Error: “temporary file size exceeds temp_file_limit”

My database is suddenly hanging on some queries that join many tables and I see: temporary file size exceeds temp_file_limit (1025563kB) A sample query and query plan can be seen here: https://...
10
votes
2answers
557 views

Limit max CPU usage SQL SERVER with WSRM

I have a physical server running one instance of SQL Server. I notice that quite often this server is running at 100% CPU usage. My IT team is not happy about this, and suggested we reserve 2 of the ...
0
votes
1answer
24 views

MySQL 5.7 to MariaDB 10.3.13 configuration overwritten - correct way

I have earlier MySQL 5.7 over Ubuntu 16.04 with following configuration in /etc/mysql/my.cnf. [mysqld] innodb_buffer_pool_size = 1228M innodb_log_file_size = 512M innodb_log_buffer_size = 16M ...
2
votes
0answers
41 views

Questions and advice for complying with Federal tax information (FTI) Security Guidelines for Federal, State and Local Agencies per Publication 1075

I've been able to find writings on compliance topics (e.g. HIPAA, SARBANES-OXLEY, PCI DSS) but I haven't found much on FTI (Federal tax information) and Publication 1075 outside of the IRS website ...
0
votes
1answer
16 views

Use data from Mysql to ElasticSearch with Logstash

I'm using logstash for use my mysql database in ElasticSearch My conf is the next. input { jdbc { jdbc_connection_string => "jdbc:mysql://[ip]:3306/nextline_dev" jdbc_user =&...
1
vote
0answers
40 views

What is the best option for a large slowly changing dimension lookup table

This question is an extension of a previously asked question Index Strategy and Query optimization, which further extends this question: Search between IP string addresses I implemented the two new ...
3
votes
1answer
113 views

What is the best index strategy or query SELECT when performing a search/lookup BETWEEN IP address (IPv4 and IPv6) ranges?

Question: Is there a better indexing strategy or query SELECT that I can use for looking up one large data set against another large data set? Or, should I look at placing the lookup dimension table ...
0
votes
1answer
26 views

how the mysql server settings replicatd in innodb cluster

I just started learning about cluster so I don't have much knowledge if question is not appropriate please forgive me. I have a 3 node InnoDB cluster running .suppose if I want to tune my server by ...
1
vote
2answers
46 views

What is the impact on the Cost-Based Optimizer (CBO) when implementing ISCSI SAN solid-state drives

A Microsoft Technet article recommends creating a secondary file group as the default file group (see reference below). The secondary file group should have a number of files, say four, that are each ...
0
votes
0answers
16 views

alwayson configuration

I am recently have a new project to implement AlwaysOn on 2016 SQL Server with two node synch/automatic failover for production Server. However, I need some recommendation on how can I implement that ...
0
votes
0answers
8 views

Why is Vertica Management Console reporting my TZ is not set

I am experimenting with setting up a Vertica Community Edition (9.2.0-0) cluster using three virtual machines. In the Vertica Management Console, when I enter my IP addresses and ask to "Validate Host"...
0
votes
1answer
25 views

Can MySQL show the respective timestamps in each INSERT output message?

For example, after an INSERT, I see: Query OK, 296 rows affected (0.02 sec) Records: 296 Duplicates: 0 Warnings: 0 I would like to see timestamps with these lines, if possible, e.g.: 2019-...
0
votes
0answers
54 views

Is it possible to queue PostgreSQL logical replication messages from multiple sources?

I want to use multiple "forward" PostgrSQL instances which serve distinct applications but share overlapping subsets of the same schema to update a single master which holds a full version of the ...
0
votes
1answer
35 views

PostgreSQL. Shared_memory and sessions

I have a standalone server which is running Jira and PostgreSQL 9.6. I have noticed that PostgreSQL has shared_buffers parameter is equal 128MB where RAM is 32GB. Because server is shared with ...
2
votes
1answer
42 views

What is the best type of account to use for SQL services? [duplicate]

We run stand alone instances all virtual. SQL 2012 - SQL 2017 Backups are performed by a third party tool so the server has no need to access anything on the network. Agent jobs are all run via ...
0
votes
1answer
41 views

What is the SQL Server cost, in terms of performance, of sharing physical disks?

I am an application user in Health Care. The application relies on communication with a large database, including image data and other large numeric arrays. We add approximately 15GB per day to the ...
1
vote
1answer
114 views

Splitting large database into smaller ones

Our system currently stores all customer (merchant) accounts in one "flat" MySQL (5.6) DB namespace. We would like to scale out better - we are considering breaking our data up based on the merchant ...
1
vote
2answers
114 views

SSMS does not open popup wizard to create a new schema

When I right click on 'schemas' and then on 'create new schema' my SSMS only opens the query editor but on every tutorial I saw a pop up wizard opens instead. How can I access this popup wizard? I can'...
0
votes
0answers
28 views

MySQL 8 using the wrong tmp directory

I have a query like so... INSERT INTO table3 SELECT DISTINCT * FROM table1 LEFT JOIN table2 on ... And it uses a temp table. The query runs for about 60 seconds, then starts filling /tmp even ...
1
vote
1answer
326 views

How can I disable parallel queries in PostgreSQL?

I want to benchmark some things in PostgreSQL. When I do this I normally turn off some of the features the database is currently using, just for my session, to see what the second-best plan is. ...
0
votes
1answer
44 views

How to restrict mySQL queries to not affect server and take it down?

There are times that some heavy queries increase server load and after sometime both CPU and Memory reaches 100%. This is my.cnf configuration file: [mysqld] expire_logs_days= 2 pid-file = /...
0
votes
2answers
36 views

Is there any Cross-platform SQL editors that allow joins from different databases?

Initially tried dbeaver but after configuring it, I realized that you can't perform joins from different data bases. Also tried TeamSQL which apparently does what I need but looks to be designed ...
0
votes
1answer
44 views

AlwaysOn Availability Groups on Secondary Replica

We have a Primary Server A with a Database. It has AlwaysOn ReadOnly Asynchronous which moves data to Server B. Out of curiosity, is it possible to place Server B on AlwaysOn and move it to another ...
2
votes
1answer
221 views

Proper Guidelines for new Database setup in SQL Server [closed]

I need proper guidelines to setup Database in SQL Server for sales Application (Its a huge Data Transaction System). Specifically i'm looking below information: How to define initial size to create ...
0
votes
0answers
33 views

Reporting server configured in a separate Web server

I am new into configuring Reporting server and I did install and configured reporting server in a separate app server (lets say on app-01). I have my database server running on a separate server, sql-...
0
votes
1answer
34 views

Best mysql config for my server

I have dedicated server, CPU is too high (80%-100%) and memory only use 9gb RAM 32 gb and CPU Dual Xeon E5-2670(8core and 16 thread) I have 25000 users that use my android application My database ...
1
vote
2answers
74 views

MySQLTuner request - high CPU problems

I've been running a pretty high pop website for a few months new and as its growing we've been having some problems lately. Its a 2 core Xeon, 8GB, SSD server. We're pulling +- 150k people a day. ...
1
vote
1answer
29 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
95 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
1answer
76 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
42 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
104 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
99 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
145 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
206 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
351 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
84 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
765 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
1k 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
77 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
34 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
595 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
322 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 ...