summaryrefslogtreecommitdiff
path: root/Docs/manual.texi
diff options
context:
space:
mode:
Diffstat (limited to 'Docs/manual.texi')
-rw-r--r--Docs/manual.texi22
1 files changed, 20 insertions, 2 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index ce0d867d881..54d665196b4 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -19885,6 +19885,7 @@ or SHOW INDEX FROM tbl_name [FROM db_name]
or SHOW TABLE STATUS [FROM db_name] [LIKE wild]
or SHOW STATUS [LIKE wild]
or SHOW VARIABLES [LIKE wild]
+or SHOW LOGS
or SHOW [FULL] PROCESSLIST
or SHOW GRANTS FOR user
or SHOW CREATE TABLE table_name
@@ -19906,6 +19907,7 @@ and @samp{_} wild-card characters.
* SHOW TABLE STATUS::
* SHOW STATUS::
* SHOW VARIABLES::
+* SHOW LOGS::
* SHOW PROCESSLIST::
* SHOW GRANTS::
* SHOW CREATE TABLE::
@@ -20150,7 +20152,7 @@ your @code{mysqld} @code{sort_buffer} variables is probably too small.
tables.
@end itemize
-@node SHOW VARIABLES, SHOW PROCESSLIST, SHOW STATUS, SHOW
+@node SHOW VARIABLES, SHOW LOGS, SHOW STATUS, SHOW
@subsection SHOW VARIABLES
@code{SHOW VARIABLES} shows the values of some @strong{MySQL} system
@@ -20610,11 +20612,27 @@ closing it. See also @code{interactive_timeout}.
The manual section that describes tuning @strong{MySQL} contains some
information of how to tune the above variables. @xref{Server parameters}.
+@node SHOW LOGS, SHOW PROCESSLIST, SHOW VARIABLES, SHOW
+@subsection SHOW Information About Log Files
+@code{SHOW LOGS} shows you status information about existing log
+files. It currently only displays information about Berkeley DB log
+files.
+
+@itemize
+@item @code{File} shows the full path to the log file
+@item @code{Type} shows the type of the log file (@code{BDB} for Berkeley
+DB log files})
+@item @code{Status} shows the status of the log file (@code{FREE} if the
+file can be removed, or @code{IN USE} if the file is needed by the transaction
+subsystem)
+@end itemize
+
+
@cindex threads, display
@cindex processes, display
@findex threads
@findex PROCESSLIST
-@node SHOW PROCESSLIST, SHOW GRANTS, SHOW VARIABLES, SHOW
+@node SHOW PROCESSLIST, SHOW GRANTS, SHOW LOGS, SHOW
@subsection SHOW Information About Connected Threads (Processes)
@code{SHOW PROCESSLIST} shows you which threads are running. You can