Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
A query that fails to parse differs from a query that parses but fails due to an error during execution. Consequently, there is no parsing at runtime and the type of each statement is known by the time it executes. For additional information about ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-console-data.html
You need to select a time period in the drop-down list on the right, upon which the prediction will be based. The choices in the drop-down list include: Past 12 hours Past day Past 3 days Past week The time period can also be chosen by using the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-edit.html
The maintenance window is a two-hour period specified in Coordinated Universal Time, UTC. The time required to apply patches and updates may extend beyond the maintenance window and require a DB System restart. Select Automatic for MySQL HeatWave on ... Editing a DB System 3.4.3 Editing a DB System Use the MySQL HeatWave Console to edit details of a DB System and various options for ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to overflowing. [Occurred during startphase start_phase.] [ Initiated by signal.] ... The following table lists the most common NDB cluster log ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
Delete (Delta) The number of times that rows have been deleted from tables. Mrr Init (Delta) The number of times the server uses a storage engine's own Multi-Range Read implementation for table access. Prepare (Delta) The number of times the first ... Lists the Handler Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
The “new” versions of these types are reflected in the NDB API as Time2, Datetime2, and Timestamp2, respectively, each supporting fractional seconds with up to 6 digits of precision. The integer part is encoded as shown in the following table: ...The storage space required for a MySQL CHAR column is determined by the maximum number of characters and the column's character ... This section provides information about the ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ...Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are triggered by the passage of ...
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 ...The goal of the query optimizer is to find an optimal QEP among all such possible ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
Blocking Trx Age How long the blocking transaction has been executing, as a TIME value. Blocking Trx Started The time at which the blocking transaction started. Wait Age How long the lock has been waited for, as a TIME value. Waiting Trx Age How ...