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-mode-change-online-concepts.html
This section explains these concepts and is essential reading before attempting to modify the replication mode of an online server. This means it is possible to have a replication topology that has servers using both anonymous and GTID transactions.
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. You cannot disable GTID transactions online on any single ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
To determine the default command option and system variable values used by the server, execute this command: $> mysqld --verbose --help The command produces a list of all mysqld options and configurable system variables. Its output includes the ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit key_cache_age_threshold This section describes the syntax for referring to structured variables. If this were not true (that is, if ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
In this case, the column has no automatic properties at all. In this case, the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses that specify automatic initialization and updating are available, but are not assigned to any TIMESTAMP ... TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current ...
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/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. This includes any ...