PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
Using the table comment approach is recommended since it offers per-table control of the feature, and this aspect of the table schema is embedded in the table creation statement where it can be found easily by SQL-based tools. The text of the ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
The standard says that the definer of the view, which is the same as the owner of the view's schema, gets applicable privileges on the view (for example, SELECT) and may grant them. MySQL has no concept of a schema “owner”, so MySQL adds a ...If ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME: Strings that indicate the catalog, schema, and name for a violated constraint. CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME: Strings that indicate the catalog, schema, table, and column ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. Important When a database ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
MySQL Events have the following major features and properties: In MySQL, an event is uniquely identified by its name and the schema to which it is assigned. These properties include the event's name, timing, persistence (that is, whether it is ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
To see the default InnoDB stopword list, query the Information Schema INNODB_FT_DEFAULT_STOPWORD table. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-definition-statements.html
Schema changes and changes to the data that the object contains need to be handled through the same server while the schema operation has not yet completed and replicated everywhere. In a Group Replication topology, care needs to be taken when ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. You can verify this by logging into s1 and looking at its ... The group needs to ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-observability.html
This is where the instrumentation of Group Replication and Performance Schema becomes important. The entire state of the system (including the view, conflict statistics and service states) can be queried through performance_schema tables. For ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
You can monitor the internal workings of the storage engine by querying INFORMATION_SCHEMA tables. You can monitor the performance details of the storage engine by querying Performance Schema tables. InnoDB tables have the following benefits: If ...