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/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... Note As of MySQL 8.0.14, the INFORMATION_SCHEMA thread pool tables are also available as Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
A row can become fragmented (stored in noncontiguous pieces) when it is made longer as a result of an update. If a string column has a length of zero after trailing space removal, or a numeric column has a value of zero, it is marked in the bitmap ... Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...The value is one of READ, READ WITH SHARED LOCKS, READ HIGH PRIORITY, READ NO INSERT, WRITE ALLOW WRITE, WRITE CONCURRENT INSERT, WRITE LOW PRIORITY, or ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 7.1.9, “Using System Variables”. To set the max_allowed_packet variable ...Most of these program variables also can be set at server startup by using the same syntax that applies to specifying program ...
https://dev.mysql.com/doc/refman/8.0/en/using-gdb-on-mysqld.html
In this case, you can only have one thread active at a time. Use the --gdb option to mysqld to install an interrupt handler for SIGINT (needed to stop mysqld with ^C to set breakpoints) and disable stack tracing and core file handling. It is very ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-build-configuration.html
For example, to exclude stage and statement instrumentation, do this: $> cmake . If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has ...It ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-options.html
If values specified at startup time are incorrect, the ddl_rewriter plugin may fail to initialize properly and the server does not load it. This section describes the command options that control operation of the ddl_rewriter plugin. To control ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
Because of changes to data (and supporting statistics) it may produce a different result from running EXPLAIN on the equivalent query text. For example, if you are running a statement in one session that is taking a long time to complete, using ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-write-consensus.html
This section explains how to inspect and configure the maximum number of consensus instances at any time for a group. This maximum is referred to as the event horizon for a group, and is the maximum number of consensus instances that the group can ...This enables you to fine tune the performance of your Group Replication ...