PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 8.0. 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.0/en/performance-schema-functions.html
If the Performance Schema itself is disabled, PS_THREAD_ID() produces an error. As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
For example, an error in a collation might have been corrected, necessitating a table rebuild to update the indexes for character columns that use the collation. This section describes how to rebuild or repair tables or indexes, which may be ...