+----------+ | 2.09 PiB | +----------+ 1 row in set (0.00 sec) mysql> SELECT sys.format_bytes(2348723492723) AS size; +----------+ | size | +----------+ | 2.14 TiB | +----------+ 1 row in set (0.00 sec) mysql> SELECT sys.format_bytes(23487234) AS size; +-----------+ | size | +-----------+ | 22.40 MiB | +-----------+ 1 row in set (0.00 sec) BEGIN IF bytes IS NULL THEN RETURN NULL; ELSEIF bytes >= 1125899906842624 THEN RETURN CONCAT(ROUND(bytes / 1125899906842624, 2), ' PiB'); ELSEIF bytes >= 1099511627776 THEN RETURN CONCAT(ROUND(bytes / 1099511627776, 2), ' TiB'); ELSEIF bytes >= 1073741824 THEN RETURN CONCAT(ROUND(bytes / 1073741824, 2), ' GiB'); ELSEIF bytes >= 1048576 THEN RETURN CONCAT(ROUND(bytes / 1048576, 2), ' MiB'); ELSEIF bytes >= 1024 THEN RETURN CONCAT(ROUND(bytes / 1024, 2), ' KiB'); ELSE RETURN CONCAT(ROUND(bytes, 0), ' bytes'); END IF; END