summaryrefslogtreecommitdiff
path: root/Docs
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.com>2000-09-26 02:57:29 +0300
committerunknown <monty@donna.mysql.com>2000-09-26 02:57:29 +0300
commit48e80bd5ec3e633b30640e54ae4315915c21559a (patch)
treebb421f15c229afe4917e309ee23edd41a9f50bff /Docs
parent7fe58c4f5bea627bb38bfbcb0cc5885e3f6129c6 (diff)
downloadmariadb-git-48e80bd5ec3e633b30640e54ae4315915c21559a.tar.gz
Small fixes
Docs/manual.texi: Changelog and small fixes mysys/my_init.c: Changed UMASK and UMASK_DIR to work also with octal scripts/mysqlhotcopy.sh: Fixed some small bugs sql/share/swedish/errmsg.OLD: Fixed wrong entry BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
Diffstat (limited to 'Docs')
-rw-r--r--Docs/manual.texi30
1 files changed, 24 insertions, 6 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index ffaef4e5451..052d2794857 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -581,7 +581,7 @@ Speed of queries that access or update data
* Estimating performance:: Estimating query performance
* SELECT speed:: Speed of @code{SELECT} queries
* Where optimizations:: How MySQL optimizes @code{WHERE} clauses
-* LEFT JOIN optimization:: How MySQL optimizes @code{LEFT JOIN} and ${RIGHT JOIN}
+* LEFT JOIN optimization:: How MySQL optimizes @code{LEFT JOIN} and @code{RIGHT JOIN}
* LIMIT optimization:: How MySQL optimizes @code{LIMIT}
* Insert speed:: Speed of @code{INSERT} queries
* Update speed:: Speed of @code{UPDATE} queries
@@ -30108,11 +30108,17 @@ clients connected to the @code{mysqld} server.
If you need more connections than the default (100), then you should restart
@code{mysqld} with a bigger value for the @code{max_connections} variable.
-Note that @code{mysqld} actually allows (@code{max_connections}+1) clients to connect.
-The last connection is reserved for a user with the @strong{process} privilege.
-By not giving this privilege to normal users (they shouldn't need this), an
-administrator with this privilege can login and use @code{SHOW PROCESSLIST}
-to find out what could be wrong. @xref{SHOW}.
+Note that @code{mysqld} actually allows (@code{max_connections}+1)
+clients to connect. The last connection is reserved for a user with the
+@strong{process} privilege. By not giving this privilege to normal
+users (they shouldn't need this), an administrator with this privilege
+can login and use @code{SHOW PROCESSLIST} to find out what could be
+wrong. @xref{SHOW}.
+
+The maximum number of connects @strong{MySQL} is depending on how good
+the thread library is on a given platform. Linux or Solaris should be
+able to support 500-1000 simultaneous connections, depending on how much
+RAM you have and what your clients are doing.
@node Out of memory, Packet too large, Too many connections, Common errors
@subsection @code{Out of memory} error
@@ -30547,6 +30553,10 @@ shell> export UMASK_DIR
shell> /path/to/safe_mysqld &
@end example
+In @strong{MySQL} 3.23.25 and above, @strong{MySQL} assumes that the
+value for @code{UMASK} and @code{UMASK_DIR} is in octal if it starts
+with a zero.
+
@xref{Environment variables}.
@node Not enough file handles, Using DATE, File permissions , Problems
@@ -36774,6 +36784,10 @@ though, so 3.23 is not released as a stable version yet.
@appendixsubsec Changes in release 3.23.25
@itemize @bullet
@item
+Fixed that databasename works as second argument to @code{mysqlhotcopy}.
+@item
+@code{UMASK} and @code{UMASK_DIR} can now be specified in octal.
+@item
Added @code{RIGHT JOIN}. This makes @code{RIGHT} a reserved word.
@item
Added @code{@@@@IDENTITY} as a synonym for @code{LAST_INSERT_ID()}.
@@ -41578,6 +41592,10 @@ If @code{mysqld} hangs you can try to use some system tools like
@code{strace} or @code{/usr/proc/bin/pstack} to examine where
@code{mysqld} has hung.
+@example
+strace /tmp/log libexec/mysqld
+@end example
+
If @code{mysqld} starts to eat up CPU or memory or if it ``hangs'', you
can use @code{mysqladmin processlist status} to find out if someone is
executing a query that takes a long time. It may be a good idea to