Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
As long as a some statement within the function writes to a read-only database, execution of the function fails with an error regardless of whether the statement actually executes. Events: CREATE EVENT ALTER EVENT DROP EVENT Event execution: ...In ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
training_time: number The time in seconds taken to train the model. It also records any error messages that occur during model training. Error: Either training was canceled or an error occurred during training. build_timestamp: number A timestamp ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is rejected. Use cases for this plugin ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-statements.html
This results in better performance when dealing with time zone conversions in Date and Time data types, however it won't be aware of time zone changes if they happen at runtime. Default Value true Since Version 8.0.20 continueBatchOnError Should the ...Default Value true Since Version 3.0.3 dontTrackOpenResources The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling 'close()' on statements or result sets this can cause memory ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
query() returns True if the query executes, and raises an exception otherwise. It raises a TypeError exception if any argument has an invalid type, and a MySQLInterfaceError exception for any MySQL error returned by the MySQL server.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the source. If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the binary log at the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-event.html
The new version of the API also simplifies error detection and handling. Old (deprecated) methods are shown in the first column of the following table, and new methods in the second column; old methods corresponding to new methods are shown in the ...Event Class Overview Event::addEventColumn() Event::addEventColumns() Event::addTableEvent() Event Constructor Event::EventDurability Event::EventReport Event::getDurability() Event::getEventColumn() Event::getName() Event::getNoOfEventColumns() Event::getObjectStatus() Event::getObjectVersion() Event::getObjectId() Event::getReport() Event::getTable() Event::getTableEvent() Event::getTableName() Event::mergeEvents() Event::setDurability() Event::setReport() Event::setName() Event::setTable() Event::TableEvent Event Class Overview Parent class NdbDictionary Child classes None Description This class represents a database event in an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...The exception to this rule is that the query sees the changes made by earlier statements within the same ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...