Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
If a events_statements_summary_by_digest row already exists with the digest value for the statement that just completed, statistics for the statement are aggregated to that row. The Performance Schema maintains tables for collecting current and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain current events at different levels of the event ...
https://dev.mysql.com/doc/refman/8.4/en/perl-support-problems.html
For example, if the linker cannot find libc because it is in /lib and the link command specifies -L/usr/lib, change the -L option to -L/lib or add -L/lib to the existing link command. If Perl reports that it cannot find the ../mysql/mysql.so ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
Unplugging a Storage Engine To unplug a storage engine, use the UNINSTALL PLUGIN statement: UNINSTALL PLUGIN example; If you unplug a storage engine that is needed by existing tables, those tables become inaccessible, but are still present on disk ... MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
A grant table reload affects privileges for each existing client session as follows: Table and column privilege changes take effect with the client's next request. If the mysqld server is started without the --skip-grant-tables option, it reads all ...
https://dev.mysql.com/doc/refman/8.4/en/query-attribute-components.html
Purpose: Implements the mysql_query_attribute_string() function that takes an attribute name argument and returns the attribute value as a string, or NULL if the attribute does not exist. A component service provides access to query attributes (see ...
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-logs-status.html
Then you can use a CHANGE REPLICATION SOURCE TO statement with the SOURCE_LOG_FILE and SOURCE_LOG_POS options to tell the replica to re-read the binary logs from the source from that point (provided that the required binary logs still exist on the ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO. To activate asynchronous connection failover ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
Existing binary log files and relay log files still present on the server are not encrypted, but you can purge them if they are no longer needed. MySQL binary log files and relay log files can be encrypted, helping to protect these files and the ...