Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
264 views

1 out of 3 Transactions in DB2 fail with SQL 998, State 58005, error code 8, sub code 2

We have a few back-end applications using an XA switch module connected to a DB2 (10.5). 2 or 3 transactions will pass until this shows up: I’ve found this document that talks about “Code 998, state ...
3
votes
2answers
2k views

Bind MongoDB to IPv4, as well as IPv6

Mongo v. 3.4 respective part of config file: #network interfaces net: port: 27017 bindIp: 127.0.0.1,192.168.0.15,2001:db8:0:0:0:0:2:1 (IPs are made up) No matter the format I've used: [2001:...
1
vote
1answer
330 views

sync_binlog different for master and slave

Is it fine if sync_binlog is different for master and slave? For my system I can see master has sync_binlog=1 and slave has sync_binlog=0.
2
votes
1answer
853 views

Named instance configured on dynamic default port

I was recently asked to take a look at at some SQL Servers for a friend and carry out a few config and security audits. There were a couple of servers belonging to the same application group which ...
1
vote
1answer
1k views

Unable to access SSRS web URL outside Azure VM

I've configured SSRS in SQL Server 2016 on Azure VM. However I am unable to access the web URL outside of the VM. Since it is my test box I've tried disabling the firewall as well. Still didn't help. ...
1
vote
2answers
226 views

reducing migration time of a large size postgresql database

We have a postgresql 9.4 DB server that handles 2 DBs, each ~800GB. No replication is implemented yet. We reduced pg_dump time with using -j & -Fd options to about 2 hours. The problem is, we ...
3
votes
2answers
261 views

SQL Server 2008 Authentication mode changed on its own

This morning we experienced an issue where our production server seemed to decide to change from Mixed authentication mode to Windows only authentication of its own volition. I was curious to know if ...
0
votes
0answers
380 views

Change Port numbers on multiple instances in SQL server 2016 failover Cluster?

Can any body tell me the process to change Port numbers for SQL server 2016 (Default 1433), there are any difference between failover Cluster and Standalone environments? I want to know in SQL 2016 ...
3
votes
3answers
17k views

MySQL on MACOS Sierra secure-file-priv setting

I cannot find where to set secure-file-priv. I get this message: 1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement when running this ...
3
votes
2answers
1k views

SQL Server 2014 Standard Ram and CPU [closed]

I've got a VMWare VM that runs Windows Server 2012 R2, SQL Server 2014 Standard Edition, IIS (hosting custom web application), and SentryOne Monitoring. The VM is configured with 4 cores and 128GB of ...
1
vote
1answer
544 views

Can we use VMDK for FCI on SQL Servers?

Can I share a VMDK among 2 nodes for an active passive setup for a SQL Server Failover Cluster setup? Most of the articles I see mention to use RDM's, however we use Veeam backup for the environment ...
0
votes
2answers
542 views

Simple, small table (5000 rows) with around 2% slow queries, with high table lock time - context_voluntary and block_ops_out

I am running MySQL version 5.1.69 and the tables in question are MyISAM. I have a very simple table: CREATE TABLE `tbl` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `otherID` int(11) NOT NULL, `...
1
vote
1answer
523 views

Allocation Size for Backup disk on SQL Server

What would be the optimal allocation size for a backup disk for SQL Server? We have a 2014 instance which was using Veeam backups till recently, but we decided to switch to local backups again for ...
0
votes
1answer
166 views

SQL Server Partition - File Placement

According to Microsoft best practices you can optimize SQL and take a lot of benefits by using this technique, my only question is how to correctly install the SQL Server to match the drives/paths ...
0
votes
1answer
47 views

In what file does SQL Server Store the configuration data?

Where does SQL Server 2014 store the configuration data? Such as the certificate references for SSL and the size limits and allocations?
2
votes
1answer
619 views

CLR and where to store config values

I am looking to replace some hard-coded values in CLR code (SQL 2012), I came across the use of config files here - https://stackoverflow.com/questions/16177769/assembly-configuration-clr-stored-...
4
votes
1answer
536 views

Optimizing MySQL 5.6 for unit tests

We have a MySQL instance for unit tests. Our unit tests work very heavily on MySQL. Therefore, we put /var/lib/mysql dir in tmpfs file system because we don't need persistent data in unit tests. Our ...
0
votes
3answers
2k views

optimize mysqldump for approx. 20GB databases for 8GB RAM

MySQL server having following specifications: 8GB RAM Data & Index of size 49.64GB Dump file size is 17.24GB(18512936320 Bytes) CPU: Processor: Intel(R) Core(TM) i5-3330 CPU @ 3.00GHz ...
3
votes
1answer
495 views

NUMA configuration

We have clustered servers, each of which has 32 CPU cores and 512 GB memory. The cluster is home to 7 instances of SQL Server 2012 Standard Edition. With Standard Edition allowing a maximum of 64 ...
1
vote
1answer
403 views

Setting the right Max Server Memory value on an Active/Active SQL Server Clustered Environment

I have looked around in the dba stack exchange and have not being able to find an answer to this one, so here it goes my concern. Hopefully somebody has done some research on it and can provide an ...
0
votes
1answer
100 views

Fileshare witness for Multisite AvailabilityGroup setup

If I am having a multisite AG with 2 nodes in the primary datacenter and 2 nodes in the DR - Where can I place the quorum for its continuous availability? I am assuming a 3rd site - but my management ...
0
votes
1answer
1k views

Getting PAGELATCH_UP:tempdb:1(PFS) with so many waiting queue [closed]

Getting PAGELATCH_UP:tempdb:1(PFS) with so many waiting queue. What can be solution? We have two hexacore processors. Ideally how much tempdb can we create to handle this issue?
0
votes
1answer
399 views

Memory speed vs. amount [closed]

I just got talking to DBA as he asked me: What's best, memory speed or memory amount, e.g. 512GB @ 1866MHz or 768GB @ 1333MHz, when running the database in-memory? We've both been looking for stats, ...
0
votes
1answer
432 views

GFS2 as shared storage for MySQL cluster with active active setting

I am using MySQL 5.7 on RHEL 7.1. For cluster management I am using Pacemaker and corosync. For shared storage, I am using GFS2 file system with iSCSI server I am trying to implement MySQL active-...
2
votes
2answers
3k views

How can I remove a channel from replication slave?

Today my question is about MySQL replication cleanup. I used mysqldump with the --master-info --all-databases tag and restored it to a new host to be used as a replication slave. After restore, I ...
6
votes
2answers
780 views

Seperate volumes for tempdb, data, and backups on SQL Servers in VMs

When configuring new SQL Servers on VMs, it is a good idea to have the Database, TempDB, logs, and backups on separate logical drives, even if the underlying storage is the same? I know that this is a ...
0
votes
1answer
651 views

Availability groups NIC best practices

I am planning to build a new AG setup in my QA environment with the following configuration. What I want to know is, can I have 2 heartbeat networks between the nodes for redundancy also, how many NIC'...
0
votes
1answer
324 views

Create log file with SQL statements for only one database

I have two Postgres databases. Can I write in a log file SQL statements only for one of them?
1
vote
1answer
148 views

Configure SQL Server to associate a user login with a specific port

We have SQL Server instances that sit in our DMZ, and associated firewall rules to allow access to them from our corporate network. The server is correctly listening on the configured ports, but now ...
5
votes
1answer
934 views

Why is Postgres not respecting my log file name convention dictated by “log_filename”?

I’m using Postgres 9.5 on Ubuntu 14.04. I have these settings set in my /etc/postgresql/9.5/main/postgresql.conf file log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, ...
0
votes
1answer
927 views

How to know if mysql tmpdir is being used

I set my MySQL tmpdir setting to use /run/mysqld which is a tmpfs, however while running a query I know copies data to a temp table (which takes 5-6 seconds based on MySQL's INFORMATION_SCHEMA.PROFILE ...
0
votes
1answer
585 views

Adding secondary replica from different subnet for AlwaysON

If I understood the configuration of setting up a multi subnet AG setup where 2 nodes are in one datacenter and the 3rd node in another, I was under the assumption that we require 2 listner ip's - 1 ...
2
votes
1answer
1k views

Values of created_tmp_disk_tables increases

I noticed that the values of Created_tmp_disk_tables increased. At a certain time, MYD files are created in /tmp directory and my site run very slowly. I am forced to restart the mysql service to ...
4
votes
2answers
3k views

SSDs and 64K sectors

SSDs tend to have a natural 4K sector size as far as I know, but would it be beneficial to format Windows cluster size at 64K? This is good practice for spinning rust, but is it relevant on SSDs?
0
votes
1answer
654 views

Always on without Listener IP

I joined a new company this week where I noticed that one always on setup has listener ip configured, while the other doesn't. For the AG setup which doesn't have the listener in it, will the ...
3
votes
1answer
3k views

Can't stop “SQL Server Polybase Data Movement”

When I start Windows the "SQL Server Polybase Data Movement" service is in the "Change pending..." state and I can't close it. When I try to stop it mmc crashes. In Windows services, the status = ...
1
vote
0answers
306 views

Setting drive Allocation unit size in virtual envionrment

Environment details: One physical host disk (RAID 10) Multiple virtual servers of varying types (app, web, SQL, file) all using same host disk using Hyper-V Questions: Is it still beneficial to ...
1
vote
2answers
1k views

If shared memory, named pipes, TCP/IP network protocols are all enabled which has priority?

If you have all 3 protocols enabled in SQL Server 2016, which protocols are prioritized on the server instance? Couldn't find any specific documentation on this and don't really understand how it ...
1
vote
1answer
521 views

Resource semaphore query compile waits

We have migrated SQL Server Standard Edition from 2008 R2 to 2014. After the migration, we are seeing a huge amount of blocking, and overall the instance is very slow. The major wait we are seeing is ...
2
votes
1answer
1k views

How to set 'timing on' permanently in PostgreSQL?

I work with PostgreSQL in the command line interface. I would like to activate a \timing command permanently for every database in the cluster so every time I connect to a database - this parameter is ...
9
votes
4answers
412 views

bug in database_scoped_configurations

I'm trying to insert the result set from: SELECT * FROM sys.database_scoped_configurations into a temp table, because I want to check the settings for all databases on my server. So I wrote this ...
2
votes
1answer
722 views

MySQL - huge Dictionary memory allocated

Our MySQL 5.5.38 servers have 1000-3000 InnoDB databases each (with about 100 tables each). All data is in single file. Most of DBs are active. While it's expected that information schema should be ...
1
vote
1answer
78 views

What MySQL configuration options require more than editing the my.cnf file and restarting the server?

One example of this is the innodb_log_file_size configuration option. As discussed here, there are a series of steps that starts an hour before shutdown and goes to after shutting down. However, this ...
1
vote
0answers
2k views

Set secure_file_priv=NULL in MariaDB

In order to secure my server, I'd like to set: secure_file_priv = NULL As per MySQL's docs - http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv If set to ...
1
vote
1answer
362 views

SQL Server Agent properties

I have several dozen servers and would like to be able to check configurations on them ever quarter or so to make sure nothing has changed. I am having difficulty finding how to read a few ...
3
votes
2answers
12k views

How to define custom path to MySQL socket file?

I have following config [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql-socket/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=...
0
votes
1answer
575 views

Implenting Min Max memory configuration in Alwayson [duplicate]

I have never changed this setting for an AlwasyOn setup. What is the best practise to do this? Should I change the setting on the Secondary node first and then the primary? Please suggest . The ...
6
votes
1answer
9k views

How to check the syntax of pg_hba.conf and other postgresql conf files on ubuntu/debian/linux?

Many times, the postgresql service can't restart after some configuration changes. Is there any command line tool allowing to check the syntax of pg_hba.conf and other pg *.conf files before ...
18
votes
1answer
19k views

Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file

Default values are, according to documentation for min_wal_size and max_wal_size parameters: For max_wal_size: The default is 1 GB For min_wal_size: The default is 80 MB Then I look this parameters ...
1
vote
0answers
456 views

mysql not able to connect to socket

I am not able to connect to my mysql (mariadb to be specific) via phpmyadmin, it seems there is some issue with my socket or port it tries to connect to. At first, mysqld is running and I am able to ...

1
3 4
5
6 7
12