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/sys-memory-global-total.html
The memory_global_total and x$memory_global_total views have these columns: total_allocated The total bytes of memory allocated within the server.
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-tables.html
The following sections describe sys schema tables and triggers. ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...