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/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. In this situation, Group Replication's failure detection mechanism recognizes after a short period of time that the member has left, and a ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ...You can also get this list using the mysqlshow --status db_name ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, issue SHOW ENGINE INNODB STATUS to determine the cause of the most recent deadlock. For example, organize database operations into ...It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When a floating-point or fixed-point column is assigned a value that exceeds the range ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump command. Making Backups by Copying Table Files MyISAM tables can be backed up by copying table files (*.MYD, *.MYI files, and associated ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, which is available from MySQL 8.0.17, this replication user is also used as the clone user on the donor, and requires the correct ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-midpoint_insertion.html
In these scans, a data page is typically accessed a few times in quick succession and is never touched again. Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL option file (my.cnf or my.ini) or changed at runtime ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%statement/%'; mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%stage/%'; Ensure that ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to cause the server to load it ...For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling ... The server-side auth_socket ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...A ...