Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
By default, all the files under the database subdirectories in the data directory are included in the backup, so that the backup includes data from all MySQL storage engines, any third-party storage engines, and even any non-database files in that ...This section explains options you can use to selectively back up or exclude ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-upgrade.html
Important You may encounter technical challenges during a server upgrade or downgrade, and it is beyond the function of MySQL Enterprise Backup, as a backup tool, to ensure a successful server upgrade or downgrade. Users interested in the topic are ...Downgrading to a lower series (for example, from 8.4 to 8.0) might cause server crashes or data ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-load.html
Place the files that you want to load in the vector store directory that you specified in the MySQL AI installer. To test the steps in this topic, create a folder demo-directory inside the vector store director /var/lib/mysql-files for storing files ... This section describes how to generate vector embeddings for files or folders, and load the embeddings into a vector store ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The processlist table contains a row for each server process: mysql> SELECT * FROM performance_schema.processlist\G ...For ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
MySQL Session DBMS connection keep-alive interval (in seconds): [600] Time interval between sending keep-alive messages to the DBMS. Queries can sometimes return an excessive number of rows, which can heavily load the connection, and take time to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
However, it is not difficult in MySQL to create partitioning schemes based on DATE, TIME, or DATETIME columns, or based on expressions making use of such columns. This section discusses the types of partitioning which are available in MySQL 8.4.
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The default compression levels used by X Plugin in MySQL 8.4 have been selected through performance testing as being a good trade-off between compression time and network transit time. The benefits of compression therefore occur primarily when there ... X Plugin supports compression of messages sent over X Protocol ...
https://dev.mysql.com/doc/connectors/en/connector-j-source-replica-replication-connection.html
If you have a write transaction, or if you have a read that is time-sensitive (remember, replication in MySQL is asynchronous), set the connection to be not read-only, by calling Connection.setReadOnly(false) and the driver will ensure that further ...A Connection then, at runtime, tests for available replica hosts when Connection.setReadOnly(true) is called (see explanation for the method below), throwing an SQLException if it cannot establish a connection to a replica, unless the property readFromSourceWhenNoReplicas is set to be “true” (see below for a description of the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-source-replica-replication-connection.html
If you have a write transaction, or if you have a read that is time-sensitive (remember, replication in MySQL is asynchronous), set the connection to be not read-only, by calling Connection.setReadOnly(false) and the driver will ensure that further ...A Connection then, at runtime, tests for available replica hosts when Connection.setReadOnly(true) is called (see explanation for the method below), throwing an SQLException if it cannot establish a connection to a replica, unless the property readFromSourceWhenNoReplicas is set to be “true” (see below for a description of the ...
https://dev.mysql.com/doc/connectors/en/connector-j-support-bug-report.html
The normal place to report bugs is http://bugs.mysql.com/, which is the address for our bugs database. If you find a sensitive security bug in MySQL Server, please let us know immediately by sending an email message to <secalert_us@oracle.com>.