PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-object-shapes.html
The return values 1 and 0 indicate true and false, respectively, except that distance functions return distance values. If any geometry argument is geometrically invalid, either the result is true or false (it is undefined which), or an error occurs. The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data types. The data types are listed here: Integer: All variants and aliases of MySQL integer data types are supported, including TINYINT, ...