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/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
The ORIGINATOR column in the Information Schema EVENTS table and the originator column in mysql.event store this information. See Section 24.3.8, “The INFORMATION_SCHEMA EVENTS Table”, and Section 13.7.5.18, “SHOW EVENTS Statement”, for more ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
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. If tables have been used for ...
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
row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tables Transactions: NO XA: NO Savepoints: NO *************************** 3. row *************************** Engine: MEMORY Support: YES Comment: ... SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage ...
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: Create Context: Databases,Tables,Indexes Comment: To create new databases and ...
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 ...