Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
This column and TP_PROCESSING_THREAD_NUMBER serve as a foreign key into the tp_thread_state table. The tp_connections table contains one row per connection managed by the Thread Pool plugin. Each row provides information about the current state of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
In this case, they go into the reserved state and remain until needed again. The tp_thread_group_state table has one row per thread group in the thread pool. Each row provides information about the current state of a group. The ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
To view events from the log, send mysqlbinlog output into a paging program: $> mysqlbinlog binlog_files | more Alternatively, save the output in a file and view the file in a text editor: $> mysqlbinlog binlog_files > tmpfile $> ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
mysql> SELECT USER(), CURRENT_USER(); +------------------+-------------------+ | USER() | CURRENT_USER() | +------------------+-------------------+ | myuser@localhost | manager@localhost | +------------------+-------------------+ For simplicity, ...
https://dev.mysql.com/doc/refman/8.4/en/recovery-from-backups.html
To not lose them, we would have needed to have the MySQL server store its MySQL binary logs into a safe location (RAID disks, SAN, ...) different from the place where it stores its data files, so that these logs were not on the destroyed disk. Now, ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.4/en/replica-io-thread-states.html
Waiting to reconnect after a failed binlog dump request If the binary log dump request failed (due to disconnection), the thread goes into this state while it sleeps, then tries to reconnect periodically. The following list shows the most common ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
When the feature is disabled, you do not need to configure the replication channel on the secondary group members, but if the primary goes offline or into an error state, replication stops for the channel. You can use the asynchronous connection ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
replication_connection_status: current status of the connection to the source, provides information on the last and current transaction the connection thread queued into the relay log. MySQL supports delayed replication such that a replica server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...