Questions tagged [configuration]
The choice of settings for hardware, firmware, software or other components of a database system.
713 questions
0 votes
0 answers
13 views
Setting up Cassandra with PEMBasedSslContextFactory results in configuration error
I followed the guide for setting up client to server encryption with the PEMBasedSslContextFactory for Cassandra at https://cassandra.apache.org/doc/stable/cassandra/managing/operating/security.html#...
- 101
0 votes
1 answer
214 views
MariaDB installation setting lower_case_table_names
I had MySQL installed on Windows 11 with lower_case_table_names=2 to preserve mixed-case table names. To migrate to MariaDB, I backed up the database with mysqldump. When installing MariaDB using ...
- 111
5 votes
2 answers
2k views
what are the reasons why show advanced options is a security threat when left enabled?
I generally only change temporarily the values of Show Advanced Options. I have servers where this would be a convenient setting to leave on. are there real threats that could be avoided by denying ...
- 17.3k
3 votes
1 answer
82 views
MYSQL and random performance of store procedure
I run this SP at night, when there’s almost no activity. The SP performs an accumulative calculation of machine usage from a laundromat—an artisanal BI query. It writes the result to a table. On most ...
0 votes
1 answer
395 views
Why does my MariaDB application use more memory than configured?
I have a cluster of Primary->Primary DB servers running MariaDB 11.4.5. The OS on them were upgraded from Ubuntu 22.04 to 24.04 yesterday as there appeared to be some form of memory leak which ...
0 votes
1 answer
85 views
How to replicate a database daily without changing WAL postgres settings?
I need to replicate a Postgres database daily (it could also be continuously) to another server but without changing the Postgres settings. I can't change the database settings because it's from my ...
- 3
0 votes
0 answers
150 views
Is it possible to change the ERRORLOG files encoding in SQL Server 2019?
We have a security vendor in our company that needs to access the ERRORLOG files in some SQL Server 2019 instances. They say the encoding on our files is unusual [UTF-16 LE BOM] as the standard is [...
- 11
0 votes
1 answer
68 views
Which file specify Oracle's DB full version (major and minor)? Oracle 19 and up
In some monitoring service I have, I need to detect Oracle DB upgrades/patches, and for that, I want to sample the Database version. I am aware that creating a connection and running the query select *...
- 113