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/connecting.html
It is possible to specify connection parameters without entering them on the command line each time you invoke a client program: Specify the connection parameters in the [client] section of an option file. This section describes use of command-line ...For information on establishing connections using URI-like connection strings or key-value pairs, for clients such as MySQL Shell, see Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
Here are some example debug control strings as they might be specified on a shell command line: --debug=d:t --debug=d:f,main,subr1:F:L:t,20 --debug=d,input,output,files:n --debug=d:t:i:O,\\mysqld.trace For mysqld, it is also possible to change DBUG ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...When you have ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mysqld.html
In this case, it is able to use any data node as a transaction coordinator and to read and update node data. row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-pluggable-authentication.html
Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary users. For general information about installing plugins, see Section 7.6.1, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-binary-log-transaction-compression-stats-table.html
The statistics cover all transactions written to the binary log and relay log from the time the server was started or the table was truncated. This table shows statistical information for transaction payloads written to the binary log and relay ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-coordinator-table.html
When the Performance Schema is disabled, local timing information is not collected, so the fields showing the start and end timestamps for buffered transactions are zero. For a multithreaded replica, the replica uses multiple worker threads and a ...For a multithreaded replica, the replication_applier_status_by_worker table shows the status of the worker ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Existing binary log files and relay log files that were present on the server when you started encryption are not encrypted. Data in motion in the replication event stream, which is sent to MySQL clients including mysqlbinlog, is decrypted for ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP REPLICA instruction remains in effect. Like START REPLICA, this statement may be used with the IO_THREAD and SQL_THREAD options to name ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-prerequisites.html
Enabling all the instruments and consumers just mentioned has a performance impact, so it is preferable to enable only the additional configuration you need. Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
Configuration changes made by updating this table persist across client sessions and server restarts. set_time The timestamp of the most recent modification to the row. (For example, the variable corresponding to the diagnostics.include_raw option ... This table contains sys schema configuration options, one row per ...