![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196304.webp)
mysqladmin
— Client for Administering a MySQL Server
284
•
version
Display version information from the server.
All commands can be shortened to any unique prefix. For example:
shell>
mysqladmin proc stat
+----+-------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+----+---------+------+-------+------------------+
| 51 | monty | localhost | | Query | 0 | | show processlist |
+----+-------+-----------+----+---------+------+-------+------------------+
Uptime: 1473624 Threads: 1 Questions: 39487
Slow queries: 0 Opens: 541 Flush tables: 1
Open tables: 19 Queries per second avg: 0.0268
The
mysqladmin status
command result displays the following values:
•
Uptime
[534]
The number of seconds the MySQL server has been running.
•
Threads
The number of active threads (clients).
•
Questions
[530]
The number of questions (queries) from clients since the server was started.
•
Slow queries
The number of queries that have taken more than
long_query_time
[465]
seconds. See
Section 5.2.4, “The Slow Query Log”
.
•
Opens
The number of tables the server has opened.
•
Flush tables
The number of
flush-*
,
refresh
, and
reload
commands the server has executed.
•
Open tables
The number of tables that currently are open.
•
Memory in use
The amount of memory allocated directly by
mysqld
. This value is displayed only when MySQL has
been compiled with
--with-debug=full
[122]
.
•
Maximum memory used
The maximum amount of memory allocated directly by
mysqld
. This value is displayed only when
MySQL has been compiled with
--with-debug=full
[122]
.
If you execute
mysqladmin shutdown
when connecting to a local server using a Unix socket file,
mysqladmin
waits until the server's process ID file has been removed, to ensure that the server has
stopped properly.
mysqladmin
supports the following options, which can be specified on the command line or in the
[mysqladmin]
and
[client]
groups of an option file.
mysqladmin
also supports the options for
Содержание 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 ...