https://dev.mysql.com/mysqld-safe.html
--port=port_num The port number that the server should use when listening for TCP/IP connections. --socket=path The Unix socket file that the server should use when listening for local connections. mysqld_safe is the recommended way to start a ...
https://dev.mysql.com/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 will increase the maximum ...
https://dev.mysql.com/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/replication-options-reference.html
disconnect-slave-event-count: Option used by mysql-test for debugging and testing of replication. init_slave: Statements that are executed when a slave connects to a master. master-retry-count: Number of tries the slave makes to connect to the ...
https://dev.mysql.com/replication-upgrade.html
Restart them with the --skip-slave-start option so that they do not connect to the master. If you restart the master, you might also want to disallow client connections. For example, if all clients connect using TCP/IP, enable the skip_networking ...
https://dev.mysql.com/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/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/start-slave.html
START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...uuid: ...
https://dev.mysql.com/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/sys-ps-thread-id.html
See Section 12.22, “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. in_connection_id BIGINT UNSIGNED: The ID of ... Note As of MySQL 8.0.16, ps_thread_id() is deprecated and will be removed in a future MySQL ...
