잡다한 명령어 모음

OS

블럭추적

파일의 block 위치 보기

[root@localhost ~]# filefrag -e CP046110.zip
Filesystem type is: 58465342
File size of CP046110.zip is 17614425 (4301 blocks of 4096 bytes)
 ext:     logical_offset:        physical_offset: length:   expected: flags:
   0:        0..    4300:    6360384..   6364684:   4301:             last,eof
CP046110.zip: 1 extent found

# 0 ~ 4300 : 4096 bytes 크기로 4300개를 쓴다
# 6360384 ~ 6364684 : 해당 지점에 연속적으로 기록되어 있음

 

블럭 정보로 inode 추적하기

[root@localhost ~]# xfs_db -r -c "blockget -b 13" /dev/vdb1
setting block 0/13 to dir
setting inode to 131 for block 0/13
inode 131 block 13 at offset 8388608
dir inode 131 block 8388608=13

 

WWN 보기

lspci | grep -i Fibre

root@pve:/sys/class/scsi_host# lspci | grep -i Fibre
11:00.0 Fibre Channel: QLogic Corp. ISP2722-based 16/32Gb Fibre Channel to PCIe Adapter (rev 01)
11:00.1 Fibre Channel: QLogic Corp. ISP2722-based 16/32Gb Fibre Channel to PCIe Adapter (rev 01)
61:00.0 Fibre Channel: QLogic Corp. ISP2722-based 16/32Gb Fibre Channel to PCIe Adapter (rev 01)
61:00.1 Fibre Channel: QLogic Corp. ISP2722-based 16/32Gb Fibre Channel to PCIe Adapter (rev 01)

 

cd /sys/class/scsi_host

ls -l

root@pve:~# cd /sys/class/scsi_host
root@pve:/sys/class/scsi_host# ls -l
total 0
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host0 -> ../../devices/pci0000:00/0000:00:11.5/ata1/host0/scsi_host/host0
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host1 -> ../../devices/pci0000:00/0000:00:11.5/ata2/host1/scsi_host/host1
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host10 -> ../../devices/pci0000:60/0000:60:00.0/0000:61:00.1/host10/scsi_host/host10
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host2 -> ../../devices/pci0000:00/0000:00:11.5/ata3/host2/scsi_host/host2
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host3 -> ../../devices/pci0000:00/0000:00:11.5/ata4/host3/scsi_host/host3
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host4 -> ../../devices/pci0000:00/0000:00:11.5/ata5/host4/scsi_host/host4
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host5 -> ../../devices/pci0000:00/0000:00:11.5/ata6/host5/scsi_host/host5
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host6 -> ../../devices/pci0000:b0/0000:b0:00.0/0000:b1:00.0/host6/scsi_host/host6
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host7 -> ../../devices/pci0000:10/0000:10:00.0/0000:11:00.0/host7/scsi_host/host7
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host8 -> ../../devices/pci0000:10/0000:10:00.0/0000:11:00.1/host8/scsi_host/host8
lrwxrwxrwx 1 root root 0 Mar 13 11:22 host9 -> ../../devices/pci0000:60/0000:60:00.0/0000:61:00.0/host9/scsi_host/host9

 

cat host7/device/fc_host/host7/port_name

root@pve:/sys/class/scsi_host# cat host7/device/fc_host/host7/port_name
0x51402e0000000000

 

MariaDB

grant

권한주기

GRANT ALL PRIVILEGES ON DB명.* TO 계정ID@localhost;