Databases Reference
In-Depth Information
We also see an
Enable Statistics
link. By default, statistics are not enabled because
computing the size of data and indexes for all the tables in all the databases may
consume valuable MySQL server resources.
Enabling statistics
If we click on the
Enable Statistics
link, a modified page appears. For each database,
we get the default collation for tables in this database, along with the number of
tables in the database and the total number of rows for all tables. Next, information
about the space used by the data portion of the tables is given, followed by the space
taken by all indexes, and total space for all tables. Next, the space that could be
reclaimed by optimizing some tables in this database is presented under
Overhead
column header. Finally, we can see replication information, followed by
Check
Privileges
links:
Sorting the statistics
By default, the statistics list is sorted by database name in ascending order. If we
need to find the database with the most tables or the database that takes the most
space, a simple click on the
Tables
or
Total
column header sorts the list accordingly.
A second click reverses the sort order.
Search WWH ::
Custom Search