Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 8.4. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
If the Performance Schema itself is disabled, PS_THREAD_ID() produces an error. MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
For example, the SUM_LOCK_TIME and SUM_ERRORS columns in statement summary tables are the aggregates of the LOCK_TIME and ERRORS columns in events_statements_current table. The Performance Schema maintains tables for collecting current and recent ...
https://dev.mysql.com/doc/refman/8.4/en/perl-support-problems.html
If you get the following errors from DBD::mysql, you are probably using gcc (or using an old binary compiled with gcc): /usr/bin/perl: can't resolve symbol '__moddi3' /usr/bin/perl: can't resolve symbol '__divdi3' Add -L/usr/lib/gcc-lib/... If Perl ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to floating-point error. Floating-point numbers sometimes cause confusion because they are approximate and not stored as ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an error occurs rather than a warning because, in effect, no key is used to determine which rows to modify. The ...