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/sys-io-global-by-wait-by-bytes.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. avg_read The average number of bytes per read for the I/O event. avg_written The average number of bytes per write for the I/O event. By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-global-by-current-bytes.html
current_alloc The current number of allocated bytes that have not been freed yet for the event. current_avg_alloc The current number of allocated bytes per memory block for the event. high_count The high-water mark for number of memory blocks ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
Therefore, consider focussing initial development efforts on write-intensive applications that are I/O-bound, and look for opportunities to use MySQL with the daemon_memcached plugin for new write-intensive applications. INSERT becomes add, UPDATE ... Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source.html
This section provides tutorials on how to configure sources and replicas for multi-source replication, how to start, stop and reset multi-source replicas, and how to monitor multi-source replication. In a multi-source replication topology, a replica ... MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in ...
https://dev.mysql.com/doc/refman/5.7/en/timezone-problems.html
You can set the time zone for the server with the --timezone=timezone_name option to mysqld_safe. You can also set it by setting the TZ environment variable before you start mysqld. This should be done for the environment in which the server runs ...
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 ...