Databases
      Back to home
      1. Help Center
      2. Server Administration
      3. Databases

      Database size

      ISPmanager

      Go to the Tools - Databases section.

      A list of databases will be displayed here. The size of the database will be displayed in the Size, MiB field.

      database-size

      VestaCP

      Go to the DB section.

      A list of databases and their disk space will be displayed here.

      database-size1

      DirectAdmin

      Go to your User Level in the Mysql Management section.

      A list of databases will be displayed here. The Size field displays the size of the database.

      database-size2

      phpMyAdmin

      In phpMyAdmin, select the database and look at the values in the Size column for each table and in the Total field below the list of tables.

      SQL query

      Run a query to get a free table of all databases, indicating the size of each of them (in megabytes):

      SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"

      FROM information_schema.TABLES GROUP BY table_schema ;

      Du command

      You can find out the size of the MySQL database using the du command. In fact, you just look at the size of the directory.

      Enter the command:

      # cd /var/lib/mysql/

      # du -sh site_name/

      2,9M site_name/

      If you have any questions, please create a ticket to technical support.