Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Clear the data node file systems (using ndbd --initial or ndbmtd --initial). Note Disk Data tablespace and log files are also removed by --initial. Point-in-time recovery—that is, recovery of data changes made since a given point in time—is ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%pam%'; +--------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------------+---------------+ | authentication_pam ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-model.html
With the value set to 0: The corresponding internal buffer is empty initially and no memory is allocated. With the value set to N > 0: The corresponding internal buffer is empty initially and no memory is allocated. Memory used depends on the load ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
For foreground threads (resulting from client connections), the initial values of the INSTRUMENTED and HISTORY columns in threads table rows are determined by whether the user account associated with a thread matches any row in the setup_actors ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
When the server starts, the global value of gtid_purged is initialized to a set of GTIDs. The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
Assume that you have the structure shown in Figure 19.4, “Redundancy Using Replication, Initial Structure”. Figure 19.4 Redundancy Using Replication, Initial Structure In this diagram, the Source holds the source database, the Replica* hosts are ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.4/en/reserved-accounts.html
One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory initialization, MySQL creates user accounts that should be considered reserved: ...This ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
The initial view is included if the diagnostics.include_raw configuration option is ON. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
open_streams Open_streams ASYNC COUNTER The number of streams that are open, used mainly for logging open_table_definitions Open_table_definitions ASYNC GAUGE COUNTER The number of cached table definitions open_tables Open_tables ASYNC GAUGE COUNTER ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. To tighten security if you have not yet assigned a password to the initial account, follow the ...This ...