Search Results
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Intr: The version or versions in which the item was introduced. Depr: The version or versions in which the item was deprecated. Removed: The version or versions in ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-dmlstatementactivity-category.html
Lists the DML Statement Activity metrics and provides a brief description of each. Table 8.4 DML Statement Activity Metrics NameDescriptionTarget Name Name of the OEM Target Call Procedure (Delta) The total number of CALL statements executed.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-dmlstatementactivity-category.html
Lists the DML Statement Activity metrics and provides a brief description of each. Table 6.6 DML Statement Activity Metrics NameDescriptionCall Procedure (Delta) The total number of CALL statements executed. Dealloc SQL (Delta) The total number of ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
The following SQL CRUD functions are available in X DevAPI. Table.insert() The Table.insert() method works like an INSERT statement in SQL. It is used to store data in a relational table in the database. The example assumes that the test schema ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
This results in the replica attempting to replay two insert log entries using the same value for the primary key column, and so replication fails. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler-thread-states.html
These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that terminate the scheduler. Clearing The scheduler thread or a thread that was executing an event is terminating and is about to ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...