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/innodb-performance-read_ahead.html
A read-ahead request is an I/O request to prefetch multiple pages in the buffer pool asynchronously, in anticipation that these pages are needed soon. InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
For example, in a table containing information about people, you would not create a primary key on (firstname, lastname) because more than one person can have the same name, a name column may be left blank, and sometimes people change their names.
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/mysql-cluster-replication-starting.html
This section outlines the procedure for starting NDB Cluster replication using a single replication channel. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 21.7.2, “General ...
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/query-cache-operation.html
Prepared statements that are issued using the binary protocol using mysql_stmt_prepare() and mysql_stmt_execute() (see C API Prepared Statement Interface), are subject to limitations on caching. The statement is compared only with other cached ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
If the repair fails because of an error in the data file (for example, a duplicate-key error), the server tries again, this time re-creating the data file. myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth. For example: # at 141 #100309 9:28:36 ...