Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterstatus.html
To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary log. Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-16.html
With this fix, an error is thrown when the procedure call fails, and the result streamer is nullified. Version 8.0.16 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
ssl_ca Type File name Default Value NULL The path name of the Certificate Authority (CA) certificate file in PEM format. ssl_cert Type File name Default Value NULL The path name of the SSL public key certificate file in PEM format. ssl_cipher Type ...Invoking this executable starts the MySQL Cluster Manager Agent, to which you can connect using the mcm client (see Section 4.3, “Starting the MySQL Cluster Manager Client” and Chapter 5, MySQL Cluster Manager Client Commands for more ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
A Query instance represents a specific query with bound parameters. Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_IsClosed() returns 0 if ls is not closed, and NULL ...You can extract particular points of a LineString, count the number of points that it contains, or obtain its ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...