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/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.
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
Searches for ligatures also match uppercase ligatures when using the gb18030_unicode_520_ci collation. Use this collation if you need to ensure that ligatures are sorted correctly. In MySQL, the gb18030 character set corresponds to the “Chinese ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. InnoDB performs row-level locking ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
Phone numbers can be given in very different formats: +7-12345-67 +7-12-345-67 +7 12 345 67 +7 (12) 345 67 +71234567 The problem raised by dealing with these kinds of values is that the varying permissible formats make searching for a specific phone ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
You can force client programs to use specific character set as follows: [client] default-character-set=charset_name This is normally unnecessary. However, when character_set_system differs from character_set_server or character_set_client, and you ... The MySQL server has a compiled-in default character set and ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
In this case, you must remove any remaining files or directories manually and issue the DROP DATABASE statement again. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. DROP {DATABASE | SCHEMA} ...
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 ...