PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
Table 12.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
The following relational comparison operators can be used to compare not only scalar operands, but row operands: = > < >= <= <> != The descriptions for those operators later in this section detail how they work with row operands. For additional ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
The optional UNDO_BUFFER_SIZE parameter sets the size used by the UNDO buffer for the log file group; The default value for UNDO_BUFFER_SIZE is 8M (eight megabytes); this value cannot exceed the amount of system memory available. This includes any ...For rules covering the naming of log file groups, see Section 9.2, “Schema Object ... CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] engine_name This statement ...
https://dev.mysql.com/doc/refman/5.7/en/gis-polygon-property-functions.html
For arguments of dimension 0 or 1, the result is 0. The result is the sum of the area values of all components for a geometry collection. ST_Centroid({poly|mpoly}) Returns the mathematical centroid for the Polygon or MultiPolygon argument as a Point. This function processes geometry collections by computing the centroid point for components of highest dimension in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-send-buffers.html
This parameter can be set for all types of NDB Cluster nodes—that is, it can be set in the [ndbd], [mgm], and [api] (or [mysql]) sections of the config.ini file. It represents the total amount of memory (in bytes) to be allocated by each node for ...Configuration of the unified send buffer can accomplished by setting the following parameters: ... The NDB kernel ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
Run the chosen script as follows: $> mysql -u root -p < install_rewriter.sql Enter password: (enter root password here) The example here uses the install_rewriter.sql installation script. To verify that, connect to the server and execute this ...
https://dev.mysql.com/doc/refman/5.7/en/drop-trigger.html
DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use IF EXISTS to prevent an error from occurring for a trigger that does not exist. A NOTE is generated for a nonexistent trigger when using IF EXISTS. Triggers ... DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-examples-of-use-case-scenarios.html
The following examples are typical use cases for Group Replication. Autonomic Systems - Additionally, you can deploy MySQL Group Replication purely for the automation that is built into the replication protocol (described already in this and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. For related usage ...The idea of making pages in the buffer pool “young” or “not young” refers to transferring them between the sublists at the head and tail of the buffer pool data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 8.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...