I have a root partition of 20G in size and it is running out of space because the /var/lib/mysql/ibdata1 is getting too large (13G now, the whole /var/lib is 15G in size).
lsblk command shows something like this:
sda -sda1 -sda2 (mountpoint /) -sda3 --volgroup1-lvol0 (mountpoint /home) -sda4 ([swap]) sdb -volgroup1-lvol0 (mountpoint /home)
So basically the sda2 is the / partition with the 20G of space and sda3 + sdb is /home partition with space of 3.6T created with LVM. /dev/sda2 and /dev/mapper/volgroup1-lvol0 are both ext4.
1) What is the best way of resizing the root partition? I can shut off the system for an hour or two as I don't run any high traffic sites. This would not be an issue.
2) Is there any way of solving the issue of the ibdata1 growing too large?