Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-objects-examples.html
When you call the member in Python mode, use snake case for the member name, and MySQL Shell automatically handles the conversion. Example 11.1 Creating and Registering Extension Objects - Python This example creates a function hello_world() which ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Can a stored procedure call a trigger? A stored procedure can execute an SQL statement, such as an UPDATE, that causes a trigger to activate. Finally, nontransactional tables for which errors occur during large DML actions (such as bulk inserts) may ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. When the last instance of a table is closed (because a FLUSH TABLES operation was performed or because there is no ... Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. The ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
Note Before using ndb_restore, it is recommended that the cluster be running in single user mode, unless you are restoring multiple data nodes in parallel. See Section 25.6.6, “NDB Cluster Single User Mode”, for more information. Important When ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, the amount of storage space used by a given JSON value and the amount of space remaining in a JSON column following a partial update. It returns a positive, nonzero value if the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Safe Updates Enabled If set to 1, MySQL aborts UPDATE or DELETE statements that do not use a key in the WHERE clause or a LIMIT clause. This makes it possible to catch UPDATE or DELETE statements where keys are not used properly and that would ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
While a transaction is open, the system keeps a snapshot of the data as seen at the beginning of the transaction, which can cause substantial overhead if the system inserts, updates, and deletes millions of rows while a stray transaction keeps ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
MySQL updates the files on disk with the write() system call after every SQL statement and before the client is notified about the result. (This is not true if you are running with the delay_key_write system variable enabled, in which case data ...