PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
If you want the association to take effect each time the server starts, one way to accomplish this is to use an option file: Include variable settings that configure your key caches, and an init_file system variable that names a file containing ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
--connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 43200 The maximum number of seconds before connection timeout. --shutdown-timeout=value Command-Line Format --shutdown-timeout=seconds Type Numeric ...You ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
Any time the high water mark is updated, the value of innodb_file_format_check is updated as well, so the command SELECT @@innodb_file_format_check; displays the name of the latest file format known to be used by tables in the currently open ib-file ...If you access an existing table in a format higher than the format the running software supports, the system tablespace tag is not updated, but table-level compatibility checking applies (and an error is issued), as described in Section 14.10.2.2, “Compatibility Check When a Table Is ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. For example, if you want to execute mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
In this case, the second SELECT statement in the preceding scenario would execute before the UPDATE statement, and would not wait for the first SELECT to finish. But because only one session can write to a table at any one time, for best performance ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
To the extent that the optimizer can use information about conditions on rows selected from one table and passed to the next, the more accurately it can compute row estimates and choose the best execution plan. The maximum value is 100, which means ... In join processing, prefix rows are those rows passed from one table in a join to the ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_log_status Command-Line Format --authentication-ldap-sasl-log-status=# Introduced 5.7.19 System Variable authentication_ldap_sasl_log_status Scope Global Dynamic Yes Type Integer Default Value 1 Minimum Value 1 Maximum Value ...If the base DN is ou=Admin,dc=example,dc=com: Searches find user entries only in the second ...Communication between the authentication ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
The log table implementation has the following characteristics: In general, the primary purpose of log tables is to provide an interface for users to observe the runtime execution of the server, not to interfere with its runtime execution. Log ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...