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
1answer
39 views

How to properly configure my.ini for MySQL? [closed]

I've just installed on my new server MySQL 5.0.24 64bit (till now i've used same version of MySQL but 32bit on another server), on the old server i've changed in my.ini the parameters of ...
0
votes
0answers
14 views

How to set the view format of pgAdmin4's query results?

I'm learning to use pgAdmin4 in my work, but the query results are hard to be read since every columns are too long. For example, there is a column in a query result, whose type is double. In fact I ...
0
votes
1answer
16 views

Why doesn't MariaDB server recognise Server Audit settings in config file?

I'm trying to implement the Server Audit plugin that is built-in with MariaDB 10.4. I've added the settings to the my.ini config file, running on Windows 10. [server] ... #Audit Settings ...
1
vote
1answer
31 views

Should a local account be set up and used solely to install SQL Server?

I'd like to follow best practices. However, is it overkill to create a new local user account (with minimal access and no special rights) and then use that account to install SQL Server? Are there ...
1
vote
3answers
82 views

Sql Server replication: Initial snapshot for publication is not yet available?

I had setup transactional replication and my distributor, publisher are on same windows server and 2 subscriber one on same server and another on other windows server both using push snapshot. I am ...
0
votes
0answers
20 views

How to configure MYSQL 8 as case insenstive on ubuntu 19.10

I am using MySQL 8 in ubuntu 19.10 and I want to set lower_case_table_names = 1 in /etc/mysql/my.cnf file. But after adding this line server fails to start. I have followed various solutions like ...
2
votes
2answers
110 views

MySQL Tuner returns: MySQL's maximum memory usage is dangerously high

Can someone help me optimize my MSQL configuration. I run Zabbix and Grafana on a Ubuntu 18.4. MySQL Tuner shows me that my memory usage is dangerously high, but when I use the free command it shows ...
0
votes
2answers
65 views

Why SQL Server port number is not default 1433?

Installed latest SQL Server. It is listening on port number 62628 according to server log. Why is the port number is not the default of 1433? How to change the port number back to the default 1433? ...
1
vote
1answer
102 views

Using NUMA Nodes with SQL Server

I have a question to understand better how NUMA nodes help in SQL Server: In our current set up, we have 4 NUMA nodes with 20 cores and hyper threading enabled, making a total of 40 logical ...
0
votes
1answer
33 views

How to get the settings associated with a stored procedure in relation to filtered indexes?

I quite like using filtered indexes in the proper context. I have added the following filtered index: USE [COLA]; CREATE UNIQUE NONCLUSTERED INDEX F_InterviewReport ON [dbo].[...
0
votes
2answers
25 views

What triggers the SSRS to generate a log file or modify a current one?

When running a trace on my new SSRS Reporting Services 2016, after troubleshooting some problems related to migrating from SSRS 2008, I find the following pattern running continuously: Here is the ...
1
vote
2answers
242 views

PostgreSQL: Allow connection by host name and not IP?

As background when connecting from remote (eg home mostly using JDBC) due to how the VPN works I always get a different IP address and hence I can't connect because the IP isn't listed in pg_hba.conf. ...
-1
votes
1answer
24 views

MySQL - Which options in the configuration file have an impact on memory usage?

I've been wondering how to manage MySQL memory usage since by default it takes up to 350MB while idle on my machine, I don't have memory issues, I honestly just wondered how could it be done. I found ...
2
votes
2answers
60 views

Less obvious “The table 'mytable' is full” error

Error in mysqld.log: 2020-02-02T01:17:32.133974Z 3069 [ERROR] /usr/sbin/mysqld: The table 'IS_DUT_IFID' is full None of the many threads I've found about this error have helped me to resolve this ...
1
vote
1answer
187 views

Setup innodb_io_capacity

I want to configure the innodb_io_capacity option for my MariaDB server. In the documentation I found the following: Faster hard drives, RAID configurations, and solid state drives (SSDs) benefit ...
0
votes
1answer
652 views

mongodb conf node won't start - compatibility error

I recently upgraded a dev sharded-cluster from 3.6 to 4.0 - one of the conf servers is now failing to start: 2020-01-30T13:19:02.972-0600 F CONTROL [initandlisten] ** IMPORTANT: UPGRADE PROBLEM:...
1
vote
0answers
46 views

Why my Oracle 12C is allowing me to a connection creation without passing network security and integrity parameters

My Integrity settings Oracle Net Manager are: -- Integrity for - Server Checksum level - REQUIRED Selected Method : SHA1 -- Integrity for- CLIENT Checksum level - REQUIRED Selected Method : SHA1 ...
0
votes
0answers
58 views

How to handle spoon err: Permission Denied in Redis

I'm new to Redis and I'm facing this error on Windows 10 Pro (64 bit) when trying to do the background save of Redis: [14932] 18 Jan 10:57:24 # Failed saving the DB: Permission denied [14932] 18 Jan ...
0
votes
2answers
571 views

Best Practice for Oracle SGA and PGA Memory Components Size

I have a Server that has 128GB RAM. I have read here and there that the size of SGA + PGA can bee 80% of the RAM. I wonder if there is any best practice for this configuration that could allow Oracle ...
0
votes
1answer
191 views

Patroni with etcd starting up

I have an existing PostgreSQL cluster v11.5 with streaming replication. I want to set up high availability managed by Patroni. I installed Patroni on both machines, I set up an etcd cluster on three ...
0
votes
2answers
54 views

How to speed up full text query on a table with 4 million rows? (MariaDB)

I have an InnoDB full text table that serves the ajax-powered searchbox at the top of my website. I generate it with a daily script that pulls data from a dozen entity tables on the site, and ...
0
votes
1answer
68 views

Can we replicate or restrict specific databases in MongoDB

In MySQL, we are having replicate-do-db/replicate-ignore-db during replication, where we can replicate or restrict specific databases from Master to Slave. In the similar way, is there any specific ...
0
votes
1answer
57 views

MariaDB pegging cpu at 100%, need some help please

I am having issues with a server and have had issues for awhile but finally getting around to trying to fix it. When I run top, I see that 1 of the cores is near 100% and it usually never drops below ...
0
votes
1answer
186 views

How to change results cell padding in Azure Data Studio

In Azure Data Studio, I am trying to change the padding on the cells in the results grid. According to the settings page, this is editable in the settings.json: However, when I navigate to that file ...
0
votes
1answer
208 views

Postgres pg_read_all_stats default role cannot read from my schema

I have a postgres user created with the pg_read_all_stats default role permissions which states the user should be able to read as if superuser. This works fine for any of the pg_stat_* tables. ...
2
votes
2answers
747 views

Best approach for moving tempdb .ndf files

During a SQL Server installation, I "thought" I specified location of tempdb on 'F:' and not 'C:', but I can see that although tempdb.mdf and templog.ldf are on 'F:', the 3 .ndf secondary data files ...
2
votes
1answer
131 views

what could be preventing my transaction log autogrowth to be set to UNLIMITED?

I have been trying to set the autogrowth of one of my databases to unlimited but despite whatever I do it remains the same. First thing I have checked if something is holding any locks to my database:...
1
vote
2answers
59 views

Different Maximum server memory across Availability Replicas

I have a scenario in SQL Server 2014 AlwaysOn High Availability where other services are running in one of the Secondary read-only replicas. These services obviously demand additional memory. Is ...
19
votes
2answers
2k views

Which collation should I use for biblical Hebrew?

Which SQL Server collation should I use for biblical Hebrew? The database under consideration needs to accommodate diacritics (i.e., vowels, accents, trope, etc.).
0
votes
2answers
23 views

Postgres lowering max_connection

I have a question regarding max_connections in postgresql.conf. In the Postgresql documentation, it says it determines the maximum number of concurrent connections to the database server. Does it ...
0
votes
1answer
56 views

Scaling Users in MongoDB

Our team has been tasked with a fairly open ended request for a MongoDB with multiple users that can access and submit documents to collections for a graduate class. The team is all new to MongoDB and ...
0
votes
0answers
18 views

How to increase idle time of “LaunchPad” for SQL Server external scripts?

sp_execute_external_script can take a while to initialize when not run for a short time. How do I set the idle time on the controller Launchpad process to keep it from shutting down too soon? Note I ...
1
vote
2answers
69 views

Mysql Config Suggestions - CPU too high

My server (64GB,16CPUs) has mariadb 5.5.60. The queries are around 500 selects /second and 300 inserts/seconds. The queries are simple select of auth token and user details. Both are properly ...
2
votes
1answer
196 views

How to remove Alter, Drop, Create SQL from deployment script created in VS 2015 using SSDT 14.06

I need to remove the below auto-generated deployment script for my SQL project. I am using VS 2015 with SSDT 14.06. Would this be something that can be set in the Advanced Deployment settings under ...
2
votes
1answer
128 views

How to set a correct value for wiredTiger concurrentTransactions

I have a single instance in server with 7 Processor and 15 Gb. In value default for wiredTigerConcurrentReadTransactions and wiredTigerConcurrentWriteTransactions is 128. But is value default, how to ...
3
votes
1answer
319 views

AWS aurora (postgres) proper value for the shared_buffers parameter

I think it's fairly well known that a normal PostgreSQL database has a starting value of 25% of system memory for its shared_buffers parameter, but I haven't been able to find anything regarding a ...
0
votes
1answer
41 views

How to change the reporting services report service mode from Native to integrated?

In SSRS-2016, I am trying to change the Reporting services report service mode from Native to integrated. I added 2 new shared features to existing installation (See in the Pic) I am trying to ...
0
votes
0answers
11 views

Cassandara ec2 Number of Nodes and autoscale for increasing 70Gb of Data

I am beginner in Cassandra, I currently have 72 GBs of Data that is growing and i will have approximately 1gbs inserted into database daily. How can i decide number of nodes in the cluster and how ...
1
vote
0answers
21 views

Impact of changing server machines names with SQL Server 2016 Standard in mirror state

It's an enterprise network domain. Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
1
vote
0answers
31 views

Not able to update innodb_ft_num_word_optimize

We are using a AWS-RDS(MySQL 5.7) instance with 16GB RAM. We have a table with millions of entries and a FULL-TEXT index which needs to be OPTIMIZED. Apparently, FULL-TEXT optimization is very ...
0
votes
0answers
122 views

How to set psql command line arguments in a sql script?

The broad question is can you set psql command line arguments within a sql script? Something simliar to SET In particular, Postgresql psql has a -S option, which turns on --single-line. According to ...
0
votes
0answers
57 views

Setting up TempDB for more than one instance of SQL Server

I've been given the task of transferring the contents of a SQL Server instance from one Windows server to another Windows Server. One of the many things I need to do on the new server is set up the ...
0
votes
1answer
32 views

MySQL server upgrade, how to adapt variables?

I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
1
vote
1answer
108 views

SQL Server Security - Encryption [closed]

I have requirement to store the some sensitive information in SQL Server 2016. Organization policy demands, it should be encrypted. Business Requirement: Data cannot be decrypted by DBA. Data cannot ...
0
votes
0answers
58 views

Configure MSLocalDB in a .NET config file

I have created a .NET Standard C# project and a SQL database in my LocalDB server (LocalDb)\MSSQLLocalDB. I have tried to configure the connection string in the project web configuration file but in ...
0
votes
2answers
502 views

Max Connections Maria DB

Every time I reboot Mariadb places me the max_connections in 151 and in the my.cnf I have it with 300. Why does this happen?
0
votes
1answer
77 views

Setting up SQL Server Developer Edition

I just installed SQL Server Developer Edition and SQL Server Management Studio, how can I configure the server? I want to configure it to have server name localhost-sql-server, with a login/password. ...
0
votes
0answers
27 views

Why is turning on Event Scheduler Maxing my CPU?

I have search the web for the last week trying to figure this out. I have exported my tables and events, re-installed the lastest MySQL and imported. I have tried checking individual procedures. My ...
0
votes
1answer
944 views

wal_level both hot_standby and logical

I have a PostgreSQL setup with one master and three slaves. It's configured as streaming replication. Now, I want to replicate only a few tables from the master server to an analytic server using ...
3
votes
1answer
458 views

When do Azure SQL Database index rebuilds occur?

Azure backups occur every few minutes as per the documentation for Automated backups: SQL Database supports self-service for point-in-time restore (PITR) by automatically creating full backup, ...

1
2 3 4 5
12