PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
--port=port_num Command-Line Format --port=number Type Numeric The port number that the server should use when listening for TCP/IP connections. --socket=path Command-Line Format --socket=file_name Type File name The Unix socket file that the server ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
Other mutexes have an instance per connection, or per page in various caches and data buffers, so the number of instances varies over time. Increasing the maximum number of connections or the maximum size of some buffers increases the maximum number ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs.html
The replica's connection metadata repository contains information that the replication receiver thread needs to connect to the replication source server and retrieve transactions from the source's binary log. The replica's connection metadata ... A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
In addition, InnoDB Cluster interfaces seamlessly with MySQL Router, which enables your applications to connect to the cluster without writing your own failover process. After you have performed this procedure, the replica connects to the source and ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Restart them with the --skip-slave-start option, or from MySQL 8.0.24, the skip_slave_start system variable, so that they do not connect to the source. If you restart the source, you might also want to disallow client connections. For example, if ...
https://dev.mysql.com/doc/refman/8.0/en/show-status.html
A global status variable may represent status for some aspect of the server itself (for example, Aborted_connects), or the aggregated status over all connections to MySQL (for example, Bytes_received and Bytes_sent). With a SESSION modifier, the ...
https://dev.mysql.com/doc/refman/8.0/en/show-variables.html
These are the values used to initialize the corresponding session variables for new connections to MySQL. With a SESSION modifier, the statement displays the system variable values that are in effect for the current connection. SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-id.html
See Section 14.21, “Performance Schema Functions” Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. Parameters in_connection_id BIGINT UNSIGNED: ... Note As of MySQL 8.0.16, ps_thread_id() is deprecated and subject to removal in a future MySQL ...