PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-metrics-table.html
The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-thread-pool-tables.html
The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 7.6.3, “MySQL Enterprise Thread Pool”). They provide information about thread pool operation: tp_connections: Information about ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. The tp_thread_state table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within ...
https://dev.mysql.com/doc/refman/9.7/en/persisted-system-variables.html
The MySQL server maintains system variables that configure its operation. A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. Many system variables are ...
https://dev.mysql.com/doc/refman/9.7/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For some MySQL installation methods, data directory initialization may be done for you ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover-source.html
To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this channel. GTID auto-positioning must be in use for the channel (SOURCE_AUTO_POSITION = ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-timeout.html
The global value of the system variable replica_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before stopping. Transactions are ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. When GTIDs are in use, all the information that the replica needs for synchronizing with ...