Search Results
https://dev.mysql.com/doc/internals/en/mismatch-of-focus-of-test-and-code-sequence.html
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, my_column VARCHAR(30), name LONGTEXT, PRIMARY KEY (id)); INSERT INTO t1(my_column,name) VALUES('2','two'); INSERT INTO t1(my_column,name) VALUES('1','one'); INSERT INTO t1(my_column,name) ...
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
MySQL supports transpositions (reversing the order of operands around a relational operator) for simple expressions only. In other words: WHERE - 5 = column1 becomes: WHERE column1 = -5 However, MySQL does not support transpositions where ...
https://dev.mysql.com/doc/internals/en/replication-organization.html
We distinguish between two levels of the architecture: principles, and rules: principle High-level goal that declares how the program shall work, from an external point of view. An example of a principle is "no row events shall be written to the ...
https://dev.mysql.com/doc/ndbapi/en/overview-mgm-api.html
The NDB Cluster Management API, also known as the MGM API, is a C-language programming interface intended to provide administrative services for the cluster. These include starting and stopping NDB Cluster nodes, handling NDB Cluster logging, ...
https://dev.mysql.com/doc/workbench/en/wb-windows-uninstalling.html
The method for uninstalling MySQL Workbench depends on how you installed MySQL Workbench. Removing MySQL Workbench After Installation Using the Installer Package To uninstall MySQL Workbench, do one of the following: From Start, select Settings and ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
The privileges required at function invocation time can be checked only as it executes: For different invocations, different execution paths within the function might be taken. The view definition is “frozen” at creation time and is not affected ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. For example, to remove ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-progress-tracking.html
You can monitor the progress of MySQL HeatWave AutoML routines through Performance Schema queries made from a second MySQL Client session. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', 'classification'), ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
On platforms without sufficient (nanosecond) time resolution, small changes in the value of the WaitNanosCount NDB API counter due to SQL statements that execute very quickly may not always be visible in the values of ...Table 25.39 NDB API ... A ...