Search Results
https://dev.mysql.com/doc/internals/en/myisam-concurrent-insert.html
So there is non-deterministic time span between the seemingly successful ended insert and the final update of the MyISAM status. To support concurrent inserts, every statement starts with copying MYISAM_SHARE::state.state to MI_INFO::save_state and ...
https://dev.mysql.com/doc/internals/en/select-subquery.html
The engine will be created at the time Item_subselect is constructed (Item_subselect::init method). Before calling any value-getting method (val, val_int, val_str, bring_value (in case of row result)) engine->exec() will be called, which executes ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
If the inferred data type is incompatible with the table definition, Lakehouse Auto Parallel Load raises an error, and specifies the column as NOT SECONDARY. mysql> GRANT PROCESS ON database_name.* TO 'user_name'@'%'; The EXECUTE privilege on the ...
https://dev.mysql.com/doc/refman/8.4/en/scheduler-component.html
After executing the task list, removes the tasks from the active list, adds them to the inactive list, and calculates the next time they need to run. The scheduler component provides an implementation of the mysql_scheduler service that enables ...
https://dev.mysql.com/doc/internals/en/better-protocols-example.html
The output becomes less clear because there is no indication that the connection has been changed. SET @aux = 1; SELECT @aux AS "content of @aux is"; content of @aux is 1 SELECT @aux AS "content of @aux is"; content of @aux is NULL .
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE. Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. This ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
Your firewall may be configured on the basis of the application being executed, or the port number used by MySQL for communication (3306 by default). After a fresh installation, if you try to log on to the server as root without using a password, ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 8.3 server on the same data directory, and fix the cause of any errors. Note The upgrade process does not upgrade the contents of the time zone tables. For upgrade instructions, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-establishing-connection.html
When invoked without any arguments, the connection attempt is retried indefinitely, once per second, until successful. To enable connections with data nodes, use wait_until_ready() after calling connect(); wait_until_ready() waits up to a given ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
name type PATH string_path [on_empty] [on_error]: Columns of this type are used to extract values specified by string_path. Saving an object or array triggers the optional on error clause; this also occurs when an error takes place during coercion ... This section contains information about JSON functions that convert JSON data to tabular ...