PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
In MySQL, the DECIMAL type has several synonyms: NUMERIC, DEC, FIXED. In MySQL, types that are synonymous with FLOAT or DOUBLE are DOUBLE PRECISION and REAL. Number literals include exact-value (integer and DECIMAL) literals and approximate-value ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...The user_defined_functions table lists loadable functions installed using CREATE FUNCTION as well as loadable functions installed automatically by components or ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-memory-management.html
The innodb_ddl_buffer_size variable, introduced in MySQL 8.0.27, defines the maximum buffer size for online DDL operations. Prior to MySQL 8.0.27, innodb_sort_buffer_size variable defines the buffer size for online DDL operations that create or ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
The number of parallel threads that sort and load data is controlled by the innodb_ddl_threads variable, introduced in MySQL 8.0.27. The maximum setting is 256, which is the maximum number for all sessions. The actual number of threads that scan the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Database administrators should use the following guidelines to keep passwords secure. Access to this table should never be granted to any nonadministrative accounts. Account ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_progress table has these columns: ID A unique cloning operation identifier in the current MySQL server instance. BEGIN_TIME A timestamp in 'YYYY-MM-DD ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
Note The Performance Schema tables described here are available as of MySQL 8.0.17. The Performance Schema clone plugin tables are used only on the recipient MySQL server instance. The following sections describe the Performance Schema tables ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... Example object wait event summary ...