PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
This is the same as the process ID shown as the Id value in the output from SHOW PROCESSLIST. This is because the number of rows actually matched by the corresponding WHERE clause, and the number of rows changed can differ. This returns the number ... MySQL supports the following static probes, organized into groups of ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to initialize the pattern for the string and then uses this pattern to perform the search more quickly. (This type of index cannot be used to ...A ... Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or hash ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. This enables the character set to remain synchronized on the client and server if mysql is ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
In this case, it may be necessary to connect to the running server and enable keyring_operations manually using this statement: SET GLOBAL keyring_operations = ON; Online key migration provides for pausing keyring operations on a single running ...A ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
JSON Path Syntax Many of the JSON functions supported by MySQL and described elsewhere in this Manual (see Section 12.17, “JSON Functions”) require a path expression in order to identify a specific element in a JSON document. When the server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
This section provides a simplified outline of the steps involved when NDB Cluster data nodes are started. This occurs either when the cluster started for the very first time, or when all data nodes are restarted using the --initial option. This ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication plugins. This includes removal of the mysql_old_password authentication plugin ...Also, secure_auth cannot be disabled, and old_passwords cannot be set ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. This call may be protected by a ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
This enables the external user to be a proxy for the second user; that is, to assume the privileges of the second user: The external user is a “proxy user” (a user who can impersonate or become known as another user). In this case, employee_ext ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
This limit does not apply to output written to tserver standard error output (stderr). Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. SEMAPHORES This section reports ...