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/stored-routines-syntax.html
A stored routine is either a procedure or a function. Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A procedure is invoked using a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fault-tolerance.html
However, if a second server fails involuntarily, then the group (with one server left) blocks, because there is no majority to reach a decision. MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
For example, to support the separation as shown in Figure 16.2, “Replicating Databases to Separate Replicas”, you should configure each replica as follows, before executing START SLAVE: Replica 1 should use --replicate-wild-do-table=databaseA.%.
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/filename.frm' ... If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-primary-secondary-replication.html
The primary executes transactions, commits them and then they are later (thus asynchronously) sent to the secondaries to be either re-executed (in statement-based replication) or applied (in row-based replication). This means that the Primary waits, ... Traditional MySQL Replication provides a simple Primary-Secondary approach to ...It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-single-multi.html
If the specific changes were different each time, you might have to construct a new complex ALTER TABLE for each slightly different scenario. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
The caching and batch flushing behavior avoids frequent updates to auxiliary index tables, which could result in concurrent access issues during busy insert and update times. If you create a full-text index at CREATE TABLE time and do not specify an ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
The TIMED column in the setup_instruments table is ignored for memory instruments because memory operations are not timed. The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. This is also true for the time values shown in the wait_ok_millis and wait_fail_millis ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Lock requests that have timed out and are waiting for the requesting session's lock request to be discarded. When a pending lock request times out (ER_LOCK_WAIT_TIMEOUT), its row status is updated from PENDING to TIMEOUT. The VICTIM, TIMEOUT, and ...