SHOW BINARY LOGS SHOW MASTER LOGS
Lists the binary log files on the server. This statement is used as part of the procedure described in PURGE BINARY LOGS
, that shows how to determine which logs can be purged.
SHOW BINARY LOGS; +--------------------+-----------+ | Log_name | File_size | +--------------------+-----------+ | mariadb-bin.000001 | 19039 | | mariadb-bin.000002 | 717389 | | mariadb-bin.000003 | 300 | | mariadb-bin.000004 | 333 | | mariadb-bin.000005 | 899 | | mariadb-bin.000006 | 125 | | mariadb-bin.000007 | 18907 | | mariadb-bin.000008 | 19530 | | mariadb-bin.000009 | 151 | | mariadb-bin.000010 | 151 | | mariadb-bin.000011 | 125 | | mariadb-bin.000012 | 151 | | mariadb-bin.000013 | 151 | | mariadb-bin.000014 | 125 | | mariadb-bin.000015 | 151 | | mariadb-bin.000016 | 314 | +--------------------+-----------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-binary-logs/