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-management.html
(This means that in the examples just shown, the statements that explicitly name the account for jeffrey fail unless the current user is jeffrey.) This is true even if the change is attempted for another user by a privileged user; however, such a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
This is true by default; it is controlled using the DISABLE_PSI_THREAD CMake option. This is true by default; it is controlled using the performance_schema system variable. The MySQL process list indicates the operations currently being performed ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. This includes wait, stage, statement, and transaction events and affects logging to these ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
In SQL, the NULL value is never true in comparison to any other value, even NULL. The following statement returns no rows, because expr = NULL is never true for any expression: mysql> SELECT * FROM my_table WHERE phone = NULL; To look for NULL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
WRITESET_SESSION: Two transactions are considered dependent if either of the following statements is true: The transactions are dependent according to WRITESET. Startup Options Used with Binary Logging System Variables Used with Binary Logging You ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
server_uuid The MySQL server generates a true UUID in addition to the default or user-supplied server ID set in the server_id system variable. In addition, the replication receiver thread generates a warning if either of the following is true: No ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
If the statement changes many rows, row-based replication may write significantly more data to the binary log; this is true even for statements that are rolled back. For most users, the mixed replication format should provide the best combination of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...