Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
If there is an error in evaluation on the replica, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. DML operations that read data from MySQL grant ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...In MySQL, the search for an optimal QEP is performed in a bottom-up ...A combination of a fixed order in which tables are joined and the corresponding ...
https://dev.mysql.com/doc/internals/en/prepared-stored.html
For example, MySQL performs [sub]query transformation during context analysis; moreover, most parts of the code rely on the fact that THD is processing only one statement at a time. Let us start with a general description of the MySQL statement ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-management-server-connections.html
ndb_mgm_get_connectstring() ndb_mgm_get_configuration_nodeid() ndb_mgm_get_connected_port() ndb_mgm_get_connected_host() ndb_mgm_get_version() ndb_mgm_is_connected() ndb_mgm_check_connection() ndb_mgm_number_of_mgmd_in_connect_string() ... This ...
https://dev.mysql.com/doc/ndbapi/en/ndb-index.html
If you create or change indexes using the NDB API, these modifications cannot be seen by MySQL. Indexes created using the NDB API cannot be seen by the MySQL Server. Index::addColumnNames() Description This method is used to add several column names ...Index Class Overview Index Class Constructor Index::addColumn() Index::addColumnName() Index::addColumnNames() Index::getColumn() Index::getLogging() Index::getName() Index::getNoOfColumns() Index::getObjectStatus() Index::getObjectVersion() Index::getObjectId() Index::getTable() Index::getType() Index::setLogging Index::setName() Index::setTable() Index::setType() Index::Type Index Class Overview Parent class NdbDictionary Child classes None Description This class represents an index on an NDB Cluster table ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-innodb-buffer-pool.html
For more information on the InnoDB Buffer Pool, see InnoDB Buffer Pool Configuration and Buffer Pool Important This report requires the INFORMATION_SCHEMA.INNODB_BUFFER_PAGE table, which is available in MySQL Server version 5.5.28 or higher. This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
This example stores different parameter values that were used during asynchronous task creation as additional task metadata, so that these values can be referred to at a later time. The execute_prepared_stmt_from_app_async routine creates an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-mirror-table.html
MYSQL_ACCESS_COUNT Number of times the table has been accessed by the DB System. HEATWAVE_ACCESS_COUNT Number of times the table has been accessed by the MySQL HeatWave Cluster. LAST_QUERIED_IN_HEATWAVE The timestamp of the last MySQL HeatWave query ...Tables with higher importance values are loaded to MySQL HeatWave ... The rpd_mirror table ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-create-backup.html
Use the Console to create a manual backup: In the MySQL HeatWave Console, click the Resources tab. In the Create MySQL Backup panel, edit the following fields: Display name: Specify a name of the backup. If you do not define a name, one is generated ... Creating a Backup 18.1 Creating a Backup Backups can be created automatically or ...