Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
Is there any tool or configurations for mongodb server to protect against brute force attacks on the user credentials? I found only authFailedDelayMs param witch Available in...
Asked on 10/28/2021 by Darii Petru
0 answerI have a question on bridging tables: if I have a bridging table linking two tables (standard) with the only values in the bridging table being the Primary Keys for...
Asked on 10/28/2021 by zv426
2 answerI'm trying to create a few functions to make the SQL queries between my SQLite and Postgres DB's the same. One thing I would like to do is change a...
Asked on 10/28/2021 by ovatsug25
1 answerFailed to create a new folder 'X:MSSQLDATAMSSQL11.MSSQLSERVERMSSQLLOG'. The specified path is invalid (for example, it is on an unmapped drive). I checked there is no X drive present in the...
Asked on 10/28/2021 by SunilGoswami
1 answerI have a materialized view that refreshes every five minutes. The SQL aggregates the data among many tables with over 800k rows in each. However, the when using the "REFRESH...
Asked on 10/28/2021
1 answerFound an error log informing that data movement to a secondary availability replica was suspended. I'm not sure whether the cause of the suspension is relevant to answering my question,...
Asked on 10/28/2021
1 answerI'm using MariaDB 10.5 on Centos7 with 4G RAM and 2 CPU. Here's my.cnf configuration[mysqld]log-error=/var/lib/mysql/mysql-3.kannel.com.errmax_allowed_packet=1Gevent_scheduler = ONinnodb_file_per_table=ON#innodb_file_format=Barracudainnodb_buffer_pool_size=3Ginnodb_buffer_pool_instances=6innodb_log_file_size=1Ginnodb_log_files_in_group=1innodb_log_buffer_size=32Minnodb_log_write_ahead_size=32Minnodb_flush_log_at_trx_commit=2innodb_read_io_threads=32innodb_write_io_threads=128innodb_io_capacity=10000innodb_thread_concurrency=6innodb_flush_method=o_directjoin_buffer_size=128Msort_buffer_size=20Mread_rnd_buffer_size=128Mdatadir=/var/lib/mysqlopen_files_limit=10000default-storage-engine=InnoDBmax_connections = 500# CACHES AND LIMITS #tmp-table-size ...
Asked on 10/28/2021 by Rajesh Ranjan
1 answerI am running a MySQL server 8.0.21 on a Windows Server system. Recently I ran into an issue where my root user lost all its privileges.I am trying to...
Asked on 10/28/2021 by Augustus Buckman
0 answerI have a MySQL RDS instance ("production") from which I need to copy incremental data to another MySQL RDS instance ("reporting"). “Incremental data” being the new rows in certain...
Asked on 10/28/2021 by Alex Lo
2 answerSuppose I have a 'Transactions' table which has a column 'Customer ID' (Foreign Key) and a Customer Table having 'ID' (Primary key). How do I show the relation between the...
Asked on 10/28/2021 by MK Singh
5 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP