PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
Only protocol handshake errors are counted, and only for hosts that passed validation (HOST_VALIDATED = YES). The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain ...The host_cache_size system variable controls the size of the host cache, as well as the size of the host_cache ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
This section provides information about restrictions on and limitations of replication with GTIDs. When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html
If you are planning to shut down the source to create a data snapshot, you can optionally skip this procedure and instead store a copy of the binary log index file along with the data snapshot. In a different session on the source, use the SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-monitoring.html
To check the current values of the status variables, use SHOW STATUS: mysql> SHOW STATUS LIKE 'Rpl_semi_sync%'; Beginning with MySQL 8.0.26, new versions of the source and replica plugins are supplied, which replace the terms “master” and ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines.html
Banks, for example, use stored procedures and functions for all common operations. This provides a consistent and secure environment, and routines can ensure that each operation is properly logged. In such a setup, applications and users would have ...A stored routine is a set of SQL statements that can be stored in the ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
In other words, it is a table value constructor which also functions as a standalone SQL statement. The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. See the ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information about installing or uninstalling plugins and loadable functions, see ...To avoid this overhead, do not install it unless you plan to use ...
https://dev.mysql.com/doc/refman/8.0/en/scheduler-component.html
At startup, the scheduler component registers the performance_schema.component_scheduler_tasks table, which lists the currently scheduled tasks and some runtime data about each one. After executing the task list, removes the tasks from the active ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
Please note the following: If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. It also reads option files and supports ...