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
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
3k 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
588 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
374 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
281 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 ...
2
votes
2answers
7k 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
724 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
3k 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
125 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
51 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
48 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
327 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 ...
1
vote
0answers
84 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 = /...
0
votes
2answers
160 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
632 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
58 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
540 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
392 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
333 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
1k 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
603 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
9k 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 ...
10
votes
3answers
15k 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
626 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
593 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 ...
8
votes
1answer
5k 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
3k 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
514 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
147 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
210 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 ...
0
votes
1answer
230 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
305 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
793 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
187 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
75 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
236 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
366 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
15k 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
505 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
498 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
436 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
120 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 ...