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/pluggable-storage-common-layer.html
A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific ...From a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The keyring service handles the creation, retrieval, and deletion of the binary log encryption keys. A server instance only creates and removes keys generated for itself, but it can read keys generated for other instances if they are stored in the ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. Tables are created or their structure modified, and data is inserted, deleted, and updated according to the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-security.html
To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
These statements are subject to rewriting: As of MySQL 8.0.12: SELECT, INSERT, REPLACE, UPDATE, and DELETE. The Rewriter plugin exposes system variables that enable plugin configuration and status variables that provide runtime operational ... MySQL ...Statements occurring within view definitions or stored programs are not subject to ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
You can control the general query and slow query logs during runtime. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information about the server ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown command. Depending on how shutdown was initiated, the server might create a thread to handle the shutdown process. If shutdown is the result of receiving a SIGTERM ...
https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html
By default, a transaction takes place in read/write mode, with both reads and writes permitted to tables used in the transaction. The READ WRITE and READ ONLY access modes also may be specified for an individual transaction using the START ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...Alternatively, add the bin directory to your PATH environment variable ...