Databases Reference
In-Depth Information
The number of rows is obtained using a quick method, the
SHOW
TABLE
STATUS
statement, and 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.
Do not put a value too high for the
MaxExactCount
parameter. You would get correct
results but only after waiting for a few minutes, if there are many thousands of rows
in your
InnoDB
table. To examine the number of rows as displayed for
InnoDB
, please
refer to
Chapter
10
, where we actually have an
InnoDB
table to play with.
A user might be surprised when seeing the term
KiB
in the
Size
and
Overhead
columns. phpMyAdmin has adopted the
International
Electrotechnical
Commission
(
IEC
) binary prefixes (see
http://en.wikipedia.org/wiki/Binary_
prefix
). The displayed values are defined in each language file.
Table view
This is a commonly used view, giving access to all table-specific pages. By default,
the initial screen is the table's
Browse
screen, which shows the first page of this
table's data. Note that the header for this screen always shows the current database
and table names. We also see the comments set for the table, next to the table name:
Search WWH ::
Custom Search