WordPress.org
Get WordPress
WordPress.org

WordPress Developer Resources

WP_Debug_Data::get_database_size()

WP_Debug_Data::get_database_size(): int

In this article

Back to top

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

Return

int The size of the database, in bytes.

Source

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;
}

View all references View on Trac View on GitHub

UsesDescription
wpdb::get_results()wp-includes/class-wpdb.php

Retrieves an entire SQL result set from the database (i.e., many rows).

Used byDescription
WP_Debug_Data::get_sizes()wp-admin/includes/class-wp-debug-data.php

Fetches the sizes of the WordPress directories: wordpress (ABSPATH), plugins, themes, and uploads.

Changelog

VersionDescription
5.2.0Introduced.

User Contributed Notes

You must log in before being able to contribute a note or feedback.