MySQL :: MySQL 8.4 Reference Manual

Search Results

Displaying 81 to 90 of 91 total results

6.5.3 mysqlcheck — A Table Maintenance Program

https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html

If you are using this option to repair tables, it runs an extended repair that may not only take a long time to execute, but may produce a lot of garbage rows also! --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...

8.2.17 Pluggable Authentication

https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html

For standard MySQL clients such as mysql and mysqladmin, the --default-auth=plugin_name option can be specified on the command line as a hint about which client-side plugin the program can expect to use, although the server overrides this if the ...

15.1.15 CREATE INDEX Statement

https://dev.mysql.com/doc/refman/8.4/en/create-index.html

The value is treated as a hint; a different size could be used if necessary. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is ...

6.6.9 mysqlbinlog — Utility for Processing Binary Log Files

https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html

--default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use. The server's binary log consists of files containing “events” that describe modifications to database ...

6.5.2 mysqladmin — A MySQL Server Administration Program

https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html

--default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about which client-side authentication plugin to use. You can use it to check the server's configuration and current status, to create and drop databases, and more.

10.9 Controlling the Query Optimizer

https://dev.mysql.com/doc/refman/8.4/en/controlling-optimizer.html

MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...

25.6.3.3 Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client

https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html

The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its output. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction ...

8.2.10 Using Roles

https://dev.mysql.com/doc/refman/8.4/en/roles.html

User and Role Interchangeability As has been hinted at earlier for SHOW GRANTS, which displays grants for user accounts or roles, accounts and roles can be used interchangeably. Like user accounts, roles can have privileges granted to and revoked ...

25.2.7.7 Limitations Relating to Performance in NDB Cluster

https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-performance.html

See Section 10.9.4, “Index Hints”, for more information on how to do this. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance issues due to sequential access to the ...

10.2.2.1 Optimizing IN and EXISTS Subquery Predicates with Semijoin and Antijoin Transformations

https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html

A semijoin transformation can also be applied to a single-table UPDATE or DELETE statement that uses a [NOT] IN or [NOT] EXISTS subquery predicate, provided that the statement does not use ORDER BY or LIMIT, and that semijoin transformations are ...

Displaying 81 to 90 of 91 total results