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/compatibility.html
We are not afraid to add extensions to SQL or support for non-SQL features if this greatly increases the usability of MySQL Server for a large segment of our user base. Today MySQL Server handles terabyte-sized databases, but the code can also be ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
The following discussion describes the structure of the diagnostics area in MySQL, the information items recognized by MySQL, how statements clear and set the diagnostics area, and how diagnostics areas are pushed to and popped from the stack. If a ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
You can prevent the use of other storage engines by setting the disabled_storage_engines system variable on group members, for example: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Primary Keys. A setting of 1 is correct for ... Server instances that you want to use for Group Replication must satisfy the following ...If there are ...
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/optimize-blob.html
Since the performance requirements to retrieve and display a BLOB value might be very different from other data types, you could put the BLOB-specific table on a different storage device or even a separate database instance. For a table with several ... When storing a large blob containing textual data, consider compressing it ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
Tune a query by writing it differently, Tune the database schema (tables, indexes, and so forth). The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section ...Then ...
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/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...