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/audit-log-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The available scripts differ in the file name used to refer to the script: ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. This includes wait, stage, statement, and transaction events and affects logging to these ...
https://dev.mysql.com/doc/refman/8.0/en/binlog.html
(See Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”.) The 'str' value is a base 64-encoded string the that server decodes to determine the data change indicated by the corresponding event. It is generated by the ...To ...This statement can execute only format description events and row ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
This is why the value of the group_replication_bootstrap_group option was not stored in the instance's option file. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. mysql> CREATE ... The process of starting a group for the first time is called ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-block-size.html
This permits tuning of the performance of I/O operations for index files. When reading the big leaf nodes, the server pulls in a lot of unnecessary data, effectively preventing reading other leaf nodes. To control the size of blocks in the .MYI ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-prefpane.html
Figure 2.22 MySQL Preference Pane: Instances Figure 2.23 MySQL Preference Pane: Initialize Database The Configuration page shows MySQL Server options including the path to the MySQL configuration file. Figure 2.20 MySQL Preference Pane: Location The ... The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
For example, if analysis shows that the issue is not related to file I/O in a particular storage engine, disable the file I/O instruments for that engine. With each iteration, the Performance Schema output, particularly the events_waits_history_long ... The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this ...
https://dev.mysql.com/doc/refman/8.0/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...
https://dev.mysql.com/doc/refman/8.0/en/scheduler-component.html
At startup, the scheduler component registers the performance_schema.component_scheduler_tasks table, which lists the currently scheduled tasks and some runtime data about each one. Developers who wish to incorporate scheduler-queueing capabilities ... Note The scheduler component is included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration.html
In addition, the MySQL sys schema is a set of objects that provides convenient access to data collected by the Performance Schema; see Chapter 30, MySQL sys Schema. To use the option every time the server runs, put it in an option file. The MySQL ...