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-file-format-compatibility-checking.html
Checks against this file format tag are controlled by the configuration parameter innodb_file_format_check, which is ON by default. The ability to set innodb_file_format_check is useful (with future releases) if you manually “downgrade” all of ... To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
This statement transfers the GTIDs for the transactions executed on the source to the replica, and the replica requires this information. In a multi-source replication topology, you must therefore remove the SET @@GLOBAL.gtid_purged statement from ... If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing products. Replication in this situation enables you to distribute the reads over the replicas, while still enabling your web servers to ... You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and MAX() on memcached data. You do not need to manually load data into memcached at startup.
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
In this case, the MySQL distribution need not have been compiled using OpenSSL as long as the openssl command is available. Automatic SSL and RSA File Generation Manual SSL and RSA File Generation Using mysql_ssl_rsa_setup SSL and RSA File ...For ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
The location of this default directory is the same as for the keyring_file_data system variable. See the description of that variable for details, as well as for considerations to take into account if you create the directory manually. The location ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
You can force client programs to use specific character set as follows: [client] default-character-set=charset_name This is normally unnecessary. However, when character_set_system differs from character_set_server or character_set_client, and you ... The MySQL server has a compiled-in default character set and ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
In this case, you must remove any remaining files or directories manually and issue the DROP DATABASE statement again. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. DROP {DATABASE | SCHEMA} ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. To find the maximum of the currently used collation IDs, use this query: SELECT MAX(ID) FROM INFORMATION_SCHEMA.COLLATIONS; This step depends on whether you are adding a ...