SHOW
Syntax
1180
SHOW ENGINE NDB STATUS
SHOW ENGINE NDBCLUSTER STATUS
SHOW ENGINE BDB LOGS
displays status information about existing
BDB
log files. It returns the
following fields:
•
File
The full path to the log file.
•
Type
The log file type (
BDB
for Berkeley DB log files).
•
Status
The status of the log file (
FREE
if the file can be removed, or
IN USE
if the file is needed by the
transaction subsystem)
SHOW ENGINE INNODB STATUS
displays extensive information from the standard
InnoDB
Monitor
about the state of the
InnoDB
storage engine. For information about the standard monitor and other
InnoDB
Monitors that provide information about
InnoDB
processing, see
Section 14.2.12.2, “
SHOW
ENGINE INNODB STATUS
and the
InnoDB
Monitors”
.
Older (and now deprecated) synonyms for
SHOW ENGINE BDB LOGS
and
SHOW ENGINE INNODB
STATUS
are
SHOW [BDB] LOGS
and
SHOW INNODB STATUS
, respectively.
If the server has the
NDBCLUSTER
storage engine enabled,
SHOW ENGINE NDB STATUS
can be used
to display cluster status information. Sample output from this statement is shown here:
mysql>
SHOW ENGINE NDB STATUS;
+-----------------------+---------+------+--------+
| free_list | created | free | sizeof |
+-----------------------+---------+------+--------+
| NdbTransaction | 5 | 0 | 208 |
| NdbOperation | 4 | 4 | 660 |
| NdbIndexScanOperation | 1 | 1 | 736 |
| NdbIndexOperation | 0 | 0 | 1060 |
| NdbRecAttr | 645 | 645 | 72 |
| NdbApiSignal | 16 | 16 | 136 |
| NdbLabel | 0 | 0 | 196 |
| NdbBranch | 0 | 0 | 24 |
| NdbSubroutine | 0 | 0 | 68 |
| NdbCall | 0 | 0 | 16 |
| NdbBlob | 2 | 2 | 204 |
| NdbReceiver | 2 | 0 | 68 |
+-----------------------+---------+------+--------+
12 rows in set (0.00 sec)
The most useful of the rows from the output of this statement are described in the following list:
•
NdbTransaction
: The number and size of
NdbTransaction
objects that have been created.
An
NdbTransaction
is created each time a table schema operation (such as
CREATE TABLE
or
ALTER TABLE
) is performed on an
NDB
table.
•
NdbOperation
: The number and size of
NdbOperation
objects that have been created.
•
NdbIndexScanOperation
: The number and size of
NdbIndexScanOperation
objects that have
been created.
•
NdbIndexOperation
: The number and size of
NdbIndexOperation
objects that have been
created.
•
NdbRecAttr
: The number and size of
NdbRecAttr
objects that have been created. In general, one
of these is created each time a data manipulation statement is performed by an SQL node.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...