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
2answers
2k 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
633 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
586 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
291 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
122 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 ...
3
votes
1answer
750 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
659 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
520 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 ...
1
vote
1answer
669 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 ...
3
votes
2answers
2k 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
597 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
2k 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
289 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
470 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 ...
1
vote
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
355 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
583 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
73 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
354 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
9k 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
453 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 ...
5
votes
1answer
7k 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 ...
15
votes
1answer
14k 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
420 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
vote
0answers
1k views

Implementation steps for adding database to an Availability Group

I created implementation steps with fallback plan to add a database to an existing Always On availability group.Can someone please take time and go through the steps and let me know if this ...
2
votes
1answer
732 views

how to temporarily change the sql server settings in order to do a task and when finished revert back?

when I run the script below all at once I get this error message: Msg 15281, Level 16, State 1, Line 58 SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc ...
2
votes
1answer
582 views

All Flash Storage Configuration

Our co is getting a new SAN with all flash storage which would be attached to a physical 8 core 48 GB RAM server. I have been studying what is the best way to configure this setup. Our DB has mostly ...
1
vote
1answer
10k views

replicate-ignore-table setup and usage for excluding table from binlog backup

I need to make an everyday backup of a mysql database that is very big on a remote server and I only want to get the difference since the last backup. I also need to exclude some tables from being ...
0
votes
2answers
7k views

Net Configuration Assistant doesn't open, created Listener in Net Manager but it isn't recognized when creating database Win 7

I have installed Oracle 11g on my Windows 7 64-bit system. The Net Configuration Assistant does not open for me to create a listener. I was able to add a listener through the Net Manger and it says it ...
1
vote
2answers
527 views

SQL Server Service Account Configuration - one account per Server? [duplicate]

Planning to re-create new service accounts for our Sql-Servers, I wondered if - from a security perspective - it maybe better to have one domain account per Service and per Server or to create one ...
1
vote
0answers
78 views

Will Peer to Peer replication still work with RPC out disabled?

PCI Compliance is failing due to "Microsoft SQL Server Database Link Crawling Command Execution" There is no solution available however they recommend a Workaround: Disable RPC_Out and xp_cmdshell ...
-1
votes
1answer
18 views

MySQL Database with one user for Analysis only

I'm working at a research lab and was given a project that runs a bunch of scripts against a dataset that's not huge, but starts to get weird as the scripts create more tables. I could re-write a lot ...
1
vote
1answer
1k views

what is causing my windows page file to grow?

I have one of my production servers that has a windows page file of over 32 GB. The server in question has 32 GB of RAM, windows server 2008. It is exclusively used for Sql Server. Nothing else. ...
1
vote
2answers
1k views

is there a rule for the size of the page file on dedicated sql server servers?

Hi All, We've been investigating further into the C: disk on my_server in regards to the low disk space. We can see that there aren't many files that can be removed in order to free up ...
2
votes
0answers
73 views

Update the current session's default parameter value to reflect a new default

Say I ALTER the database default search_path to include a new schema: ALTER DATABASE my_db SET search_path TO "$user",public,other_schema; Then I also update the current search_path to match: SET ...
1
vote
1answer
2k views

Reset search_path to the global, cluster default

Say I permanently alter my database's search_path like this: ALTER DATABASE my_db SET search_path TO "$user",public,other_schema; How can I reset it back to whatever the default that a pristine, ...
0
votes
1answer
139 views

Blitz procedure failing [duplicate]

When I run the latest version of sp_blitz I get the following: Warning: Null value is eliminated by an aggregate or other SET operation. Msg 1934, Level 16, State 1, Procedure sp_Blitz, Line 3467 ...
0
votes
1answer
137 views

how to force postgresql to filll work_mem?

i'm currently investigating a situation where my PostgreSQL 9.3 instance was killed by the Linux OOM Killer and went to recovery mode. The machine is EC2 Server with 16 GB of RAM and has rather few ...
1
vote
2answers
1k views

Determine ANSI_DEFAULTS setting ON or OFF?

How can I determine if ANSI_DEFAULTS is enabled or not on my server. My server is using IMPLICIT transactions and one way from which it can affect it based on setting of ANSI_DEFAULTS. How can I ...
2
votes
1answer
1k views

Is there any impact to changing IP address of MySQL Server?

We are changing the network and the IP addresses will be changing. Will there be any impact to MySQL running on the server? I don't use the IP address to reference the server. Instead I use the ...
0
votes
1answer
115 views

SQL Server 2014 login issue

I have a login issue here. I created a new user login in SQL Server 2014. I tried to connect to my database using this new login and the below error pops up Message Error: 18456, Severity: 14, ...
0
votes
1answer
26 views

Is there any database system that allows to have different schemas for different users but the same content for all users?

In my fantasies, it looks something like this: User 1: SHOW TABLES; +-----------------------+ | Tables_in_my_database | +-----------------------+ | table_1 | | table_2 | +...
3
votes
1answer
2k views

MySQL is using swap memory while I have plenty of free RAM

I have a 6 GB buffer pool size for my database; however, mysqld process is moving to swap while there is plenty of RAM available. I think pool size and pages along with pool of reads and pool of read ...
2
votes
1answer
200 views

Error When Trying to Run MDW Data Collector

I have SQL Server Management Data Warehouse (MDW) set up across multiple instances, all in the same way with the same accounts and permissions. On one server I get an error when trying to run the ...
-1
votes
2answers
46 views

Always On Stand Alones

Can I add a Stand Alone instance to a Windows Failover Cluster for Always On set up? I need to have one secondary synchronous replica with automatic failover.
1
vote
1answer
251 views

Download the replication snapshot file using FTPS

I have two databases for two companies. Company A's database contains domain data. The other company is pulling the data using snapshot replication. We have used FTP to communicate: Created FTP ...
0
votes
1answer
85 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
1answer
93 views

What is the significance of phpMyAdmin's configuration storage and what should I know about it?

After initializing phpMyAdmin on my server, I created a test database in the GUI platform. I realized that I had then received a notification in the phpMyAdmin browser that I needed to set up an ...