Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Trying to switch the replication format in any of these cases (or attempting to set the current replication format) results in an error. Otherwise, if the table has a unique key all of whose columns are NOT NULL, then only the columns in the unique ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
NOT NULL | NULL If neither NULL nor NOT NULL is specified, the column is treated as though NULL had been specified. In MySQL 8.4, only the InnoDB, MyISAM, and MEMORY storage engines support indexes on columns that can have NULL values. In other ...| ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
(An example that uses NDB$OLD() with an exceptions table is shown later in this section.) Additional columns may optionally be defined following the copied primary key columns, but not before any of them; any such extra columns cannot be NOT NULL.
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
} } if (stmt != null) { try { stmt.close(); } catch (SQLException sqlEx) { // You'd probably want to log this as well... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
} } if (stmt != null) { try { stmt.close(); } catch (SQLException sqlEx) { // You'd probably want to log this as well... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
If there is an authentication factor with a pending registration, a connection is placed into pending registration mode when attempting to connect to the server. <field name="column_name">NULL</field> The output when --xml is used with mysql matches ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap --delimiter=";" --number-of-queries=10 --query="use test;insert into t values(null)" --only-print Command-Line Format --only-print Type Boolean Default Value FALSE Do not connect to databases. mysqlslap is a diagnostic program designed to ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
keyData is a null-terminated array of pointers to the key parts that are part of the table's distribution key. If xfrmbuf is NULL (the default), then a call to malloc() or free() is made automatically, as appropriate. Prior to NDB 7.5.30, 7.6.26, ...