PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
If the session is currently in row-based replication mode and has open temporary tables. Switching the replication format at runtime is not recommended when any temporary tables exist, because temporary tables are logged only when using ... You can ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
With MASTER_SSL=1, the connection attempt only succeeds if an encrypted connection can be established. It is recorded in the source metadata repository and shown in the replication_connection_configuration Performance Schema table. These values are ...] CHANGE MASTER TO changes the parameters that the replica uses for connecting to the replication source server, for reading the source's binary log, and reading the replica's relay ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
A language name shown in the following table indicates a language-specific collation. If this is acceptable for your application, you should use utf8_general_ci because it is faster. If this is not acceptable (for example, if you require German ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). In particular, installing only the CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS ... This section describes how to install the connection-control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
The preceding means that normally you should not get corrupted tables unless one of the following happens: The MySQL server or the server host was killed in the middle of an update. Some external program is manipulating data files or index files at ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT '0.00' ); SERIAL DEFAULT VALUE is a special case. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysql_upgrade -u root -p mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL, and attempts to repair the tables if problems are found. Shut down and restart the MySQL server to ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
The IS_UPDATABLE flag may be unreliable if a view depends on one or more other views, and one of these underlying views is updated. Regardless of the IS_UPDATABLE value, the server keeps track of the updatability of a view and correctly rejects data ... Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/full-disk.html
Other threads might be waiting for the table that caused the disk-full condition. Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE ... This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit ...