PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
This combination of options sets a cap on the number of threads that InnoDB processes at any one time, and allows each thread to do substantial work before being swapped out, so that the number of waiting threads stays low and operations can ...See ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. This may happen if you have been using the commands: mysql_options(..., MYSQL_OPT_READ_TIMEOUT,...) or mysql_options(..., ...You ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Statistics are also updated periodically by certain operations and under certain conditions. To improve the start up time of the mysql client and to updating statistics, you can turn off auto-rehash using the --disable-auto-rehash option. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, issue SHOW ENGINE INNODB STATUS to determine the cause of the most recent deadlock. For example, organize database operations into ...It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in ...