Oracle 5.0, Reference Manual

Page: 1205 / 3232

SHOW
Syntax
1185
You can use
db_name
.
tbl_name
as an alternative to the
tbl_name FROM db_name
syntax. These
two statements are equivalent:
SHOW INDEX FROM mytable FROM mydb;
SHOW INDEX FROM mydb.mytable;
The
WHERE
clause can be given to select rows using more general conditions, as discussed in
Section 19.18, “Extensions to
SHOW
Statements” .
You can also list a table's indexes with the
mysqlshow -k db_name tbl_name
command.
13.7.5.19.
SHOW INNODB STATUS
Syntax
SHOW INNODB STATUS
In MySQL 5.0, this is a deprecated synonym for
SHOW ENGINE INNODB STATUS
. See
Section 13.7.5.12, “
SHOW ENGINE
Syntax” .
SHOW INNODB STATUS
is removed in MySQL 5.5.
13.7.5.20.
SHOW LOGS
Syntax
SHOW [BDB] LOGS
In MySQL 5.0, this is a deprecated synonym for
SHOW ENGINE BDB LOGS
. See Section 13.7.5.12,
“
SHOW ENGINE
Syntax” .
13.7.5.21.
SHOW MASTER STATUS
Syntax
SHOW MASTER STATUS
This statement provides status information about the binary log files of the master. It requires either the
SUPER
[578] or
REPLICATION CLIENT
[577] privilege.
Example:
mysql> SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73 | test | manual,mysql |
+---------------+----------+--------------+------------------+
13.7.5.22.
SHOW MUTEX STATUS
Syntax
SHOW MUTEX STATUS
SHOW MUTEX STATUS
displays
InnoDB
mutex statistics. From MySQL 5.0.3 to 5.0.32, the statement
displays the following output fields:
•
Mutex
The mutex name. The name indicates the mutex purpose. For example, the
log_sys
mutex is used
by the
InnoDB
logging subsystem and indicates how intensive logging activity is. The
buf_pool
mutex protects the
InnoDB
buffer pool.
•
Module
The source file where the mutex is implemented.
•
Count
indicates how many times the mutex was requested.
•
Spin_waits
indicates how many times the spinlock had to run.
•
Spin_rounds
indicates the number of spinlock rounds. (
spin_rounds
divided by
spin_waits
provides the average round count.)