Questions tagged [disk-structures]
The disk-structures tag has no summary.
45 questions
0
votes
1
answer
120
views
Database systems - data type alignment padding and record size (C/C++ related)
In PostgreSQL there is alignment padding of various datatypes which can increase (or decrease) the size of records (as stored on disk) in varying ways (see these links, 1, 2, 3):
I searched for "...
- 31k
0
votes
1
answer
530
views
Using GPT partition type with SQL Server in production?
We are currently using MBR partition type with our SQL Server in production, but as our data volume increases, we are facing issues with our data drives getting full. We can't extend them because they ...
- 1,239
1
vote
1
answer
1k
views
AG node getting "misaligned log IOs which required falling back to synchronous IO" events in error log
SQL 2016 AOAG. 3 node cluster. Primary and 1 secondary on-prem configured with synchronous availability mode. 1 node in Azure using asynchronous availability mode. We are using AOAGs to move data ...
- 11
0
votes
0
answers
409
views
Azure VM with alwayson AGs - expand data disk
I have a three nodes SQL Server Alwayson cluster on Azure VM.
I need to expand the data disk on all three nodes.
The disk is a stripe disk build during VM configuration.
Based on this:
https://learn....
- 5,151
0
votes
2
answers
145
views
SQL Server Alias for Directories
I have different folders on different machines and I need one logical name (alias) for them both, sure one on each server.
I need to create one logical directory in several servers with the same name, ...
- 2,162
1
vote
1
answer
131
views
Pointing the database secondary data file towards a network drive
I have a 2 TB database and the Data Drive has filled up. My network team cannot expand the drive nor provide another drive so that the secondary data file can be pointed towards that. My question is ...
- 1,117
0
votes
1
answer
484
views
What is the correct way to present the disks to ASM?
Hello I would like to know which is the correct way ... or the most recommended way to present the disks to ASM, for example: I have 3 disks mapped to a server (rhel7) orasys, orafra, oradata, with dm-...
- 169
2
votes
1
answer
5k
views
Does Traceflag 1800 require a restart?
We have recently migrated our database mirroring secondary to new hardware. The log drive (and other SQL Server drives) on the secondary has been formatted to 64KB block size, whereas the primary ...
- 2,264
0
votes
1
answer
2k
views
Moving MySQL databases/folder to another disk
I want to separate MySQL database from the OS (Ubuntu) disk by moving the entire database to an exclusive HDD (M.2), and update the database folder in my.cnf.
My question is: when the MySQL folder is ...
- 4,551
2
votes
1
answer
321
views
Is postgres vacuum secure
Postgres delete doesn't actually remove the record from the table file.
Once the delete is committed and the last transaction is closed, no postgres process can see the record any more, the deleted ...
- 3,666
3
votes
3
answers
805
views
Does Index Rebuild Reduces physical read from disk
Recently I have rebuild indexes uisng Ola Hallengreen script which were 99% fragmented. After rebuilt i have noticed the physical reads have reduced a lot. Does this has anything to do with Index ...
- 1,117
1
vote
0
answers
42
views
How a single column update is saved to disk
In learning about how data in a database is saved to disk, I came across the slide below. Earlier in the presentation they mention a block size is roughly 512 to 8,192 bytes. I haven't worked with ...
- 221
2
votes
1
answer
776
views
How to Store Skip Lists on Disk
I am new to thinking in terms of databases. I have read about how B-trees are stored on disk but I haven't seen an actual implementation or read about how it works for B-trees.
Wondering how one ...
- 221
2
votes
1
answer
133
views
How Database Formats Files for Disk
This SO answer outlines how MySQL organizes its database into files, but doesn't describe the structure of the files themselves.
I am wondering, at the physical level, how relational database ...
- 221
8
votes
3
answers
42k
views
How to create a flexible table schema for storing messages from different chats?
Help please solve the following situation:
There are two kinds of API where message history is stored, it's Zopim and Chat2Desc (import into Postman). While these two but can then others appear.
And ...
- 141