PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
If you set this option on a server s1, then when server s2 is establishing a connection to s1 for the purpose of engaging group communication, s1 first checks the allowlist before accepting the connection from s2. This address is not the same as the ... The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
In this case, manually remove the .isl file from the schema directory. Replicating the path in this case would cause the source and replica to create the table in same location. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = ... There are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
In this case, you could manually rename the tablespace file and restart crash recovery, or you could restart the server in recovery mode using the innodb_force_recovery option. To achieve point-in-time recovery after restoring a backup, you can ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
This backup should be updated regularly—perhaps even hourly—depending on your needs. Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the ...
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted automatically to the creator of a routine if necessary (and dropped from ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
Alternatively, if mysqld is not running, symlinking can be accomplished manually using ln -s from the command line. This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have write ...For files used by tables for other storage engines, you may get strange problems if you try to use symbolic ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
Objects in this schema include: Views that summarize Performance Schema data into more easily understandable form. You can drop the sys schema manually after initialization if it is unneeded. To permit this behavior to be suppressed, mysql_upgrade ... MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. You can use OPTIMIZE TABLE to analyze the table and pack it into a smaller format (for a reason to use OPTIMIZE TABLE, see ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.