Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-logging.html
The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-indexes-create.html
In the index field description, "TEXT(40)" represents the number of characters to index, and "required": True specifies that the field is required to exist in the document. mysql-js> db.countryinfo.createIndex("name", {"fields": [{"field": "$.Name", ... Indexes are used to find documents with specific field values ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-index.html
In the index field description, "TEXT(40)" represents the number of characters to index, and "required": True specifies that the field is required to exist in the document. mysql-py> db.countryinfo.create_index("name", {"fields": [{"field": ...
https://dev.mysql.com/doc/refman/9.7/en/online-ddl-parallel-thread-configuration.html
Parallel scan is not supported on tables defined with a full-text index. The default setting is calculated by the number of available logical processors on the system divided by 8, with a minimum default value of 4. The maximum setting is 256, which ...
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
Many option files are plain text files, created using any text editor. In the latter context, if “x” is not a valid escape sequence character, \x becomes “x” rather than \x. Most MySQL programs can read startup options from option files ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
There are two exceptions to this restriction: When partitioning by [LINEAR] KEY, it is possible to use columns of any valid MySQL data type other than TEXT or BLOB as partitioning keys, because the internal key-hashing functions produce the correct ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-log-table.html
It also includes the full text of error messages to support more free-form analysis. Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. DIGEST_TEXT The normalized statement digest text, or NULL if the statements_digest consumer is no. Consequently, values selected from the ...The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-status-by-worker-table.html
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE The message text for the last transient error that caused the transaction to be retried. APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE The message text for the last transient error that ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html
Possible values for variables of non-numeric types are often shown in the text of the DOCUMENTATION column; otherwise, see the variable's description in the Manual. DOCUMENTATION A description of the variable; this is the same text as found in the ... The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and ...