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-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. In statement-based replication, session variables are not replicated properly ...sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-additionalslaves.html
For example, the InnoDB system tablespace, undo tablespace, and redo log might be stored in an alternative location. InnoDB tablespace files and file-per-table tablespaces might have been created in other directories. Check through the system ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. A table can have no more than 255 unique element list definitions among its ENUM and SET ...SET column values that consist of multiple set members are specified with members separated by commas ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
For information about MySQL storage engines, see Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage Engines. row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tables ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an error. The following statements cause that error because the named condition is associated with a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. If it is ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
When using the row-based logging format: You should execute STOP SLAVE or STOP SLAVE SQL_THREAD on the replica prior to shutting down the replica server if you are replicating any tables that use a nontransactional storage engine (see the Note later ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the proc table exists. In such a setup, applications and users would have no access to the database tables directly, but can only ...A ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
MySQL recognizes the escape sequences shown in Table 9.1, “Special Character Escape Sequences”. For the escape sequences that represent each of these characters, see Table 9.1, “Special Character Escape Sequences”. As an alternative to ... A ...