PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. PASSWORD ...) Passwords in those statements are rewritten to not appear literally in statement text written to the general query log, slow query ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. If the row is found in the hash table, the record in the target table is updated, and the row is deleted from the hash table.
https://dev.mysql.com/doc/refman/8.0/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...This advice applies whether you are using statement-based or row-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. In statement-based replication, session variables are not replicated properly ...sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
If you are already running a replication solution and want to convert your existing tables to another engine type, follow these steps: Stop the replica from running replication updates: mysql> STOP SLAVE; Or from MySQL 8.0.22: mysql> STOP REPLICA; ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/which-version.html
When preparing to install MySQL, decide which version and distribution format (binary or source) to use. The naming scheme in MySQL 8.0 uses release names that consist of three numbers and an optional suffix (for example, mysql-8.0.34). Taken ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
For usage information, see Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime” and Section 17.15.1.3, “Using the Compression Information Schema Tables”. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on ...Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. 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 ...However, too-frequent polling of a shared object such as a mutex or rw-lock by multiple threads can cause “cache ping pong”, which results in processors invalidating portions of each other's ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
An update operation most frequently executed for temporary tables is performed much faster when the updated node is in the cache and need not be read from disk first. The CACHE INDEX statement sets up an association between a table and a key cache, ...Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> SHOW VARIABLES LIKE 'key_buffer_size'; +-----------------+---------+ | Variable_name | Value | +-----------------+---------+ | key_buffer_size | 8384512 | +-----------------+---------+ Key cache variables are structured system variables that have a name and ...
https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...