PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
This table shows the configuration parameters that affect transactions applied by the replica. The replication_applier_configuration table has these columns: CHANNEL_NAME The replication channel which this row is displaying. Parameters stored in ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Exceptions to this truncation behavior are noted in individual summary table sections. The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
This means that if the new statement contains an error and cannot be prepared, an error is returned and no statement with the given name exists. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
This means that the threads table can be used to monitor thread activity the other sources cannot. For SHOW PROCESSLIST, this value contains only the first 100 characters of the statement. The following discussion enumerates the sources of process ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
This is because prefixes can cause problems when new options are implemented for programs and a prefix that is currently unambiguous might become ambiguous in the future. Some implications of this change: The --key-buffer option must now be ... Many ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-thread-states.html
Waiting for query cache lock This state occurs while a session is waiting to take the query cache lock. This can happen for any statement that needs to perform some query cache operation, such as an INSERT or DELETE that invalidates the query cache, ... These thread states are associated with the query cache (see Section 8.10.3, “The MySQL Query ...
https://dev.mysql.com/doc/refman/5.7/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-blackhole.html
For this reason we recommend when you replicate to tables using the BLACKHOLE storage engine that you have the binlog_format server variable set to STATEMENT, and not to either ROW or MIXED. The BLACKHOLE storage engine accepts data but discards it ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-directory.html
This can cause problems if no corresponding directory exists in the replica host's file system or if it exists but is not accessible to the replica server. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...