Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-account-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. The session_account_connect_attrs table has these indexes: Primary key on (PROCESSLIST_ID, ATTR_NAME) TRUNCATE TABLE is not permitted for ...For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. The session_connect_attrs table has these indexes: Primary key on (PROCESSLIST_ID, ATTR_NAME) TRUNCATE TABLE is not permitted for the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
row *************************** NAME: key_writes METER: mysql.myisam METRIC_TYPE: ASYNC COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: The number of physical writes of a key block from the MyISAM key cache to disk (Key_writes) ... The setup_metrics ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-tables.html
The global_status and session_status tables have these indexes: Primary key on (VARIABLE_NAME) The status_by_thread table contains the status of each active thread. The status_by_thread table has these indexes: Primary key on (THREAD_ID, ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variable-tables.html
The global_variables and session_variables tables have these indexes: Primary key on (VARIABLE_NAME) The variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the system variable is defined. The ... The ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
Parameter markers can be used only where data values should appear, not for SQL keywords, identifiers, and so forth. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to ...
https://dev.mysql.com/doc/refman/8.4/en/program-variables.html
Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for specifying a value multiplier can be used when setting a variable at program invocation time, but not to set the value ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysql_migrate_keyring A utility for migrating keys between one keyring component and another. Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates its ...