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/reset-slave.html
RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
DEFINER The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format. To see information about a table's triggers, you must have the TRIGGER privilege for the table. TRIGGER_SCHEMA The name of ...The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful on a database server), you can mount your file systems with the -o noatime option. For ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics.html
total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table. update_latency The total wait ...By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions define the connection attribute set. Available Connection Atrributes Connection Atrribute Limits Available ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-binlog-master.html
These steps assume that you have enabled binary logging on the replication source server using --log-bin, the replica is using TABLE based replication metadata repositories, and that you have enabled a replication user and noted the current binary ...Use the CHANGE MASTER TO statement to configure a replication channel for each source on the replica (see Section 16.2.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-and-mysql-replication.html
For information about setting up a replica, see Section 16.1.2.5, “Setting Up Replicas”, and Section 16.1.2.4, “Choosing a Method for Data Snapshots”. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
Because the effects of these parameters can vary widely based on your hardware configuration, your data, and the details of your workload, always benchmark to verify the effectiveness before changing these settings in any performance-critical or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
For example: mysql> SET GLOBAL innodb_buffer_pool_size=402653184; Note The buffer pool size must be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. For additional information about configuring buffer pool size ... You can configure InnoDB buffer pool size offline or while the server is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
Initialization consists of the following steps: Obtain a node ID Fetch configuration data Allocate ports to be used for inter-node communications Allocate memory according to settings obtained from the configuration file When a data node or SQL node ...More complete information can be found in NDB Cluster Start Phases, in the NDB Internals ... This ...