PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. For example, these two statements ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.0/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Queries, in the form of SELECT statements, perform all the lookup ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-file-context.html
Installing the MySQL Server RPM creates a /var/lib/mysql-files/ directory but does not set the SELinux context for it. The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...
https://dev.mysql.com/doc/refman/8.0/en/server-loadable-functions.html
MySQL distributions include loadable functions that implement, in whole or in part, these server capabilities: Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data ... MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
(The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information about the server options that enable logging. MySQL Server has several logs that can help ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
MySQL supports an plugin API that enables creation of server plugins. Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and ...