MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 131 total results

https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html

Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...

10.2.4 Optimizing Performance Schema Queries

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html

Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on ...

29.1 Performance Schema Quick Start

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html

row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, PRIMARY KEY (`NAME`) ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 ... This ...

9.5.2 Point-in-Time Recovery Using Event Positions

https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html

The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement ...

15.7.7.7 SHOW CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html

SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...

15.7.7.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html

row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...

15.7.7.13 SHOW CREATE VIEW Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html

row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select 1 AS `a`,2 AS `b` character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci ... SHOW ...

15.7.7.18 SHOW EVENTS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-events.html

row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...

15.7.7.40 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html

row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...

27.7 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...

Displaying 121 to 130 of 131 total results