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/replication-privilege-checks-gr.html
Group Replication requires every table that is to be replicated by the group to have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key. You may set the REQUIRE_TABLE_PRIMARY_KEY_CHECK option of the CHANGE ... From MySQL 8.0.19, as well as securing asynchronous and semi-synchronous replication, you may choose to use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). Semisynchronous replication is implemented using plugins, which must be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database. Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database ...
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. Note The scheduler component is included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.0/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
You can tell the server to write general query and slow query entries to log tables, log files, or both. MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has ...
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, and server extensions. MySQL supports an plugin API that enables creation of server plugins. Plugins can ...
https://dev.mysql.com/doc/refman/8.0/en/set-resource-group.html
Thread IDs can be determined from the Performance Schema threads table. An alternative to SET RESOURCE GROUP is the RESOURCE_GROUP optimizer hint, which assigns individual statements to a resource group. SET RESOURCE GROUP group_name [FOR thread_id ...