Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
Although mysql_stmt_fetch() can produce this error, it is more likely to occur for the following C API call if mysql_stmt_fetch() is not called enough times to read the entire result set (that is, enough times to return MYSQL_NO_DATA). It can be ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
Then, a find operation is executed to search for a specific document from the collection. Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At ...RESIGNAL makes it possible to both handle an error and return the error ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-vault.html
By using the vault, you need not enter credentials every time MySQL Workbench attempts to connect to a server. The vault provides a convenient secure storage for passwords used to access MySQL servers. For example, a local connection might use ...
https://dev.mysql.com/doc/internals/en/plugins.html
For example, several storage engines have been converted to plugins, and they can be selected or disabled at configuration time. Beginning with MySQL 5.1, the server supports a plugin architecture for loading plugins. You can build a plugin as ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-restoring.html
Select Automatic for MySQL HeatWave on AWS to choose the Start day and Start time. Select Manual to specify the maintenance window Start day and Start time. Backup policy: Select the backup retention period, and the start time for automatic backups.
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
Deadlocks affect performance rather than representing a serious error, because InnoDB automatically detects deadlock conditions by default and rolls back one of the affected transactions. At times, it may be more efficient to disable deadlock ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
If you are using replication, you should specify an expiration period that is no lower than the maximum amount of time your replicas might lag behind the source. When using MySQL with logging enabled, you may want to back up and remove old log files ... As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
For example, if mysql is the firewall database: CALL mysql.sp_set_firewall_group_mode(group, mode); In MySQL 8.4, firewall stored procedures are transactional; if an error occurs during execution of a firewall stored procedure, all changes made by ...If an account profile has an empty allowlist, its mode cannot be set to PROTECTING because the profile would reject every statement, effectively prohibiting the account from executing ...