Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication.html
For more information on the various types of replication supported by MySQL Server, and monitored by MySQL Enterprise Monitor, see Replication and Group Replication. Earlier versions of MySQL server require the Agent to be installed on the same host ...MySQL Enterprise Monitor supports monitoring of single-source tree hierarchy, circular replication, group replication, or complex, multi-level, multi-source ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/understanding-automatic-document-ids.html
X DevAPI relies on server-based document ID generation, which results in sequentially increasing document IDs across all clients. By setting the mysqlx_document_id_unique_prefix to a unique value per cluster instance, you can ensure document IDs are ...Document ID Properties The _id field of a document behaves in the same way as any other fields of the document during queries, except that its value cannot be changed once it has been inserted to the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/understanding-automatic-document-ids.html
X DevAPI relies on server-based document ID generation, which results in sequentially increasing document IDs across all clients. By setting the mysqlx_document_id_unique_prefix to a unique value per cluster instance, you can ensure document IDs are ...Document ID Properties The _id field of a document behaves in the same way as any other fields of the document during queries, except that its value cannot be changed once it has been inserted to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
mysql> CALL sys.ML_PREDICT_TABLE('census_data.census_train', @census_model, 'census_data.census_train_predictions', NULL); To view ML_PREDICT_TABLE results, query the output table. Depending on your MySQL version, we recommend the following: Before ... ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data and saves the results to an output ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...Default Value false Since Version 3.1.0 useStreamLengthsInPrepStmts Honor stream length parameter in 'PreparedStatement/ResultSet.set*Stream()' method calls? Default Value true Since Version ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-x-protocol-and-x-devapi.html
"lz4_message"; consult the description for the MySQL global variable 'mysqlx_compression_algorithms' for a list of supported and enabled algorithms), that defines the order and which algorithms will be attempted when negotiating connection ...If the ...Default Value PLAIN Since Version 8.0.8 xdevapi.compression X DevAPI-specific network traffic ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump command. To get a consistent backup, stop the server or lock and flush the relevant tables: FLUSH TABLES tbl_list WITH READ LOCK; You need ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
The clone plugin permits cloning data locally or from a remote MySQL server instance. The cloned data comprises a fully functional data directory, which permits using the clone plugin for MySQL server provisioning. Figure 7.1 Local Cloning ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and server. MySQL supports encrypted connections ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
The name and port number should match the host name (or IP address) and port number of the remote MySQL server instance you want to use as your remote table. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name ... To ...