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/performance-schema-restrictions.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. Results for queries that refer to tables in the performance_schema database are not saved in the query cache. The Performance Schema avoids ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR ...Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or ...
https://dev.mysql.com/doc/refman/5.7/en/replication-implementation.html
Replication is based on the replication source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The binary log serves as a written record of all events that modify database structure or content ...Each replica that connects to the source requests a copy of the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
Replication enables data from one MySQL database server (the source) to be copied to one or more MySQL database servers (the replicas). Depending on the configuration, you can replicate all databases, selected databases, or even selected tables ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
If you upgrade in place, the process replaces the modified files. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Parameters in the message template are replaced with values that apply to a specific error occurrence: Identifiers such as table or column names use UTF-8 internally so they are copied as is. This section describes how the MySQL server uses ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. Explicit Default Handling Implicit Default Handling Explicit Default Handling A DEFAULT value clause in a data type specification explicitly indicates a default value for a ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
DELETE QUICK is most useful for applications where index values for deleted rows are replaced by similar index values from rows inserted later. DELETE is a DML statement that removes rows from a table. Single-Table Syntax DELETE [LOW_PRIORITY] ...