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 cost
valuable MySQL server resources.
Enabling Statistics
If we click this
Enable Statistics
link, a modified page appears:
Sorting Statistics
By default, the 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 them accordingly. A second click
reverses the sort order.
Checking the Database Privileges Check
Clicking the
Check Privileges
link displays all the privileges on a specific database.
A user's global privilege might be shown here since it gives him or her access to this
database as well. We can also see the privileges specific to this database. An
Edit
link
takes us to another page that is used to edit the user's privileges:
Search WWH ::
Custom Search