All Questions
103,959
questions
1
vote
0
answers
6
views
mydumper packages availability for graviton aarch64
I am trying to implement mydumper for mysql community server (8.0), in absence of xtrabackup for graviton aarch64 architecture.
Unfortunately packages are not available for graviton aarch64 ...
- 179
0
votes
0
answers
5
views
Percona xtrabackup and percona toolkit for aarch64 Graviton Amazon Linux 2 machines
In my organisation, it was decided to move all the MySQL infrastructure (Amazon EC2 machines) to Graviton (aarch64) servers from AMD (x86_64).
All are MySQL Community Servers.
I need percona-...
- 179
1
vote
1
answer
30
views
Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?
Observations
The documentation says
To enable backup checksums in a BACKUP (Transact-SQL) statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option....
- 545
0
votes
0
answers
20
views
SQL server granular control over auto update statistics
I wanted to know if we get more granular control over auto update statistics at the index level in SQL server.
One of my DBs with auto update stats enabled recently started to have some behavioral ...
1
vote
1
answer
24
views
What kinds of operations could cause a "Temp table changed" recompilation?
Frequent recompilation happens in one SP with 'Temp table changed' cause. What kinds of operations on temp table would trigger this? There are no alter and create index operations on temp table, just ...
- 21
0
votes
1
answer
7
views
PieCloudDB upgrade failed
I am upgrading PieCloudDB Database from V2.8 to V2.14 according to the following steps on the administration guide:
1.Use the command helm upgrade [RELEASE] [CHART] [FLAGS] to push the new version of ...
- 16
-1
votes
0
answers
9
views
Assistance Needed: SQL Server 2019 Log Shipping for SharePoint SQL FCI Database
I hope this message finds you well.
I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) ...
-2
votes
0
answers
19
views
Dynamically change column names based on an 8 digit binary field
I have these two tables
The value in the incentive programs table is the decimal values based on binary values 00000001 (1), 00000010 (2), 00000100 (4), 00001000 (8), 00010000 (16), 00100000 (32), ...
- 27
0
votes
1
answer
5
views
Is there a way to backup a keyspace and restore it to a different cluster?
I have a live cassandra cluster(One node). I've built out a 3 node cluster I would like to migrate a keyspace to the new cluster. Is there a way to backup a Key space, then restore that Key space ...
0
votes
0
answers
29
views
Designing enrollment transfers
Here is a simplified asciigram of my database:
is_paid, paid_at
|
-----------Enrollments--------
/ \
| ...
- 101
0
votes
1
answer
27
views
Is DBCC CHECKFILEGROUP worthless if you already run DBCC CHECKDB on all databases?
DBCC CHECKDB makes many other integrity checks redundant, but I can't see anything in the documentation saying if it makes DBCC CHECKFILEGROUP redundant. Is DBCC CHECKFILEGROUP worthless if you ...
- 545
0
votes
0
answers
22
views
Why is the character set for the uca1400_ai_ci collation NULL?
I've been working with database collations of late. I generally don't like ambiguous queries such as SHOW COLLATION so I eventually found the source via the following query:
SELECT *
FROM ...
- 737
0
votes
1
answer
27
views
How can I find or log inbound traffic connecting to a PostgreSQL database instance?
I have a postgres instance where I need to find out who/what is connecting. The installed version of postgres is 9.0.1. The instance sits on a linux box, SUSE I believe. Where could I look if it is ...
- 620
-2
votes
0
answers
27
views
SQL Server: Two MERGE statements are blocking each other on a large partitioned table
Have a large table partitioned on an INT column. When I run two different MERGE statements on two different partitions of this table, they seem to be blocking each other.
Example:
-- Large table ...
- 561
0
votes
1
answer
31
views
How do I consolidate the related mappings?
I have a table which has mappings coming from different sources (one row for each source) for three different identifier types (idtype1 to idtype3) with idtype1 having the highest priority and idtype3 ...
- 181