diff options
author | unknown <monty@hundin.mysql.fi> | 2001-06-21 01:12:29 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2001-06-21 01:12:29 +0300 |
commit | fb8c1f22a855f2580604b2534c4c9ce5028b5f6a (patch) | |
tree | bbb285ed85ea96c80162ca59d98dff5b741aeaf7 /Docs | |
parent | e4b63bf6c3cbecba51280ca20cc5d66945792e3a (diff) | |
download | mariadb-git-fb8c1f22a855f2580604b2534c4c9ce5028b5f6a.tar.gz |
Added --warnings to mysqld
Docs/manual.texi:
Changelog
sql/mysql_priv.h:
Added --warnings
sql/mysqld.cc:
Added --warnings
sql/sql_parse.cc:
Added --warnings
Diffstat (limited to 'Docs')
-rw-r--r-- | Docs/manual.texi | 28 |
1 files changed, 25 insertions, 3 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index 110e87638d3..64d80a61f94 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -10531,6 +10531,9 @@ Run @code{mysqld} daemon as user @code{user_name}. This option is @item -V, --version Output version information and exit. +@item -W, --warnings +Print out warnings like @code{Aborted connection...} to the @code{.err} file. +@xref{Communication errors}. @end table @cindex default options @@ -25795,8 +25798,8 @@ in its own lock table and rolls back the transaction. If you use than InnoDB in the same transaction, then a deadlock may arise which InnoDB cannot notice. In cases like this the timeout is useful to resolve the situation. -@item @code{innodb_unix_file_flush_method} @tab -(Available from 3.23.39 up.) +@item @code{innodb_flush_method} @tab +(Available from 3.23.40 up.) The default value for this is @code{fdatasync}. Another option is @code{O_DSYNC}. Options @code{littlesync} and @code{nosync} have the @@ -26406,7 +26409,7 @@ In some versions of Linux and Unix, flushing files to disk with the Unix @code{fdatasync} and other similar methods is surprisingly slow. The default method InnoDB uses is the @code{fdatasync} function. If you are not satisfied with the database write performance, you may -try setting @code{innodb_unix_file_flush_method} in @file{my.cnf} +try setting @code{innodb_flush_method} in @file{my.cnf} to @code{O_DSYNC}, though O_DSYNC seems to be slower on most systems. You can also try setting it to @code{littlesync}, which means that InnoDB does not call the file flush for every write it does to a @@ -38212,6 +38215,9 @@ option. @node Communication errors, Full table, Packet too large, Common errors @subsection Communication Errors / Aborted Connection +Starting with @code{MySQL 3.23.40} you only get the @code{Aborted +connection} error of you start @code{mysqld} with @code{--warnings}. + If you find errors like the following in your error log. @example @@ -46298,6 +46304,16 @@ Our TODO section contains what we plan to have in 4.0. @xref{TODO MySQL 4.0}. Added support for symbolic links to @code{MyISAM} tables. Symlink handling is now enabled by default for Windows. @item +@code{LOAD DATA FROM MASTER} "auto-magically" sets up a slave. +@item +A new @code{HANDLER} interface to @code{MyISAM} tables. +@item +@code{COUNT(DISTINCT)} is about 30% faster. +@item +Creating full text indexes are now much faster. +@item +Searching on packed (@code{CHAR}/@code{VARCHAR}) keys are now much faster. +@item Added @code{SQL_CALC_FOUND_ROWS} and @code{FOUND_ROWS()}. This makes it possible to know how many rows a query would have returned without a @code{LIMIT} clause. @@ -46406,6 +46422,12 @@ not yet 100% confident in this code. @appendixsubsec Changes in release 3.23.40 @itemize @bullet @item +Added option @code{--warnings} to @code{mysqld}. Now @code{mysqld} +only prints the error @code{Aborted connection} if this option is used. +@item +Fixed properly the rename of @code{innodb_unix_file_flush_method} to +@code{innodb_flush_method}. +@item Fixed bug when converting @code{UNSIGNED BIGINT} to @code{DOUBLE}. This caused a problem when doing comparisons with @code{BIGINT}'s outside of the signed range. |