Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. When the optional DATA DIRECTORY [=] 'clone_dir' clause is not used, a cloning operation ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
It enables authentication, role, SSL/TLS, resource-limit, password-management, comment, and attribute properties to be established for new accounts. Plugin names are stored in the plugin column of the mysql.user system table. Credentials that are ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
Joins are not directly supported; conditions involving multiple tables are pushed separately where possible. Previously, engine condition pushdown was limited to terms referring to column values from the same table to which the condition was being ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
To investigate database page corruption, you might dump your tables from the database with SELECT ... In such cases, you can use the innodb_force_recovery option to force the InnoDB storage engine to start up while preventing background operations ...Usually, most of the data obtained in this way is ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. It does not use the cache for TCP connections established using a loopback interface address (for example, 127.0.0.1 ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
This exception causes the following anomaly: If you update some rows in a table, a SELECT sees the latest version of the updated rows, but it might also see older versions of any rows. If other sessions simultaneously update the same table, the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
InnoDB uses session temporary tablespaces and a global temporary tablespace. Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. To avoid connecting to untrusted servers, clients can establish a secure connection and verify the server identity by connecting using the --ssl-mode=VERIFY_IDENTITY option and the appropriate ...The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. Note If you do this, you should not access MyISAM ...bulk_insert_buffer_size The size of the tree cache used in bulk insert ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. --check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since ...This is the default operation if you specify no option that selects an operation type ...