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/group-replication-use-cases.html
To summarize, MySQL Group Replication guarantees that the database service is continuously available. To summarize, MySQL Group Replication provides a highly available, highly elastic, dependable MySQL service. Tip To deploy multiple instances of ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The import server uses /tmp/mysql-files as the directory named by its secure_file_priv ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open files. To do so, encode the -c memcached option in the daemon_memcached_option configuration parameter in the MySQL ... This ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
As of MySQL 8.0.17, to enable detection of lock-acquisition deadlocks and enforcement that runtime execution is free of them, MySQL supports LOCK_ORDER tooling. The MySQL server is a multithreaded application that uses numerous internal locking and ...Within the server, the set of lock-related objects changes with implementation of new features and code refactoring for performance ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. Use the ...The ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
(For more information, see Section 12.8.5, “The binary Collation Compared to _bin Collations”.) Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information ... A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. This chapter provides a tutorial introduction to MySQL by ...If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
Note In MySQL 8.0, the validate_password plugin was reimplemented as the validate_password component. (For general information about components, see Section 7.5, “MySQL Components”.) The following instructions describe how to use the component, ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. A value can be a literal of any MySQL data type or an expression that resolves to a scalar value. In other words, it is a table value ...