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/identifier-mapping.html
(On a case-insensitive file system, both letters are treated as the same.) For some blocks, such as Cyrillic, the second byte determines lettercase. There is a correspondence between database and table identifiers and names in the file system. For ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
The combined log file size (innodb_log_file_size * innodb_log_files_in_group) cannot exceed the maximum value, which is slightly less than 512GB. Normally, InnoDB is initialized when the MySQL server is started for the first time. If a tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-wait-by-bytes.html
max_latency The maximum single wait time of timed occurrences of the I/O event. These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences ...By default, rows are sorted by descending total I/O (bytes read and ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. When each change is followed by a commit (as with the default autocommit ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
After using this value, be prepared to drop and recreate all secondary indexes. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most of the data obtained in this way is intact. Serious ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
In this scenario, replication fails with a duplicate entry error on the primary key column. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. This statement transfers the GTIDs for the transactions executed on the source ...In a multi-source replication topology, copying the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting ...