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
Displaying 101 to 109
of 109 total results
- « Previous
- 9
- 10
- 11
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-account.html
Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. The value should match the THREAD_ID column from some ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return transaction information. Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +--------------+---------------------+ | VERSION() | sys.version_major() | +--------------+---------------------+ | 8.0.26-debug | 8 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +--------------+---------------------+ | VERSION() | sys.version_minor() | +--------------+---------------------+ | 8.0.26-debug | 0 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +--------------+---------------------+ | VERSION() | sys.version_patch() | +--------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
One way to avoid such problems is to use CAST() so that a value is not converted implicitly to a float-point number: mysql> SELECT CAST('9223372036854775807' AS UNSIGNED) = 9223372036854775806; -> 0 For more information about floating-point ... When ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...