PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/8.0/en/compiling-for-debugging.html
In this case, you can try to add -g using the CMAKE_C_FLAGS and CMAKE_CXX_FLAGS CMake options and not use -DWITH_DEBUG=1. If they find something “unexpected,” an entry is written to stderr, which mysqld_safe directs to the error log! This also ... If you have some very specific problem, you can always try to debug ...
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time. You can check the health of a MyISAM table using the CHECK TABLE statement, and repair a corrupted MyISAM table with ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-server.html
If mysqld does not want to start, verify that you have no my.cnf files that interfere with your setup! You can check your my.cnf arguments with mysqld --print-defaults and avoid using them by starting with mysqld --no-defaults .... If mysqld starts ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. A range of 400 thousand space IDs is reserved for session temporary tablespaces. Session temporary ...The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-compression-tables.html
There are two pairs of InnoDB INFORMATION_SCHEMA tables about compression that can provide insight into how well compression is working overall: INNODB_CMP and INNODB_CMP_RESET provide information about the number of compression operations and the ...INNODB_CMPMEM and INNODB_CMPMEM_RESET provide information about the way memory is allocated for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The operation takes a long time and concurrent DML modifies the table so much that the size of ...The changes made by the concurrent DML take precedence, and the ALTER TABLE operation is effectively rolled ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM ...
https://dev.mysql.com/doc/refman/8.0/en/json-functions.html
For discussion of the JSON data type and additional examples showing how to use these functions, see Section 13.5, “The JSON Data Type”. Functions that return JSON values always perform normalization of these values (see Normalization, Merging, ... The functions described in this section perform operations on JSON ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value ...