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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-encrypted-connections.html
For example, X Plugin can have SSL key, certificate, and certificate authority files that differ from those used for MySQL Server. These variables are described at Section 22.5.6.2, “X Plugin Options and System Variables”. Encryption per ...
https://dev.mysql.com/doc/refman/8.0/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...For ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
row *************************** Id: 2 User: system user Host: db: NULL Command: Connect Time: 1004 State: Has read all relay log; waiting for the replica I/O thread to update it Info: NULL *************************** 3. row ...row ... SHOW [FULL] ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. The recommendation initial setting for this system variable is the ...