139 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
0
replies
60
views
macOS Disk Activity Time Calculation: How to Correctly Obtain or Estimate % Disk Time
I'm trying to monitor disk activity time on macOS (similar to the "Disk Activity Time" percentage on Windows), but macOS's I/O statistics differ from those on Windows. Using the ioreg ...
Advice
1
vote
1
replies
43
views
Why do B-tree disk optimizations work when the OS controls physical disk layout?
I understand the standard explanation for why B-trees are used in databases: they minimize disk seeks by packing many keys into each node, keeping the tree shallow (3-4 levels), and enabling efficient ...
0
votes
1
answer
80
views
What does the Linux 0.11 kernel do while the disk prepares data after hd_out?
I’m exploring the Linux 0.11 source code, specifically how it reads data from the disk into memory. I’ve been analyzing the hd_out function and the associated do_hd_request in hd.c.
Here’s the ...
0
votes
1
answer
147
views
Delphi IOresult misbehaving
I have an application that saves data to an xml file but when data cannot be interpreted it writes a message to a textfile. I am using Delphi 11, Windows 10, 64bit compilation
The procedure to write ...
0
votes
0
answers
86
views
How to get write access to device?
When I write to a disk device or a drive, sometimes I get an access denied error:
HANDLE hd=CreateFile("\\\\.\\PhysicalDrive1",GENERIC_WRITE,FILE_SHARE_READ|FILE_SHARE_WRITE, NULL,...
1
vote
1
answer
648
views
Excessive disk I/O when using VSCode remote SSH for Next.js development
I'm encountering an issue where Node.js processes are consuming excessive disk I/O when I'm using Visual Studio Code (VSCode) with Remote SSH to develop Next.js applications on a cloud server. This ...
1
vote
0
answers
82
views
Reading diskIO returns strange devicenames
Greetings Stack Overflow community!
I'm currently working on a Go script to fetch disk I/O operations using my API. However, I'm encountering a peculiar issue where the script returns empty values. In ...
0
votes
0
answers
3k
views
How to get a disk IO time rate from prometheus
I have a server running standard Prometheus node exporter. Metrics are properly collected.
Now I need to display in Grafana rate of time spend for IO operations on all devices.
In the /metrics for my ...
1
vote
0
answers
523
views
Per-process I/O stats in Linux - TASKSTATS_CMD_ATTR_TGID not working
Linux provides /proc/[pid]/io interface to get I/O stats of a process. But in addition to the accumulated I/O of live threads, read_bytes and write_bytes fields also include the I/O of dead threads ...
0
votes
1
answer
292
views
What is measured by changing the `file-block-size` parameter in sysbench fileio test?
I was trying to measure the system performance with sysbench fileio test. However, I'm not sure what am I playing with when I change that file-block-size parameter.
Previously I thought it was the ...
-1
votes
1
answer
95
views
Why CPU reset when no `cli`
I am trying to write a bootloader by myself, but qemu-system-i386 CPU will reset probabilistically. But bochs does not have this problem. Why?
my code is mbr.s and loader.s:
# cat mbr.s
%include "...
1
vote
1
answer
468
views
How can I do an unbuffered disk read in Python?
I need to read a sector from the physical disk, but without using the system cache.
I tried this:
import os
disk_path = "/dev/sdc"
try:
disk_fd = os.open(disk_path, os.O_RDONLY | os....
1
vote
0
answers
129
views
How DBMS accesses disk pages when OS only allows files access?
The SQL databases generally use B-trees to store index (and sometimes data as well) in the disk. The B-tree is a tree of disk pages. To create B-tree, the DBMS would require access to pages on the ...
0
votes
1
answer
255
views
Kafka disk access while reading and writing
According to Kafka doc https://kafka.apache.org/documentation/#persistence, Kafka utilities squential read/write performace of spnning disks and hence have high throughput. But how can this high ...
1
vote
0
answers
2k
views
Postgresql - random_page_cost =1.1 and NVMe disk: slower query
My SysAdmin colleague told me that the Postgres'hosts use NVME disk.
How can I check that with Linux command?
Why does the planner/optimizer seem to get it wrong when I set random_page_cost =1.1
To ...