database_dashboard

This module provide an overview of the larger tables (in term of size an rows) of your drupal database.

It provides also information about the cache tables.

It can be be used for a basic monitoring of your database.

Installation

Like any other module : composer require drupal/database_dashboard

Post-Installation

Add to your settings.php or settings.local.php the following lines:

$databases['schema']['default'] = [
  'host' => 'mariadb', // To Adapt
  'database' => 'information_schema',
  'username' => 'drupal', // To Adapt
  'password' => 'drupal', // To Adapt
  'prefix' => '',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',
];

Now head to /admin/reports/database (or Reports / Database Dashboard) and relax.