sys Schema Stored Functions Parameters Return Value Example 28.4.5.3 The format_bytes() Function Parameters Return Value Example 28.4.5.4 The format_path() Function Given a file path name, returns the path component that represents the table name. This function is useful when extracting file I/O information from the Performance Schema that includes file path names. It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names. A  VARCHAR(64)  value. • path VARCHAR(512) : The full path to a data file from which to extract the table name. mysql>  SELECT sys.extract_table_from_file_name(’/usr/local/mysql/data/world/City.ibd’); +--------------------------------------------------------------------------+ | sys.extract_table_from_file_name(’/usr/local/mysql/data/world/City.ibd’) | +--------------------------------------------------------------------------+ | City | +--------------------------------------------------------------------------+ Note As of MySQL 8.0.16,  format_bytes()  is deprecated; expect it to be removed in a future version of MySQL. Applications that use it should be migrated to use the built-in  FORMAT_BYTES()  function instead. See Section 12.22, “Performance Schema Functions” Given a byte count, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is  bytes ,  KiB  (kibibytes),  MiB (mebibytes),  GiB  (gibibytes),  TiB  (tebibytes), or  PiB  (pebibytes). • bytes TEXT : The byte count to format. A  TEXT  value. Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir mysql>  SELECT sys.format_bytes(512), sys.format_bytes(18446644073709551615); +-----------------------+----------------------------------------+ | sys.format_bytes(512) | sys.format_bytes(18446644073709551615) | +-----------------------+----------------------------------------+ | 512 bytes | 16383.91 PiB | +-----------------------+----------------------------------------+ 5203