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/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you move from one MySQL series to the next. Perform any table repair or rebuilding operations needed to re-create database ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
INSTALL COMPONENT adds the component to the mysql.component table (an InnoDB table), and the components to load at startup are read from this table, which is only accessible after InnoDB is initialized. Note Loading a log component implicitly using ... In MySQL 8.0, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. Issuing a RESET REPLICA ALL statement without a FOR CHANNEL channel clause when multiple replication channels exist deletes all replication ... RESET REPLICA [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET REPLICA makes the replica forget its position in the source's binary ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/8.0/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If so, the routine uses the variable value without reading the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-elements.html
Prior to MySQL 8.0.14, the monitoring tables are INFORMATION_SCHEMA tables; see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”. The INFORMATION_SCHEMA tables now are deprecated; expect them to be removed in a future version of MySQL. For ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to ... Required credentials for clients that connect to the MySQL server can include a ...