Search Results
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. In MySQL terminology, a "key" is something that you create with CREATE [UNIQUE] INDEX. You can verify that by executing the same statements and looking at a hexadecimal dump yourself. The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON REPLICA to prevent them from running on the new replica. You can list the events on a server using the SHOW statement or the Information Schema ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-10.html
New methods were added to the MySqlX.XDevAPI.BaseSession class to implement corresponding SQL statements using the X Protocol: SetSavepoint() and SetSavepoint(name) correspond to the SAVEPOINT statement. (WL #11135) Document Store: The ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
It can be one of: mysql: DB System heatWave: MySQL HeatWave Cluster heatWaveNode: Specifies the MySQL HeatWave nodeindex the metric originated from. dbSystemId Basic Detailed heatwave.query_offload_count Count The number of statements executed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
The STATEMENT and TRANSACTION values signify locks that are released implicitly at statement or transaction end, respectively. The EXPLICIT value signifies locks that survive statement or transaction end and are released by explicit action, such as ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. This happens when someone issues a FLUSH TABLES statement or ... When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
The results area of the screen shows the results from executed statements. If the script contains multiple statements, a result subtab will be generated for each statemented that returned results. The following figure shows a single subtab and ...