PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
Example mysql> SELECT sys.ps_thread_id(260); +-----------------------+ | sys.ps_thread_id(260) | +-----------------------+ | 285 | +-----------------------+ . Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
+-----------------------------------------------------------------+ | sql_text | +-----------------------------------------------------------------+ | select hibeventhe0_.id as id1382_, hibeventhe0_.createdTime ... Traces all Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If sys_get_config() returns the default value and that value is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version-major.html
Example mysql> SELECT VERSION(), sys.version_major(); +------------------+---------------------+ | VERSION() | sys.version_major() | +------------------+---------------------+ | 5.7.24-debug-log | 5 | +------------------+---------------------+ .
https://dev.mysql.com/doc/refman/5.7/en/sys-version-minor.html
Example mysql> SELECT VERSION(), sys.version_minor(); +------------------+---------------------+ | VERSION() | sys.version_minor() | +------------------+---------------------+ | 5.7.24-debug-log | 7 | +------------------+---------------------+ .
https://dev.mysql.com/doc/refman/5.7/en/sys-version-patch.html
Example mysql> SELECT VERSION(), sys.version_patch(); +------------------+---------------------+ | VERSION() | sys.version_patch() | +------------------+---------------------+ | 5.7.24-debug-log | 24 | +------------------+---------------------+ .
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
Use FORCE INDEX for the scanned table to tell MySQL that table scans are very expensive compared to using the given index: SELECT * FROM t1, t2 FORCE INDEX (index_for_column) WHERE t1.col_name=t2.col_name; See Section 8.9.4, “Index Hints”. The ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
Some SELECT queries creates temporary SQL tables to hold intermediate results. On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary files. If TMPDIR is not set, MySQL uses ...