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/charset-repertoire.html
For the second call, the repertoire is UNICODE because the second argument is outside the ASCII range. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
Connection Volume Management To control the maximum number of clients the server permits to connect simultaneously, set the max_connections system variable at server startup or at runtime. It implements a thread pool that increases server ... This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
time The time in seconds that the thread has been in its current state. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. By default, rows are sorted by descending process ...They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Error messages returned from the server to the client are converted to the client character set automatically, as with metadata. Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The expression just described has several implications for permitted table definitions: Using long column names can reduce the maximum number of columns, as can the inclusion of ENUM or SET columns, or use of column comments. MySQL represents each ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
You can switch from statement-based to row-based binary logging format at runtime even when temporary tables have been created. When executing on the replica, a table lock is taken on all tables involved, and then the rows are applied in batch mode.
https://dev.mysql.com/doc/refman/5.7/en/replication.html
MySQL 5.7 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 16.3.10, “Delayed Replication”. Replication enables data from one MySQL database server (the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
Once the connection retry limit is reached the recovery procedure terminates with an error. In earlier versions of Group Replication, when reaching out to a donor, recovery could only detect connection errors due to authentication issues or some ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. For example, the maximum number of ordered indexes in the cluster is determined ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_hosts_lost The number of times a row could ...Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest ...