Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
Developers familiar with the Performance Schema interface can extend the replication tables to provide additional information by adding rows to the tables. That is, if the replica_parallel_workers system variable is greater than 0, this table is ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #37478594) InnoDB: Creating a secondary index on a VARCHAR column could allocate more memory than configured, with the amount allocated being directly related to the value of innodb_ddl_buffer_size, leading to errors similar to ERROR 1136 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restart-cluster.html
Note Depending on the number of nodes and the amount of data stored in the cluster, a rolling restart can take a considerable amount of time, up to several hours for a cluster with a great many data nodes and a large amount of data. restart cluster ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-limitations.html
Limiting operations to batches of 10 to 100 rows by splitting large tables into smaller tables is recommended. Memory Limitations The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 columns. See the following to learn ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data sorted by primary key. Use a second session to monitor bulk load progress: If the data is sorted, there is a single stage: ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | ...It may be used to time how quickly ...