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/fulltext-natural-language.html
When MATCH() is used in a WHERE clause, as in the example shown earlier, the rows returned are automatically sorted with the highest relevance first as long as the following conditions are met: There must be no explicit ORDER BY clause. The ... By ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Important The mysql.session ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-monitoring.html
These Performance Schema replication tables also show information relating to Group Replication: replication_connection_status shows information regarding Group Replication, such as transactions received from the group and queued in the applier ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
The MEMBER_STATE column shows one of the Section 17.4.1, “Group Replication Server States”, in this case it shows that all three members in this group are ONLINE, and the MEMBER_ROLE column shows that there are two secondaries, and a single ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
Notes Character set information is also available from the SHOW CHARACTER SET statement. The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE CHARACTER_SET_NAME LIKE 'wild'] SHOW CHARACTER SET [LIKE 'wild'] ...The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
Notes Collation information is also available from the SHOW COLLATION statement. The following statements are equivalent: SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE 'wild'] SHOW COLLATION [LIKE 'wild'] . The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
SUPPORT The server's level of support for the storage engine, as shown in the following table. Storage engine information is also available from the SHOW ENGINES statement. The following statements are equivalent: SELECT * FROM ...This is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an event is created using ON SCHEDULE AT CURRENT_TIMESTAMP + '1:6' DAY_HOUR, and the event was created at ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
This is the same as the value shown for the id column in the ndbinfo.dict_obj_info table and the log_id column in the ndbinfo.logspaces and ndbinfo.logspaces tables for this undo log file. For NDB: This column shows which data node the data file or ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. The INNODB_BUFFER_PAGE table provides information about each page in the ...