Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table has these indexes: Primary key on (UDF_NAME) TRUNCATE TABLE is not permitted for the user_defined_functions table. The user_defined_functions table contains a row for each loadable function registered automatically ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-variable-tables.html
The user_variables_by_thread table has these indexes: Primary key on (THREAD_ID, VARIABLE_NAME) TRUNCATE TABLE is not permitted for the user_variables_by_thread table. The Performance Schema provides a user_variables_by_thread table that exposes ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-users-table.html
For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 29.12.8, “Performance Schema Connection Tables”. The users table contains a row for each user who has connected to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math.html
For example, you can treat a value that is too large for a column as an error rather than having the value truncated to lie within the range of the column's data type. MySQL provides support for precision math: numeric value handling that results ...
https://dev.mysql.com/doc/refman/8.4/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
After each transaction is committed, the binary log cache is reset: the memory buffer is cleared, any temporary file used to hold the binary log cache is truncated, and a new file password and initialization vector are randomly generated for use ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
(A truncation warning is issued in all such cases.) The default and maximum value is 1073741824 (1 GB); the minimum is 1024. This section explains the server options and system variables that apply to replica servers and contains the following: ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Innodb_truncated_status_writes The number of times output from the SHOW ENGINE INNODB STATUS statement has been truncated. The MySQL server maintains many status variables that provide information about its operation. You can view these variables ...