"To be a warrior is not a simple matter of wishing to be one. It is rather an endless struggle that will go on to the very last moment of our lives. Nobody is born a warrior, in exactly the same way that nobody is born an average man. We make ourselves into one or the other." --Kokoro
Sometimes sorting gets really frustrating when all the data you are trying to sort isn’t formatted the same.
Create a new column next to the column you’re attempting to sort, then use this formula to move X amount of characters. I’m using Ford Part #’s and I need to sort by the 4th character in which is the Z
A2 cell = C0AZ-7153-A
1
=RIGHT(A2,LEN(A2)-x)
Whereas x = the amount you want to move for example
1
=RIGHT(A2,LEN(A2)-3)
which gives
Z-7153-A
From there just copy that formula to the rest of the cells in the new column then u can sort sheet under that column.
new raid /dev/md0 with 2 disks, raid level 1 on /dev/sda1 and /dev/sda2
1
mdadm--fail/dev/md0/dev/sda1
1
mdadm--remove/dev/md0/dev/sda1
remove /dev/sda1 from /dev/md0
1
mdadm--add/dev/md0/dev/sda1
add /dev/sda1 to /dev/md0
1
mdadm--grow/dev/md0-n3
use 3 disks in raid /dev/md0 (e.g. add an additional disk, so a damaged drive can be removed later-on)
1
mdadm--assemble/dev/md0
Assemble /dev/md0 (e.g. when running live system)
1
mdadm--detail--scan>>/etc/mdadm/mdadm.conf
Update list of arrays in /etc/mdadm/mdadm.conf ; you should remove old list by hand first!
1
mdadm--examine/dev/sda1
What is this disk / partition?
1
sysctl-wdev.raid.speed_limit_min=10000
Set minimum raid rebuilding speed to 10000 kiB/s (default 1000)
1
sfdisk-d/dev/sdX|sfdisk/dev/sdY
Copy partition table from sdX to sdY (MBR only)
1
sgdisk/dev/sdX-R/dev/sdY;sgdisk-G/dev/sdY
Copy partition table from sdX to sdY (GPT)
To boot a machine even with a degraded array, modify /etc/initramfs-tools/conf.d/mdadm and run update-initramfs -c -kall (Use with caution!)
LVM
pv: physical device (e.g. /dev/md0 or /dev/sda1)
vg: volume group (consists of 1 or more pvs, contains lvs); has a name (e.g. lvm)
lv: logical volume (has a name which defines its path, e.g. /dev/lvm/root which equals dev/mapper/lvm-root)
command description
1
pvcreate/dev/md0
initializes /dev/md0 as phys device for a volume group
1
vgcreate lvm/dev/md0
create volume group lvm with phys device /dev/md0
1
lvcreate-L30G-nroot lvm;mkfs.ext4/dev/lvm/root
create logical volume root, sized 30G in volume group lvm; format with ext4
1
lvextend-L60G-nroot lvm;resize2fs/dev/lvm/root
extend /dev/lvm/root to 60G; also resize file system to new size
1
pvs,vgs,lvs
show short info about pv, vg and lv
1
pvdisplay,vgdisplay,lvdisplay
show long info
1
pvscan/dev/md0
scan disks for physical volumes (e.g. when running live system)
1
vgextend lvm/dev/md1
add phys device /dev/md1 to volume group lvm (need pvcreate first!)
1
pvmove/dev/md0;vgreduce lvm/dev/md0
move all logical volumes from /dev/md0 and remove phys device from volume group
I have no idea how or why this started happening however my monitors would go black after 15 seconds of idle. No power settings or screensavers were causing it, nor did I see any helpful logs to help troubleshoot. However somewhere/how the Energy Star features of my monitor got enabled and literally after 15 seconds of idle time the monitors would go black..
Simple fix:
1
$sudo xset-dpms
This fixed the issue not only for the current logged in session but also after a reboot.