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/performance-schema-replication-connection-status-table.html
LAST_ERROR_NUMBER, LAST_ERROR_MESSAGE The error number and error message of the most recent error that caused the I/O thread to stop. An error number of 0 and message of the empty string mean “no error.” If the LAST_ERROR_MESSAGE value is not ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
The server must be writeable (with the read_only system variable set to OFF) and have the Group Replication plugin installed. When the feature is active and correctly configured, if the primary that is replicating goes offline or into an error ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
If both sides have the same coercibility, then: If both sides are Unicode, or both sides are not Unicode, it is an error. For example, the following statement does not return an error: SELECT CONCAT(utf8mb4_column, latin1_column) FROM t1; It returns ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...For example, a ...
https://dev.mysql.com/doc/refman/8.0/en/xa.html
Support for XA transactions is available for the InnoDB storage engine. MySQL client programs must be able to send SQL statements and to understand the semantics of the XA statement interface. A global transaction involves several actions that are ...The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA ...In essence, this extends ACID properties “up a level” so that ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
If a filesort must be done, all rows that match the query without the LIMIT clause are selected, and most or all of them are sorted, before the first row_count are found. If you need only a specified number of rows from a result set, use a LIMIT ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). With myisamchk, you must make sure that the server does not use the tables at the same time so that ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html
For computations on multiple geometry values, all values must be in the same SRS or an error occurs. This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. Spatial values, or ...Each geometry value is associated with a spatial reference system (SRS), which is a coordinate-based system for geographic ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
(Bug #11754117, Bug #45670) This issue does not affect tables using the InnoDB storage engine, since an InnoDB table with an AUTO_INCREMENT column requires at least one key where the auto-increment column is the only or leftmost column. If it is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
innodb_buffer_data The total number of InnoDB data bytes allocated for the table. innodb_buffer_free The total number of InnoDB nondata bytes allocated for the table (innodb_buffer_allocated − innodb_buffer_data). These views summarize table ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
This file is located in the directory named by the character_sets_dir system variable. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; ... To add ...Choose a collation ID, as shown in Section 12.14.2, “Choosing a Collation ...