Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
Avoiding the key transfer saves a round trip in the client/server protocol. The first method uses the TLS (Transport Layer Security) protocol to establish an encrypted connection. The second method uses RSA key pair-based password exchange over an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor.html
This automation helps save time and ensures better efficiency, especially when dealing with complex analytical (OLAP) workloads. The MySQL HeatWave Autopilot improves MySQL database performance without manual tuning. It uses machine learning to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
Syntax Examples Generate embeddings for text stored in demo_db.input_table.Input using the all_minilm_l12_v2 embedding model, and save the generated embeddings in the output table demo_db.output_table.Output: mysql> CALL ... The ML_EMBED_TABLE ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-edit.html
Editing a DB System 3.4.3 Editing a DB System Use the MySQL HeatWave Console to edit details of a DB System and various options for it. This task requires the following: (For data import feature only) Permissions to assume the data import role.
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
This method works for any kind of data file, but saves only table data, not the table structure. Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical ...
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
The default 16KB page size is appropriate for a wide range of workloads, particularly for queries involving table scans and DML operations involving bulk updates. If you have transactions that update, insert, or delete many rows, you might consider ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
These locks are saved in a hash table in the server and implemented with pthread_mutex_lock() and pthread_mutex_unlock() for high speed. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
If you know exactly what you are looking for, you can search in just one of the underlying tables for some queries and use a MERGE table for others. This is much faster and saves a lot of disk space. MERGE tables can help you solve the following ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.