Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-partitioning.html
To avoid stopping replication or creating inconsistencies between the source and replica, always ensure that a table on the source and the corresponding replicated table on the replica are partitioned in the same way. Replication is supported ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | ...It ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-osb.html
Multiple entries, one for each volume label, are created in the mysql.backup_sbt_history table, if the backup is split across multiple volumes. Each time an online backup is made to a tape using the SBT API , besides recording the backup in the ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. These functions support the use of a key derivation function (KDF) to create a cryptographically strong secret key from the information passed in key_str. When you use a ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
This is potentially the fastest way for mysqlbackup to create incremental backups. In general, optimistic incremental backups are faster than full-scan backups when not many tables in the database have been modified. --incremental-with-redo-log-only ... For an overview of incremental backups and usage examples for these options, see Section 4.3.3, “Making a Differential or Incremental Backup” and Section 5.1.3, “Restoring an Incremental ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handlers-email-group-controls-reference.html
Figure 22.2 Email Notification Groups section Table 22.2 Email Notification Groups List Controls Name Description Create Notification Group button Opens the Create Notification Group dialog. Figure 22.3 Create Group Dialog The Email Notification ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-install.html
Note To avoid typing the path name of client programs when working with MySQL, add the /usr/local/mysql/bin directory to your PATH variable: $> export PATH=/usr/local/mysql/bin:$PATH Unpacking the distribution creates the directories shown in the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-connections-in-javascript-and-python.html
You can use functions available in JavaScript and Python mode to create multiple session objects of your chosen types and assign them to variables. These session objects let you establish and manage concurrent connections to work with multiple ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
This also has a simpler and easier to use interface for analyzing and creating indexes for your tables. New Navigator PERFORMANCE Section Server Variable Groupings SQL Editor Views Home Screen Features Visual Explain Table Inspector Additional ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support for foreign keys, the driver would transparently support them as well. You must use a column alias with the value of the column to the actual ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...