PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. It does not matter whether there are WHERE conditions in the statement that would exclude the row. InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. The percentage of recently used pages that is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 5.7. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. If such statements are logged by the MySQL server as written, passwords in them become visible to ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. The server then authenticates the client, determining from ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
To be able to safely configure the replication mode of an online server it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Normalization permits statements that are similar to be grouped and summarized to expose information about the types of statements the server is executing and how often they occur. If the table becomes full, the Performance Schema groups statements ... The MySQL server is capable of maintaining statement digest ...