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/internal-locking.html
Deadlocks affect performance rather than representing a serious error, because InnoDB automatically detects deadlock conditions and rolls back one of the affected transactions. At times, it may be more efficient to disable deadlock detection and ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
If connection_control_min_connection_delay and connection_control_max_connection_delay are 1500 and 20000, the adjusted delays for the fourth and subsequent failed connections are 1500 milliseconds, 2000 milliseconds, 3000 milliseconds, and so ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
The config_params table has been made read-only, and has been enhanced with additional columns providing information about each configuration parameter, including the parameter's type, default value, maximum and minimum values (where applicable), a ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/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 ...If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
A client-side authentication plugin is available that enables clients to send passwords to the server as cleartext, without hashing or encryption. Table 6.12 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
If the optional length N is not given, MySQL calculates the maximum length from the expression. If the optional length N is not given, MySQL calculates the maximum length from the expression. If the optional M value is given, it specifies the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
Random insertions into or deletions from a secondary index can cause the index to become fragmented. Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL servers.
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring, logging, and blocking of connection and query activity executed on specific MySQL servers. Note MySQL Enterprise Audit is an extension included in ...