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/group-replication-configuring-instances.html
This section explains the configuration settings required for MySQL Server instances that you want to use for Group Replication. Storage Engines Replication Framework Group Replication Settings Storage Engines For Group Replication, data must be ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
If you want to set a different default for the X Plugin socket file at compile time, use the MYSQLX_UNIX_ADDR compile option. The MYSQLX_UNIX_PORT environment variable can also be used to set a default for the X Plugin socket file at server startup ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_references SET assignment_list [WHERE where_condition] For the single-table syntax, the UPDATE statement updates columns of existing rows in the named table with new values. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html
--type, -t Can be used to restrict the output to one type of object, specified by an integer type code as shown here: 1: System table 2: User-created table 3: Unique hash index Any other value causes all NDB database objects to be listed (the ...By ... ndb_show_tables displays a list of all NDB database objects in the ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
Such a server could access any file on the client host to which the client user has read access. In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the ...To implement this level of verification, you must first ensure that the CA certificate for the server is reliably available to the replica, otherwise availability issues will ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. However, if the user's privileges on t are subsequently revoked, the user can continue ...“Identical” means that all tables have identical column data types and index ... The MERGE storage engine, also known as the ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
[WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [into_option] [FOR UPDATE | LOCK IN SHARE MODE] ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
Within a SET statement, = is treated as an assignment operator that causes the user variable on the left hand side of the operator to take on the value to its right. Causes the user variable on the left hand side of the operator to take on the value ... Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment ...The value on the right hand side ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
On Windows systems, innochecksum must be run separately for each user-defined tablespace file. innochecksum --allow-mismatches=1 --write innodb ../data/test/tab1.ibd With --allow-mismatches set to 1, if there is a mismatch at page 600 and another at ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...