SQL> SELECT Disk, Path , ROUND(Total/1024/1024, 0) AS Total_GB , ROUND(Used/1024/1024, 0) AS Used_GB , ROUND(Available/Total*100, 1) AS Free_Pct FROM information_schema.disks WHERE disk LIKE '/dev/%'; +-----------+----------------------+----------+---------+----------+ | Disk | Path | Total_GB | Used_GB | Free_Pct | +-----------+----------------------+----------+---------+----------+ | /dev/sdb1 | / | 183 | 23 | 82.4 | | /dev/sdb3 | /home | 704 | 485 | 26.0 | | /dev/sda1 | /home/mysql/database | 164 | 75 | 49.4 | +-----------+----------------------+----------+---------+----------+