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/connection-access.html
Locking state is recorded in the account_locked column, which must have a value of 'N'. If the User column value is nonblank, the user name in an incoming connection must match exactly. It means that the user must connect without specifying a ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN statement. The shared library must be located in the MySQL server plugin directory, the ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. When performing foreign key checks, InnoDB sets shared row-level locks on child ...If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-general-info.html
(Locations where the sources can be obtained are listed later in this section.) Important MySQL NDB Cluster does not support InnoDB Cluster, which must be deployed using MySQL Server 8.0 with the InnoDB storage engine as well as additional ... MySQL ...MySQL Server 8.0 binaries cannot be used with MySQL NDB ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
To configure that setting explicitly at startup, use these lines in the server my.cnf file: [mysqld] protocol_compression_algorithms=zlib,zstd,uncompressed To set and persist the protocol_compression_algorithms system variable to that value at ...
https://dev.mysql.com/doc/refman/8.0/en/table-corruption.html
When the server detects MyISAM table corruption, it writes additional information to the error log, such as the name and line number of the source file, and the list of threads accessing the table. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
To use a single consensus leader, the group must be configured as follows: The group must be in single-primary mode. You must carry out a full reboot of the replication group (bootstrap) for Group Replication to pick up a change to this setting. The ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines. Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent).
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
Instead, the server directly accesses the table indexes using native file system caching. After the cache has been restructured, it becomes available again for caching indexes assigned to it, and the use of file system caching for the indexes ceases. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's old structure and creates a new one based on the new ...
https://dev.mysql.com/doc/refman/8.0/en/mysql.html
You can execute SQL statements in a script file (batch file) like this: mysql db_name < script.sql > output.tab On Unix, the mysql client logs statements executed interactively to a history file. When used noninteractively (for example, as a ...