PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
The CREATE SERVER statement updates the rows in the mysql.servers table. If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-launching.html
Make sure the user is present in the server and that mysql_upgrade was ran after a server update. It is first necessary to ensure that the Group Replication plugin is installed on server s1. If you used plugin_load_add='group_replication.so' in the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following requirements. Transactions are executed optimistically and then, at commit time, are checked for conflicts. If there ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-privileges-table.html
In the output from SHOW FULL COLUMNS, the privileges are all in one column and in lowercase, for example, select,insert,update,references. The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
Although you can select INFORMATION_SCHEMA as the default database with a USE statement, you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them. INFORMATION_SCHEMA provides access to database metadata, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html
The currently authenticated account has the UPDATE or SELECT privilege for the mysql.user system table. The USER_ATTRIBUTES table (available as of MySQL 8.0.21) provides information about user comments and user attributes. The USER_ATTRIBUTES table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
Inserts, updates, and deletes are optimized by an automatic mechanism called change buffering. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in ...