Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
At server startup, you can specify this variable with no value or a value of ON or 1 to enable it, or with a value of OFF or 0 to disable it. Even when the Performance Schema is disabled, it continues to populate the global_variables, ...The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
Note If the replication source server or existing replica that you are copying to create the new replica has any scheduled events, ensure that these are disabled on the new replica before you start it. To stop all events from running on the new ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
Note If the replication source server or existing replica that you are copying to create the new replica has any scheduled events, ensure that these are disabled on the new replica before you start it. To stop all events from running on the new ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
Each of these strategies can be enabled or disabled using the following optimizer_switch system variable flags: The semijoin flag controls whether semijoins and antijoins are used. If the duplicateweedout semijoin strategy is disabled, it is not ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
To disable or enable the slow query log or change the log file name at runtime, use the global slow_query_log and slow_query_log_file system variables. Set slow_query_log to 0 to disable the log or to 1 to enable it. The slow query log consists of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica.html
For example: mysql> ALTER EVENT mysql.event DISABLE ON REPLICA; Remove the line skip-replica-start and event_scheduler=off entries you added to the my.cnf file of the replica in step 2. For example: mysql> ALTER EVENT mysql.event DISABLE ON REPLICA; ... MySQL Enterprise Backup allows you to set up a replica server (referred to as the “replica” below) by backing up the source server (referred to as the “source” below) and restoring the backup on a new replica, without having to stop the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-tls-cache.html
The following configuration options control the session caching: Client TLS session cache: client_ssl_session_cache_mode: Enables or disables the cache for client-router TLS sessions. Server TLS Cache: server_ssl_session_cache_mode: Enables or ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-standard.html
If disabled, use named pipes or shared memory (on Windows) or Unix socket files (on Unix). You can still use “`” to quote identifiers with this mode enabled. This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. In addition to naming your new connection in the field provided, you can select from the following tabs to specify connection values: Parameters, SSL, and ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-toolbar.html
To disable the default behavior, see the SQL Execution section of the MySQL Workbench Preferences dialog. The SQL query toolbar provides actions that enable you to create and manage queries. The following figure shows the set buttons in the ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is ...