echo 1 > /sys/class/block/sda/device/rescan #maybe run under root
> sudo fdisk /dev/sda2 > d > 2 > n > p > w (delete lvm partirion, use start bytes of partition)
Before
Device Boot Start End Sectors Size Id Type
/dev/sda1 * 2048 999423 997376 487M 83 Linux
/dev/sda2 1001470 587200511 586199042 279.5G 5 Extended
/dev/sda5 --> 1001472 587200511 586199040 279.5G 8e Linux LVM
After
Device Boot Start End Sectors Size Id Type
/dev/sda1 * 2048 999423 997376 487M 83 Linux
/dev/sda2 --> 1001472 1048575999 1047574528 499.5G 83 Linuxsudo pvresize /dev/sda2
> sudo lvextend -l +100%FREE /dev/DB-vg/root
> sudo resize2fs /dev/DB-vg/root
> lvscan (check changes in fs)
ACTIVE '/dev/DB-vg/root' [<498.57 GiB] inherit
ACTIVE '/dev/DB-vg/swap_1' [976.00 MiB] inheritOriginal https://kb.vmware.com/s/article/2042141 Backing up ESXi host configuration data To synchronize the configuration changed with persistent…
vCenter Converter Standalone 6.6.0 download (далее…)
VMware remote console (VMRC) 12.0.5 download Last version: VMware Remote Console 12.0.5 28 NOV 2023…
SELECT col_sizes.TABLE_SCHEMA, col_sizes.TABLE_NAME, SUM(col_sizes.col_size) AS EST_MAX_ROW_SIZE FROM ( SELECT cols.TABLE_SCHEMA, cols.TABLE_NAME, cols.COLUMN_NAME, CASE cols.DATA_TYPE WHEN…
UPDATE DB SET column = DATE(STR_TO_DATE(column, '%Y-%d-%m')) WHERE DATE(STR_TO_DATE(column, '%d-%m-%Y')) <> '0000-00-00'
First variant SELECT CONCAT(GROUP_CONCAT( CONCAT('(SELECT \'',COLUMN_NAME,'\' AS `column`, MAX(CHAR_LENGTH(`',COLUMN_NAME,'`)) AS `max_length`, MIN(CHAR_LENGTH(`',COLUMN_NAME,'`)) AS `min_length` ',…