MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 2141 to 2150 of 2151 total results

10.14 Examining Server Thread (Process) Information

https://dev.mysql.com/doc/refman/8.0/en/thread-information.html

row *************************** Id: 5 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. row *************************** Id: 20 User: me Host: ... To ...

10.2.5.3 Optimizing DELETE Statements

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

The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...

28.3.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-referential-constraints-table.html

The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...

17.6.3.7 Disabling Tablespace Path Validation

https://dev.mysql.com/doc/refman/8.0/en/innodb-disabling-tablespace-path-validation.html

The paths of discovered tablespace files are validated against the paths recorded in the data dictionary. If the paths do not match, the paths in the data dictionary are updated. The innodb_validate_tablespace_paths variable, introduced in MySQL ...

25.6.16.2 The ndbinfo arbitrator_validity_summary Table

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-arbitrator-validity-summary.html

The arbitrator_validity_summary table provides a composite view of the arbitrator with regard to the cluster's data nodes. If it has more than 1 row for longer than a few moments, then either not all nodes are connected to the arbitrator, or all ...

29.12.11.6 The replication_applier_filters Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-filters-table.html

FILTER_RULE The rules configured for the replication filter type using either --replicate-* command options or CHANGE REPLICATION FILTER. COUNTER The number of times the replication filter has been used since it was configured. This table shows the ...

2.1.1 Supported Platforms

https://dev.mysql.com/doc/refman/8.0/en/platform-support.html

MySQL platform support evolves over time; please refer to https://www.mysql.com/support/supportedplatforms/database.html for the latest updates.

30.4.4.3 The execute_prepared_stmt() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-execute-prepared-stmt.html

Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to ...

30.4.4.15 The ps_setup_show_disabled() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled.html

Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...

30.4.4.18 The ps_setup_show_enabled() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled.html

Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...

Displaying 2141 to 2150 of 2151 total results