PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client requests. The same restrictions apply to internal temporary tables created to hold the result set ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
When you use KILL, a thread-specific kill flag is set for the thread. Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
If you specify a value for innodb_log_write_ahead_size that is larger than the innodb_page_size value, the innodb_log_write_ahead_size setting is truncated to the innodb_page_size value. Setting the value too high may have a slight impact on fsync ... Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions, procedures, functions, and triggers when using GTIDs (that is, when the enforce_gtid_consistency system variable is set to ON). For information about ...This section provides information about restrictions on and limitations of replication with ... Because GTID-based replication is ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM ... A ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld ...If this is unsuitable, create the error file manually with the desired access mode prior to executing ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
All servers therefore receive the same set of transactions in the same order, and a global total order is established for the transactions. The replication group is a set of servers that each have their own entire copy of the data (a shared-nothing ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. In cases where you have additional software safeguards, ultra-reliable hardware, or ...Because of the many possibilities depending on the capabilities of your CPU, network, and storage devices, this aspect is the most complicated to provide concrete guidelines ...MySQL includes components such as the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
There is no need to flush the buffer pool in one single batch, which would disrupt processing of user SQL statements during the checkpointing process. It knows that all modifications to the database before the label are present in the disk image of ...It often makes sense to set the total size of the log files as large as the buffer pool or even ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-multiple-nodes.html
(See next item for an example.) Implementing table locks in NDBCLUSTER can be done in an API application, and ensuring that all applications start by setting LockMode to LM_Read or LM_Exclusive. A LOCK TABLES statement or GET_LOCK() call works only ...The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not ...