This is where we can see an overview of the database: the existing tables, a link to
create a table, the tabs to the Database view sub-pages, and some special operations
we might do on this database to generate documentation and statistics. There is
a checkbox beside each table to make global operations on that table (covered in
Chapter 10). The table is chosen by using the checkbox or by clicking anywhere on
the row's background. We can also see each table's size, if $cfg['ShowStats'] is
set to TRUE. This parameter also controls the display of table-specific statistics in the
Table view.
Interface Overview
[ 60 ]
The initial screen that appears here is the database Structure sub-page. We might
want a different initial sub-page to appear when entering the Database view. This
is controlled by the $cfg['DefaultTabDatabase'] parameter, and the available
choices are given in the configuration file as comments.
The number of records is obtained using a quick method, the SHOW TABLE STATUS
statement??”not by using a SELECT COUNT(*) FROM TABLENAME. This quick method
is usually accurate, except for InnoDB tables, which returns an approximate
number of records. To help get the correct number of records, even for InnoDB, the
$cfg['MaxExactCount'] parameter is available. If the approximate number of
records is lower than this parameter's value??”by default, 20000??”the slower SELECT
COUNT(*) method will be used.
Pages:
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83