Search Results
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-6.html
For X DevAPI for C, the new mysqlx_set_locking(stmt, lock) function can be called to request exclusive or shared locks on returned documents or rows, or to release locks. The addOrReplaceOne() and replaceOne() methods work only with MySQL 8.0.3 and ...Locks can be requested several times for a given find or select ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
PK: PRIMARY KEY NN: NOT NULL UQ: UNIQUE INDEX BIN: BINARY UN: UNSIGNED ZF: ZEROFILL AI: AUTO_INCREMENT G: Generated Column This option is available as of MySQL Server 5.7. For example, if the model is reverse engineered, the script will contain ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-18.html
This indicates that Connector/Python does not execute SET commands by a connection with an expired password, an operation that's disallowed by MySQL Server 8.0.18 and higher. Functionality Added or Changed Bugs Fixed Functionality Added or Changed ...(Bug #95263, Bug #29743839, WL #13335) Connector/Python failed to install using the macOS ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
Higher scores indicate a greater degree of abnormality, potentially signaling an anomaly that warrants further investigation. To detect anomalies in log data (MySQL 9.2.2 and later), you can only run the ML_PREDICT_TABLE routine. Requirements for ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and writes a message to the error log: Access denied for user ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
The most effective means of doing so is to shut down the MySQL server while running myisamchk, or to lock all tables that myisamchk is being used on. If mysqld is running, you must force it to flush any table modifications that are still buffered in ... The myisamchk utility gets information about your database tables or checks, repairs, or optimizes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin directory. The Common Name in the CA certificate is “MySQL NDB Cluster ordinal ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a ...A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options4.html
MYSQL_OPT_CONNECT_ATTR_ADD (argument types: char *, char *) This option adds an attribute key-value pair to the current set of connection attributes to pass to the server at connect time. int mysql_options4(MYSQL *mysql, enum mysql_option option, ...The following list describes the permitted options, their effect, and how arg1 and arg2 are ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.0-ndb-8.4.0.html
(Bug #36004838) A MySQL server disconnected from schema distribution was unable to set up event operations because the table columns could not be found in the event. This could be made to happen by using ndb_drop_table or another means to drop a ...