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/replication-upgrade.html
Perform any table repair or rebuilding operations needed to re-create database objects, such as use of REPAIR TABLE or ALTER TABLE, or dumping and reloading tables or triggers. Changes affecting operations in strict SQL mode (STRICT_TRANS_TABLES or ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
You may also wish to do this when performing bulk DELETE or UPDATE operations on NDB Cluster tables. If a data import operation does not complete successfully, for whatever reason, you should be prepared to perform any necessary cleanup including ...
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-plugin-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/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 ...