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/innodb-memcached-porting-memcached.html
If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data. Preferably, configure a stable set of table definitions for use with the daemon_memcached plugin, and leave the ...This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
NDB uses one or more memory buffers for events received from the data nodes. There is one such buffer for each Ndb object subscribing to table events, which means that there are usually two buffers for each mysqld performing binary logging (one ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 THREAD_ID: 24 SERVICE_STATE: ON COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET: ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
Default Whether the collation is the default for its character set. To see the default collation for each character set, use the following statement. Charset The name of the character set with which the collation is associated. Sortlen This is ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. A similar statement, SHOW FUNCTION CODE, displays information about stored functions (see Section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for redundancy), there should be a total of four replication nodes, two per cluster. Tables and other database objects created ... A replication channel requires two MySQL servers acting as replication servers (one each for the source and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
To import the dump file into a new database, and have the tables re-created as they exist in the original database, ensure the server has the proper settings for the configuration parameters innodb_file_format and innodb_file_per_table. SQL ...ERROR ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. For example, a STARTUP event with a priority of 3 is not logged unless the threshold for STARTUP is set to 3 or higher. Note Events are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
Because the doublewrite buffer setting is global, doublewrite buffering is also disabled for data files residing on non-Fusion-io hardware. InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, ...In random read-ahead, if InnoDB notices that some area in a tablespace seems to be in the process of being fully read into the buffer pool, it posts the remaining reads to the I/O ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
Restoring from a Logical Backup You can use a utility such as mysqldump to perform a logical backup, which produces a set of SQL statements that can be executed to reproduce the original database object definitions and table data for transfer to ...