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/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/create-trigger.html
CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } ...A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. For example, the maximum number of ordered indexes in the cluster is determined ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
TLS is sometimes referred to as SSL (Secure Sockets Layer) but MySQL does not actually use the SSL protocol for encrypted connections because its encryption is weak (see Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”). The ...
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/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/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/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/out-of-range-and-overflow.html
When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If strict SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note The last warning was repeated N times in last S seconds is written to the error log. Formerly, if a large number of such ...This continues as long as the 50 most recent such warnings were issued in 50 seconds or less; once the rate has decreased below this threshold, the warnings are once again logged ...