Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. For each host name, the table counts the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-tables.html
The MySQL server maintains many status variables that provide information about its operation (see Section 7.1.10, “Server Status Variables”). Resets global status variables except those that the server never resets. Status variable information ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-handles-table.html
This information shows which table handles the server has open, how they are locked, and by which sessions. It is autosized by default; to configure the table size, set the performance_schema_max_table_handles system variable at server startup. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. To set the table size explicitly, set the performance_schema_users_size system variable at server startup. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. The shared library must be located in the MySQL server plugin directory, the location of which is ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-services.html
MySQL server plugins have access to server “plugin services.” The plugin services interface complements the plugin API by exposing server functionality that plugins can call. For developer information about writing plugin services, see MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math.html
Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid data. The choice of which approach to take is determined by the setting of the server SQL mode. For information about ... MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
The SHOW REPLICA STATUS statement, which you must execute on each replica, provides information about the configuration and status of the connection between the replica server and the source server. The most common task when managing a replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
To configure this feature, the replication channel and the replication user account and password for the channel must be set up on all the member servers in the replication group, and on any new joining members. You can set up the replication ...