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
0answers
80 views

Specific install of MySQL 5.6

I'm download this version mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz. I would like to make a specific install for example : basedir = /sgbd/mysql/5.6/mysql datadir = /data/mysql/MYSDTESTP02 socket = /...
1
vote
2answers
130 views

NTFS Filesystem Fragmentation issue occur after migrating mysql 5.6 database to mariadb 10.2

I am currently experience a novel issue with a previously fine running database server. For a second time within 8 weeks, the current running MariaDB 10.2.7 has been corrupted due to Operating System ...
7
votes
1answer
1k views

SQL Server detected 2 sockets with 4 cores per socket but only one NUMA node

We have a SQL Server 2012 SP 2 CU 8 instance in a VMWare host. The operating system is Windows Server 2012 R2. Windows Task Manager says that we have two sockets and 8 virtual cores. This number ...
1
vote
2answers
543 views

MySQL 5.7 performance issue with 300 GB Innodb [closed]

We have a database running on MysSQL 5.7. The database size is around 300 GB, running on a dedicated Linux server (RHEL 6) with 144 GB RAM, 16 CPUs and 15 GB swap size. The server is busy throughout ...
0
votes
1answer
53 views

ssrs how to make the report available to my local machine

I have been struggling in Configuring Report Server URLs for a certain reporting services server. when I am in the server itself, the url works fine as you can see on the picture below. but trying ...
5
votes
2answers
437 views

1000 MB vs. 1024 MB

Is there any authoritative documentation regarding whether 1 GB = 1000 MB or 1024 MB in reference to 1 ) disk space and / or 2) RAM? Based on my research the "official" breakdown of 1 GB used to be ...
1
vote
0answers
338 views

how do I set the compression level in tokudb

Tokudb has various algorithms, lmza, zlib, zstd etc. These algorithms have the ability to be configured. In that, you can set the compression level to a value between 1 and 10 depending on the ...
1
vote
1answer
283 views

ip address record in sybase ASE auditing database? [closed]

everone. I installed the sybsecurity database for auditing in sybase ase 15.5. The installation is OK. I configured the audit commands, for example, for auditing the sa user, and other users of the ...
3
votes
0answers
947 views

There is insufficient system memory in resource pool 'default'

I'm running SQL Server 2016 and I'm getting this error: There is insufficient system memory in resource pool 'default' ...when running batch queries with millions of rows. I decreased the batch ...
9
votes
1answer
584 views

Will Changing the Max Memory Setting Invalidate Query Plans?

I recently lowered the max memory from the default (unlimited) down to 20 GB. Does this erase the oldest queries in the plan cache?
16
votes
5answers
8k views

SQL Server Error 8632 due to over 100,000 entries in WHERE clause

My problem (or at least the error message) is very similar to query processor ran out of internal resources - extremely long sql query. My customer is working with an SQL select-query, containing a ...
9
votes
2answers
13k views

Use Dark Theme on SSMS Results Grid, Object Explorer and other windows

There are several ways to use a Dark Theme on SSMS main coding window, either importing a vsettings file, applying Dark Theme that is disabled on a config file or doing it manually. But all those ...
0
votes
1answer
564 views

Optimise Percona 5.7 my.cnf for a 32GB mixed nginx/php/mysql server

I have a dedicated server which I run my website from. It's got 32GB of ram, Xeon E5-1650 3.2Ghz (6 core, 12 with HT) and two 3TB drives in RAID 1. I'm running Percona 5.7.18 99% of my tables are ...
1
vote
1answer
486 views

SSAS and SQL Server optimal settings

I have 4 cubes running on the SSAS server. The CPU seems to peg and we had memory issues with the 4th cube during loads. We have 4 CPUs with MAXDOP set at 2, cost threshold for parallelism = 70. We ...
4
votes
1answer
2k views

how to query the plan cache to find how healthy it is?

This morning looking at my monitoring tool I get a warning about High Compiles Query plan compiles should generally be <15% of batches per second. Higher values indicate plan reuse is low, and ...
6
votes
1answer
4k views

Postgres seems to ignore listen_addresses setting

I'm trying to DISABLE remote client access on my Postgres 9.5.7 database (running Ubuntu 16.04). I made what I thought are the correct changes (see below) to no avail. I can think of two reasons why ...
1
vote
2answers
2k views

What is an example of an extproc.ora file?

What do the contents of extproc file look like? I'm aware that my extproc.ora file is missing, and I'd like to create one in it's absence. The instructions here tell me to: Configure the Oracle ...
4
votes
1answer
432 views

Finding what the source of a specific PostgreSQL configuration setting

If I get it right, settings are hierarchical: postgres.conf-> postgres.auto.conf (ALTER SYSTEM)-> ALTER DATABASE(where applicable)-> ALTER USER(where applicable)-> SET SESSION(where ...
-4
votes
1answer
6k views

Create more mongodb concurrent connections

We are using mongodb 3.4.5 version I would like to use more concurrent connections. Available connection showing 8 lakhs but the connection establishing is 100 by 100. For example,if we create 20,000 ...
4
votes
1answer
132 views

Lost persistance in long term in redis without TTL

Our keys are lost in some time and we cannot find the problem. We are using AOF and RDB at the sametime with configs below: RDB: save 900 1 save 300 10 save 60 10000 stop-writes-on-bgsave-error yes ...
1
vote
2answers
177 views

Mysql configuration and power failure

I'd like to know if there are certain configurations of Mysql that should be considered to keep the effect of the power failure as low as possible. Which configuration points should be noted and what ...
1
vote
1answer
186 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
293 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.
1
vote
1answer
705 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
164 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 ...
0
votes
1answer
69 views

Frequent Corrupt Indexes in MySQL 5.6. Is this a MySQL bug?

I´m having problems with mysql indexes with INNODB getting corrupted. Initially I solved it by rebuilding the tables but now the tables are to large to rebuild, and i´m tired of mysql not showing ...
3
votes
2answers
213 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
357 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 ...
1
vote
3answers
13k 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
467 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
440 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
349 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
100 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
46 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
489 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
410 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
1k 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 ...
2
votes
1answer
459 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
267 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
92 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
337 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
360 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
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
611 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
581 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
674 views

Synchronize between two elastic-search for redundancy [closed]

I am new to all the DB and therefore also to ElasticSearch. I got a project where I have to connect two Elastic Search DBs from two different IPs for redundancy. I searched google and https://www....