WP_Debug_Data::get_database_size()public staticWP 5.2.0

Fetches the total size of all the database tables for the active database user.

Method of the class: WP_Debug_Data{}

No Hooks.

Return

Int. The size of the database, in bytes.

Usage

$result = WP_Debug_Data::get_database_size();

Notes

  • Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

Since 5.2.0 Introduced.

WP_Debug_Data::get_database_size() code WP 6.5.4

public static function get_database_size() {
	global $wpdb;
	$size = 0;
	$rows = $wpdb->get_results( 'SHOW TABLE STATUS', ARRAY_A );

	if ( $wpdb->num_rows > 0 ) {
		foreach ( $rows as $row ) {
			$size += $row['Data_length'] + $row['Index_length'];
		}
	}

	return (int) $size;
}