Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
An INSERT or REPLACE statement that inserts a great many rows can also cause these sorts of errors. Either one of these statements sends a single request to the server irrespective of the number of rows to be inserted; thus, you can often avoid the ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-perror.html
This is intended as a drop-in replacement for perror --ndb, which is no longer supported. ndb_perror replaces perror --ndb, which is no longer supported by NDB Cluster. ndb_perror shows information about an NDB error, given its error code. This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbmtd.html
In other words, a data node running ndbd can be stopped, the binary replaced with ndbmtd, and then restarted without any loss of data. ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
Both private keys and certificates are labeled as either active or pending; ndb_sign_keys also provides help with rotating keys to allow for pending keys to replace active keys before the active keys expire. MySQL NDB Cluster 8.3 makes the following ... What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-data-masking.html
Data masking hides sensitive information by replacing real values with substitutes. MySQL Enterprise Data Masking and De-Identification functions enable masking existing data using several methods such as obfuscation (removing identifying ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-security.html
MySQL Enterprise Edition includes a suite of masking and de-identification functions that perform subsetting, random generation, and dictionary replacement to de-identify strings, numerics, phone numbers, emails and more. These functions enable ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
In this case, MySQL does a single key lookup for each MIN() or MAX() expression and replaces it with a constant. If all expressions are replaced with constants, the query returns at once. Indexes are used to find rows with specific column values ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Thereafter, when the server sees other statements with the same digest value, it determines whether to use the new statement to replace the current sample statement (that is, whether to resample). Resampling based on age: If the ...The Performance ...