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/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of ...The bootstrap should only be done by a single server, the one that starts the group and only ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-installation.html
Note Only one keyring component or plugin should be enabled at a time. MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. To be usable by the server, the component library ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are checking). If you are going to repair a table from the command line, you must first stop the mysqld server. Note that ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
mysql> CALL sys.statement_performance_analyzer('delta', 'mydb.tmp_digests_ini', 'with_runtimes_in_95th_percentile'); +-----------------------------------------+ | Next Output | +-----------------------------------------+ | Queries with Runtime in ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. Some versions of Windows have ...This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. In most respects, account names are similar to MySQL role names, with some ...This section describes the syntax for account names, including special values and wildcard ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...
https://dev.mysql.com/doc/refman/8.0/en/clone.html
CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] 'clone_dir'; | INSTANCE FROM 'user'@'host':port IDENTIFIED BY 'password' [DATA DIRECTORY [=] 'clone_dir'] [REQUIRE [NO] SSL] } The CLONE statement is used to clone data locally or from a ...The 'clone_dir' directory is the full path of the local directory that data is cloned ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. To update the tables to the expected structure, perform the MySQL upgrade procedure. Another option for creating ...
https://dev.mysql.com/doc/refman/8.0/en/error-interfaces.html
For lists of server-side, client-side, and global (shared between server and clients) errors, see MySQL 8.0 Error Message Reference. Error information in MySQL is available in the server error log, at the SQL level, from within client programs, and ... Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and ...