PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
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-socket-summary-tables.html
These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per ...Each socket summary table has these summary columns containing aggregated values: COUNT_STAR, SUM_TIMER_WAIT, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT These columns aggregate all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.0), and that you have enabled a replication user and ...Use the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-configuration.html
A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume that you have two sources source1 and source2, and a replica replicahost. The replica replicates one database from each of ...Sources in a multi-source replication topology can be configured to use either GTID-based replication, or binary log position-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html
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 Replication. The group_replication_applier ...To ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups.html
To use replication as a backup solution, replicate data from the source to a replica, and then back up the replica. The replica can be paused and shut down without affecting the running operation of the source, so you can produce an effective ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-rbr-monitoring.html
For example to get progress for update events issue: mysql> SELECT WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current -> WHERE EVENT_NAME LIKE 'stage/sql/Applying batch of row changes (update)' If ... The current progress ...For background information, see Section 29.12.5, “Performance Schema Stage Event ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. semanage fcontext -l | grep -i mysql Setting the MySQL Data Directory Context The default data directory location is /var/lib/mysql/; and the SELinux context used is mysqld_db_t. For example: ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, the MySQL service fails to start: $> systemctl start mysqld.service Job for mysqld.service failed because the control ... Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, checking for access denial messages in the SELinux audit log, and placing SELinux back into enforcing mode after problems are ...
https://dev.mysql.com/doc/refman/8.0/en/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. See Section 15.7.6.2, “SET CHARACTER SET Statement”, and Section 15.7.6.3, “SET NAMES Statement”.
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). Updates occur as though the index was Cartesian, even though the column might contain a mix of Cartesian and ...The ...