PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The Performance Schema must be enabled or this table is empty. This information enables the server to avoid caching bad or missing host names during temporary DNS failures, which would negatively affect clients forever. For the rationale why this ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
An instrument disabled in this table produces no events regardless of the contents of the other production-related setup tables. An instrument enabled in this table is permitted to produce events, subject to the contents of the other tables. This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
This section explains these concepts and is essential reading before attempting to modify the replication mode of an online server. This means it is possible to have a replication topology that has servers using both anonymous and GTID transactions.
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. You cannot disable GTID transactions online on any single ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
To determine the default command option and system variable values used by the server, execute this command: $> mysqld --verbose --help The command produces a list of all mysqld options and configurable system variables. Its output includes the ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit key_cache_age_threshold This section describes the syntax for referring to structured variables. If this were not true (that is, if ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
In this case, the column has no automatic properties at all. In this case, the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses that specify automatic initialization and updating are available, but are not assigned to any TIMESTAMP ... TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. An “account” in this context corresponds to a row in the mysql.user system table. In this ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This plugin exposes a set of system variables that enable you to configure password policy. This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. This is true ...