Search Results
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The server is free to ignore rows that become malformed as a result of such modifications. Each grant table contains scope columns and privilege columns: Scope columns determine the scope of each row in the tables; that is, the context in which the ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-print-backup-file.html
This option is enabled by default; to disable it, use --no-print-rows. --rowid-file Command-Line Format --rowid-file=path Type File name Default Value [none] File to check for row ID. Usage ndb_print_backup_file [-P password] file_name file_name is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
Delete (Delta) The number of times that rows have been deleted from tables. Read First (Delta) The number of requests to read a row based on a index key value. Read Next (Delta) The number of requests to read the next row in key order. Read Prev ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-implementations.html
mysql> SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'; Query OK, 0 rows affected (0.05 sec) mysql> SELECT HEX('a'), HEX(WEIGHT_STRING('a')); +----------+-------------------------+ | HEX('a') | HEX(WEIGHT_STRING('a')) | ... MySQL implements several ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
When an operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY clause. Omitting ON DELETE and ON ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
This exception causes the following anomaly: If you update some rows in a table, a SELECT sees the latest version of the updated rows, but it might also see older versions of any rows. If another transaction deletes a row and commits after your ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
For new or modified rows, violation of a CHECK constraint on an invisible column produces an error. row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `col1` int DEFAULT NULL, `col2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.