Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON When the server starts, it sees ... This ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
Installation on Linux using a server RPM or Debian distribution from Oracle. Start the server and make sure that it can be accessed. For instructions, see Section 2.9.2, “Starting the Server”, and Section 2.9.3, “Testing the Server”. This ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
For REPAIR TABLE, the same principle applies, but because the repair is done by the server, you set server system variables instead of myisamchk variables. For example: SET @old_myisam_sort_buffer_size = @@GLOBAL.myisam_max_sort_file_size; SET ...
https://dev.mysql.com/doc/refman/8.4/en/replication-compatibility.html
The use of more than two MySQL Server versions is not supported in replication setups involving multiple sources, regardless of the number of source or replica MySQL servers. The server version is recorded in the binary log for each transaction for ... MySQL supports replication from an older source to a newer replica for version combinations where we support upgrades from the source version to the replica version as described at Section 1.3, “MySQL Releases: Innovation and LTS” and Section 3.2, “Upgrade ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group member. The PRIVILEGE_CHECKS_USER account provides an ...You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
The MySQL server tracks the logging mode that was in effect when each temporary table was created. When a given client session ends, the server logs a DROP TEMPORARY TABLE IF EXISTS statement for each temporary table that still exists and was ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. Support The server's level of support for the storage engine, as shown in the following table. A value of DISABLED occurs either because the server ...This is particularly useful for checking whether a storage engine is supported, or to see what the default engine ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
REPLICA_SIDE_DISABLED indicates that the creation of the event occurred on another MySQL server acting as a replication source and replicated to the current MySQL server which is acting as a replica, but the event is not presently being executed on ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a ...