12
votes
Accepted
How to create a flexible table schema for storing messages from different chats?
All modern chatting interfaces, without exception, implement a hierarchical and a not-chronological schema for chat. That means you have to use (the soon to be released) MySQL 8, as prior versions do ...
- 65.8k
6
votes
Accepted
How Database Formats Files for Disk
I think it is opportune to start pointing out that, in a relational database —as per Dr. E.F. Codd— information is represented by means of one and only one structure, the relation, which is usually ...
- 8,530
5
votes
Accepted
Does Index Rebuild Reduces physical read from disk
Immediately after you rebuild an index, its pages are more likely to be cached in memory.
Consider this scenario:
Your server has a wide variety of queries running, and a wide variety of tables are ...
- 43.4k
4
votes
Configuring physical storage for a Microsoft SQL Server installation
First and foremost, look at your SAN vendor's documentation for recommendations regarding storage for SQL Server. This really should be your first step as the vendor hopefully has done a lot of this ...
- 9,557
4
votes
Does Index Rebuild Reduces physical read from disk
The basic question boils down to "What, exactly, does an index rebuild do to an index." The simple answer is that it puts the index in sequential order. The more complex answer is the answer to your ...
- 2,068
3
votes
Accepted
Using GPT partition type with SQL Server in production?
Has anyone else used GPT partition type with SQL Server in production?
Yes.
If so, have you experienced any issues?
No.
Not much more I can really say about that, especially while not being an ...
- 41.1k
3
votes
SQL Server Alias for Directories
In addition to mklink, using SSMS you can change the default backup location for each instance to the desired local folder, then backups to a disk location without a drive or path specified will go ...
- 49.2k
3
votes
Accepted
Does Traceflag 1800 require a restart?
The documentation you referenced says that:
A global trace flag must be enabled globally. Otherwise, the trace
flag has no effect. We recommend that you enable global trace flags at
startup, by ...
- 6,307
3
votes
Does Index Rebuild Reduces physical read from disk
I'd also add another possibility (in additional to @Laughing Vergil's answer) why you see your I/O workload reduced.
After index rebuilt, the statistics on those indexes are also rebuilt, i.e. more ...
- 3,083
3
votes
Accepted
How to Store Skip Lists on Disk
A DBMS is an implementation of a datamodel - a structure for how data will be represented. The relational model represents data as tables and columns, graph model as nodes and edges, document model as ...
- 25.3k
2
votes
Which hard disks for PostgreSQL?
That is a big fat "it depends on your application(s)". You say how large the total data is but not the commonly active data-set? All in one DB or several? If several is it the same structure in each (...
- 32.7k
2
votes
Is postgres vacuum secure
Citing the reference:
VACUUM FULL rewrites the entire contents of the table into a new disk
file with no extra space, allowing unused space to be returned to the
operating system
Without FULL, ...
- 173
2
votes
Accepted
SQL Server Alias for Directories
I have different folders on different machines and I need one logical
name for them both, sure one on each server.
If you have different folders on different servers and you need them to be presented ...
- 6,307
2
votes
Accepted
Pointing the database secondary data file towards a network drive
You can do it, it doesn't mean you should. There is many things to take into account, like performances and reliability.
Putting the files on the network will probably cause you some performance ...
- 2,089
1
vote
AG node getting "misaligned log IOs which required falling back to synchronous IO" events in error log
In my experience, I needed to add Trace Flag 1800 to all instances involved in the Always On Availability Group.
I enabled the trace flag using the DBCC TRACEON(1800, -1) to enable it globally ...
- 71.1k
1
vote
What is the correct way to present the disks to ASM?
How did you "format" them? Oracle expect them to be block devices, not formatted with a file system. Did you read this documentation?
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/...
- 3,357
1
vote
Accepted
Moving MySQL databases/folder to another disk
Yes, you can here is the steps to do it.
backup:
# service mysqld stop
# cd /var/lib/mysql
# tar -cvzf /tmp/mysql-backup.tar.gz ./*
# service mysqld start
restore:
# service mysqld stop
# cd /data/...
- 2,718
1
vote
Configuring physical storage for a Microsoft SQL Server installation
Well, I would say an obvious thing first. Test both scenarios and see what's the performance difference between Tiered and dedicated SSD architecture.
Then think about downsides of having key data to ...
1
vote
Configuring physical storage for a Microsoft SQL Server installation
Well, generally:
LDF are latency sensitive but linear. A SAN WriteBack cache (or a local Raid controller with BBU and write back) is good enough to handle the latency, the throughput can be handled by ...
- 4,646
Only top scored, non community-wiki answers of a minimum length are eligible