Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
CREATE EXTERNAL TABLE table_name (col_name data_type [ENGINE_ATTRIBUTE='Col_Engine_Attribute_JSON'], ...) ENGINE_ATTRIBUTE='Tbl_Engine_Attribute_JSON'; If you are on a version earlier than MySQL 9.4.0, you must use the CREATE TABLE statement to ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-6.html
For X DevAPI for C, the new mysqlx_set_locking(stmt, lock) function can be called to request exclusive or shared locks on returned documents or rows, or to release locks. A new MYSQLX_OPT_AUTH constant is recognized by the mysqlx_options_set() ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
FOR SHARE statements do not acquire read locks on MySQL grant tables. Thus, it sets the same locks a searched SQL UPDATE would set on the rows. In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-ioactivity-category.html
Lists the InnoDB IO Activity metrics and provides a brief description of each. Table 6.13 InnoDB IO Activity Metrics NameDescriptionBytes Per Read The average bytes per read within InnoDB for the snapshot interval. Os File Fsyncs (Delta) The total ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-permissions.html
mysql>GRANT EXPORT_QUERY_RESULTS ON database_name.* TO 'user_name'@'%'; The resource principal policy for Exporting Query Results to Object Storage. MySQL HeatWave on AWS Requirements For MySQL HeatWave on AWS, you need the Lakehouse role to access ...Required Privileges to Export Query Results Ask the admin user to grant you the EXPORT_QUERY_RESULTS ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. To ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. For example, to set the size to 100 at startup, put these lines in the server my.cnf file: [mysqld] ...The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
Before starting a backup, make sure that the cluster is properly configured for performing one. If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. If used, the backup_id must follow ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin directory. The Common Name in the CA certificate is “MySQL NDB Cluster ordinal ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
The tp_connections table contains one row per connection managed by the Thread Pool plugin. Each row provides information about the current state of a thread pool connection. The tp_connections table contains the following rows: CONNECTION_ID The ...