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/validate-password-options-variables.html
An implication is that a user who has sufficient privileges to set another user's password can set the password to that user's name, and cannot set that user' password to the name of the user executing the statement. This section describes the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
Fully synchronous replication means failover from the source to any replica is possible at any time. The source does not wait for all replicas to acknowledge receipt, and it requires only an acknowledgement from the replicas, not that the events ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At ...RESIGNAL makes it possible to both handle an error and return the error ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
MySQL 5.7 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 16.3.10, “Delayed Replication”. Replication enables data from one MySQL database server (the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
For the second call, the repertoire is UNICODE because the second argument is outside the ASCII range. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or rw-lock becomes available during this period, the thread can continue ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
in_views SET ('with_runtimes_in_95th_percentile', 'analysis', 'with_errors_or_warnings', 'with_full_table_scans', 'with_sorting', 'with_temp_tables', 'custom'): Which views to include. This procedure disables binary logging during its execution by ... Creates a report of the statements running on the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For example, the SUM_LOCK_TIME and SUM_ERRORS columns in statement summary tables are the aggregates of the LOCK_TIME and ERRORS columns in events_statements_current table. The prepared_statements_instances table has these additional summary ...(The ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... The handler_action value indicates what action the ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can check partitions for errors in much the same way that you can use CHECK TABLE with nonpartitioned tables. A ...