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/replication-solutions-unexpected-replica-halt.html
The following information provides combinations of settings that are appropriate for different types of replica to guarantee recovery as far as this is under the control of replication. The following combination of settings on a replica is the most ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. For information about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not supported.
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...
https://dev.mysql.com/doc/refman/8.0/en/windows-start-command-line.html
The MySQL server can be started manually from the command line. To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command: C:\> "C:\Program Files\MySQL\MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
For example, a multiple-argument concatenation operation such as CONCAT(x,'Y') combines its arguments to produce a single string. The concatenation of two strings with different collations has a coercibility of 1. If one of the sides has a Unicode ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Within the search_str search string argument, the % and _ characters work as for the LIKE operator: % matches any number of characters (including zero characters), and _ matches exactly one character. To specify a literal % or _ character in the ...