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/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
MYSQL_TEST_LOGIN_FILE is the path name of the login path file (the file created by mysql_config_editor). The UMASK and UMASK_DIR variables, despite their names, are used as modes, not masks: If UMASK is set, mysqld uses ($UMASK | 0600) as the mode ... This section lists environment variables that are used directly or indirectly by ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
authentication_kerberos_service_key_tab Command-Line Format --authentication-kerberos-service-key-tab=file_name System Variable authentication_kerberos_service_key_tab Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row *************************** Privilege: Create temporary tables Context: Databases ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
Do not forget to use MAX_ROWS and AVG_ROW_LENGTH when you create tables. Important MySQL 8.0 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. MySQL Installer automatically installs MySQL Server and ...Users should make sure the package has been installed on the system before installing the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. You can enforce a high degree of consistency with the default REPEATABLE READ level, for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...