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/user-resources.html
This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. An “account” in this context corresponds to a row in the mysql.user system table. In this ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This plugin exposes a set of system variables that enable you to configure password policy. This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. This is true ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
This section helps you diagnose and correct some of these errors. This situation can occur when MySQL is upgraded and installed to a new location, but the configuration file is not updated to reflect the new location. If you have installed MySQL to ... When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This was because an XA transaction that was in PREPARED state would be rolled back on ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
This issue can occur if MySQL is configured to read from or write to a non-default directory or file. In this case, a “denial” message is logged to /var/log/audit/audit.log: $> grep "denied" /var/log/audit/audit.log type=AVC ... Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A consequence of this is that SET member values should not themselves contain commas. For more information on this limit, see Limits Imposed by .frm File Structure. For example, you can retrieve numeric values from a SET column like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
Any data encrypted using this public key can be decrypted only using the corresponding secret key, which is held by the owner of the certificate. This enables you to choose an encrypted or unencrypted connection according to the requirements of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
In this case innodb_stats_persistent_sample_pages should be decreased until ANALYZE TABLE execution time is acceptable. To avoid this scenario, innodb_stats_include_delete_marked can be enabled to ensure that delete-marked records are included when ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...Although the internal range of values for YEAR/YEAR(4) and the deprecated YEAR(2) type is the same (1901 to 2155, and 0000), the display width for YEAR(2) makes that type inherently ambiguous because displayed values indicate only the last two digits of the internal values and omit the century ...