Search Results
https://dev.mysql.com/doc/refman/9.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. (Bug #28086) When one of the tables involved is a log table in the mysql database. In MySQL 9.7, operations on temporary tables are not ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-examples.html
To demonstrate the different DML operations you can execute on JSON duality views, create the customers and orders relational tables. CREATE TABLE customers ( customer_id INT PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE orders ( order_id INT ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. When the optional DATA DIRECTORY [=] 'clone_dir' clause is not used, a cloning operation ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/9.7/en/news-9-0-0.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). This release implements a new Performance Schema ndb_replication_applier_status table, which ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/9.7/en/news-9-2-0.html
(Bug #36951132) NDB Disk Data: mysqld did not use a disk scan for NDB tables with 256 disk columns or more. Such retry logic is not performed for transactions containing row events where the STMT_END_F flag is missing; instead, the statement is ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT ...The function ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
To view the current MySQL HeatWave query history, query the performance_schema.rpd_query_stats table: mysql> SELECT query_id, LEFT(query_text,160) FROM performance_schema.rpd_query_stats; *************************** 1. row ... Auto Query Time ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 18.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...