PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. Support for DELETE, INSERT, ...Statements and Functions Full operator and function support in the SELECT list and WHERE clause of ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
The default password policy implemented by validate_password requires that passwords contain at least one uppercase letter, one lowercase letter, one digit, and one special character, and that the total password length is at least 8 characters. The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Scenario 7: On the same system as described in Scenario 6, a command that performs analytics needs to be executed daily, using the most up-to-date data. A transaction cannot be on-hold forever, and if the time held exceeds wait_timeout it returns an ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
Once table ts_1 has been created as shown, you can perform INSERT, SELECT, UPDATE, and DELETE statements on it just as you would with any other MySQL table. A tablespace contains one or more data files and one or more undo log file groups. Undo log ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
Ndb_conflict_fn_max: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to update and delete operations. Ndb_conflict_fn_max_del_win: Number of times that NDB replication conflict resolution ...ndb-log-empty-epochs: When enabled, causes epochs in which there were no changes to be written to ndb_apply_status and ndb_binlog_index tables, even when --log-slave-updates is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
The I/O patterns for undo logs make undo tablespaces good candidates for SSD storage. The default 16KB page size is appropriate for a wide range of workloads, particularly for queries involving table scans and DML operations involving bulk updates.
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
Time Zone System Tables These system tables contain time zone information: time_zone: Time zone IDs and whether they use leap seconds. A broad categorization is that the mysql schema contains data dictionary tables that store database object ...It ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
The I/O patterns for undo logs make undo tablespaces good candidates for SSD storage. Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be accepted. The ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
It also brings the Performance Schema, INFORMATION_SCHEMA, and sys databases up to date for MySQL 8.0, and examines all user databases for incompatibilities with the current version of MySQL. It also brings the Performance Schema, ... This section ...For details about what may need upgrading, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...