Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Finally, nontransactional tables for which errors occur during large DML actions (such as bulk inserts) may experience replication issues in that a source may be partially updated from DML activity, but no updates are done to the replica because of ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL tool (https://valgrind.org/). Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
In the case that multiple locks are acquired for the same name, only the first lock for the name registers a row in the metadata_locks table. The metadata_locks row for the lock is deleted when the last lock instance on the name is released. Caution ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
Use the multiple-row INSERT syntax to reduce communication overhead between the client and the server if you need to insert many rows: INSERT INTO yourtable VALUES (1,2), (5,5), ...; This tip is valid for inserts into any table, not just InnoDB ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-data-purge-ref.html
If you change the purge duration from a large timespan to a smaller one, the data is purged in increments of one hour, from oldest to newest, until the new data retention policy is met. Notes for setting purge behavior: Purging can be carried out ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
All of these statements may create large temporary files that, if left to themselves, would cause big problems for the rest of the system. This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
If you want to have a tool that repairs tables by default, you should just make a copy of mysqlcheck named mysqlrepair, or make a symbolic link to mysqlcheck named mysqlrepair. If you are using this option to repair tables, it runs an extended ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...