BACKGROUND
A new 1TB SSD was outfitted with 22.04 server.
I think pvscan indicates the SSD physical space is 928.46GB:
PV /dev/sda3 VG ubuntu-vg lvm2 [<928.46 GiB / <828.46 GiB free] Total: 1 [<928.46 GiB] / in use: 1 [<928.46 GiB] / in no VG: 0 [0 ]
My limited understanding of the subject matter per Andy's post:
Physical Volume (PV) => The physical space on a drive.
Volume Group (VG) => An abstracted amount of drive space that can be split between multiple drives/devices.
Logical Volume (LV) => The space that ubuntu "sees"
ISSUE
df -h
returns:
I would think that the Available space should total to slightly less than 1TB.The screenshot indicates available space is 86GB. If the database grows and needs more than 86GB, do I have a problem and if yes, what needs to be done? I would like the database to be able to access / use the entire SSD if it needs it.
pvdisplay & vgdisplay return:
user@mysql:~$ sudo pvdisplay
--- Physical volume ---
PV Name /dev/sda3
VG Name ubuntu-vg
PV Size 928.46 GiB / not usable 4.00 MiB
Allocatable yes
PE Size 4.00 MiB
Total PE 237685
Free PE 212085
Allocated PE 25600
PV UUID jPdsbk-LYcP-uAPA-9yNP-vyJ2-hCQn-otcxpn
user@mysql:~$ sudo vgdisplay
--- Volume group ---
VG Name ubuntu-vg
System ID
Format lvm2
Metadata Areas 1
Metadata Sequence No 2
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 1
Open LV 1
Max PV 0
Cur PV 1
Act PV 1
VG Size <928.46 GiB
PE Size 4.00 MiB
Total PE 237685
Alloc PE / Size 25600 / 100.00 GiB
Free PE / Size 212085 / <828.46 GiB
VG UUID YPWO13-whTj-QHxd-7G1a-xO7W-kSeJ-zuUVPp
QUESTION
I think I need help interpreting the information returned: will MySQL have access to the 900+GB to store data or does a procedure need to be performed to enable access to the 900+GB?
pvdisplay
,vgdisplay
... commands as appropriate to find out. – FedKad Dec 28 '23 at 15:11