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/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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade.html
The basic process of upgrading members of a group is the same as upgrading stand-alone instances, see Chapter 3, Upgrading MySQL for the actual process of doing upgrade and types available. While you are in the process of upgrading an online group, ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/locking-issues.html
External locking occurs when the server and other programs lock MyISAM table files to coordinate among themselves which program can access the tables at which time. This type of locking is internal because it is performed entirely by the server and ... MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. They are: Greedy search: With an N-table join, this could explore factorial(N) plans. Range ...