Search Results
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating ...One session cannot acquire locks for another session or release locks held by another ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default ...ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
For a system variable summary table, see Section 7.1.5, “Server System Variable Reference”. The following table shows some possible values for authentication_policy and the policy that each establishes for creating or altering accounts. Table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. There are many reasons why you ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Default frequency 12:00:00 Default auto-close enabled yes Database May Not Be Portable Due To Identifier Case Sensitivity The case sensitivity of the underlying operating system determines the case sensitivity of database and table names. However, ...However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html
The properties are listed by categories in the following tables and then in the subsections that follow. Click on a property name in the tables to see its full description in the subsections. Configuration properties define how Connector/J will ...