Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-loggers-table.html
This can be set to one of the following values: none error warn info debug DESCRIPTION: A text description of the logger. This can be one of the following: logger/sql/error_log logger/sql/general_log The General log does not have a log level. For ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-summary-tables.html
(The DIGEST_TEXT column contains the corresponding normalized statement digest text, but is neither a grouping nor a summary column. The QUERY_SAMPLE_TEXT, QUERY_SAMPLE_SEEN, and QUERY_SAMPLE_TIMER_WAIT columns also are neither grouping nor summary ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-system-variables.html
performance_schema_max_sql_text_length Command-Line Format --performance-schema-max-sql-text-length=# System Variable performance_schema_max_sql_text_length Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 1024 Minimum ...
https://dev.mysql.com/doc/refman/9.7/en/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. After you have created spatial columns, you can populate them with spatial data. For ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-decimal-characteristics.html
(There is also a limit on how long the text of DECIMAL literals can be; see Section 14.25.3, “Expression Handling”.) Values for DECIMAL columns are stored using a binary format that packs nine decimal digits into 4 bytes. This section discusses ...
https://dev.mysql.com/doc/refman/9.7/en/purge-binary-logs.html
(Bug #18199, Bug #18453) To handle such errors, edit the .index file (which is a simple text file) manually to ensure that it lists only the binary log files that are actually present, then run again the PURGE BINARY LOGS statement that failed.
https://dev.mysql.com/doc/refman/9.7/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/9.7/en/replica-sql-thread-states.html
The Info column for the SQL thread may also show the text of a statement. The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. Set the terminology_use_previous system ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-functions.html
The GET_LOCK(), RELEASE_LOCK(), IS_FREE_LOCK(), and IS_USED_LOCK() functions that handle user-level locks are replicated without the replica knowing the concurrency context on the source. INTO, and then store the variable in the table, like this: ...