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/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
The following checks are made when Group Replication is deployed in multi-primary mode: If a transaction is executed under the SERIALIZABLE isolation level, then its commit fails when synchronizing itself with the group. If a transaction executes ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-runtime-configuration.html
Specific Performance Schema features can be enabled at runtime to control which types of event collection occur. The timer applies to instruments where their name begins with an element matching the NAME value. If there are Performance Schema ...If ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. That might be useful, for example, after you have ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before displaying it. You can execute SQL statements in a script file (batch file) like this: mysql db_name ... mysql is a simple SQL shell with input line editing ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
The privileges required at function invocation time can be checked only as it executes: For different invocations, different execution paths within the function might be taken. Views created before MySQL 5.7.3 containing ORDER BY integer can result ...The view definition is “frozen” at creation time and is not affected by subsequent changes to the definitions of the underlying ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
These provide logical copies of the file system at a given point in time, without requiring a physical copy of the entire file system. (For example, the implementation may use copy-on-write techniques so that only parts of the file system modified ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. REMAINING_DELAY If the replica is waiting for DESIRED_DELAY seconds to pass since the source applied an event, this field contains the number of delay seconds ...The ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
A client-side authentication plugin is available that enables clients to send passwords to the server as cleartext, without hashing or encryption. Table 6.12 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name ...