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/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom ...
https://dev.mysql.com/doc/refman/5.7/en/replace-third-party-yum.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can replace a third-party distribution of MySQL with the latest GA release (from the MySQL 5.7 series currently) ...Adding the MySQL Yum Repository Add the MySQL Yum repository to your system's repository list by following the instructions given in Adding the MySQL Yum ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of auto-positioning and automatic fail-over, as well as use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and monitor replicated transactions using Performance Schema tables. The ability to configure the ...This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ... To be ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the ...
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/monitor-innodb-mutex-waits-performance-schema.html
To view available InnoDB mutex wait instruments, query the Performance Schema setup_instruments table, as shown below. The ENABLED and TIMED columns should be set to YES for the instruments that you enabled. mysql> SELECT * FROM ... A mutex is a ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization instead. Thus, if an ...The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. For example, if you need to write ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...Normally, you must write your ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...If you reload the table from the dump file, all resulting rows have internal value 2012 and display value 12, thus losing the distinctions between ...