PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
This value is calculated only for timed events because nontimed events have a wait time of NULL. The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
These can be identified as those that have a library name of NULL in the output from INFORMATION_SCHEMA.PLUGINS or SHOW PLUGINS. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-binlog.html
If your binary log contains \0 (null) characters, that output cannot be parsed by mysql unless you invoke it with the --binary-mode option. This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math.html
Similarly, you can treat division by zero as an error rather than as an operation that produces a result of NULL. MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
WHERE autoincrement_col IS NULL The last form is not cached because it is used as the ODBC workaround for obtaining the last insert ID value. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
MySQL 5.7 supports delayed replication such that a replica server deliberately lags behind the source by at least a specified amount of time. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns. Partitioning is not supported for tables using the CSV storage engine.
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function column is NULL. SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used ...