Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
From that point on, all updates sent by Web Client to Replica 1 are written to the binary log of Replica 1, which then contains every update sent to Replica 1 since Source became unavailable. If you fail to do this, the replicas may pick up stale ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. ERROR 1051 (42S02): Unknown table 'xx' At this point, if @a = 0, RESIGNAL pops the diagnostics area stack, ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-types.html
The term most commonly used is geometry, defined as a point or an aggregate of points representing anything in the world that has a location. The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
It works directly on the file to which the symlink points. Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are dropped. Note Symbolic link support as described here, along with the ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
(ROLLBACK to SAVEPOINT is permitted because it does not end a transaction.). For nontransactional tables, such rollback cannot be done, so although the statement fails, any changes performed prior to the point of the error remain in effect. To ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
The application caches this information to provide a central access point to it. If at some point the management application needs to change a server assignment (for example, to change it from permitting writes to read only), it changes the server's ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
The optimizer cannot predict the number of iterations because it cannot predict at what point the WHERE clause becomes false. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-innodb.html
At this point, the data corresponds to a single point in time. If you use the compressed backup feature, the .ibd files are renamed in their compressed form to .ibz files. The backed-up files, as they are originally copied, form a raw backup that ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-cluster-setup-creating.html
Note You can actually perform this step at any time up to the point where the software package is registered (using add package). At this point, the cluster is ready for use by MySQL NDB Cluster applications. In this section, we discuss the ...