Search Results
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/mysql-installer/en/server-accounts-roles.html
Root Account Password Assigning a root password is required and you will be asked for it when performing other MySQL Installer operations. MySQL User Accounts (Optional) Click Add User or Edit User to create or modify MySQL user accounts with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
For example: mysql> CALL mysql_tasks.execute_prepared_stmt_async('DO SLEEP(5); SELECT JSON_OBJECT("Async Task completed at", now()) into @task_result', 'demo_db', 'DemoAsyncTask', NULL, @task_id); In this example: The first SQL statement DO SLEEP(5) ... As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the ...This lets ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL HeatWave. The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was ...
https://dev.mysql.com/doc/heatwave-aws/en/console-overview.html
Console Overview 2.4.1 Console Overview When you sign in to the MySQL HeatWave Console, you are directed to the Home page. The profile menu at the top right corner of the MySQL HeatWave Console shows the account you are logged in to. The navigation ...It consists of the following regions: The Getting Started region of the page provides a Launch Starter DB System button for Launching a Starter DB ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-events.html
Events 16 Events Statuses of actions and operations on MySQL HeatWave on AWS resources are reported as Events. Operations and Resources MonitoredTable 16-1 shows the operations and resources on MySQL HeatWave on AWS for the events, the types of ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. For example, the following command tells mysqladmin to ping the server 1024 ...For example, -? and --help are the short and long forms of the option that instructs a MySQL program to display its help ...
https://dev.mysql.com/doc/refman/8.4/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. MySQL provides ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
It is a MySQL extension that GET [CURRENT] DIAGNOSTICS is permitted outside handler context to check the execution of any SQL statement. For a description of the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. When a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of ...The bootstrap should only be done by a single server, the one that starts the group and only ...