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/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
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/partitioning-subpartitions.html
Data and indexes belonging to p1's second subpartition (s1b) are stored on /disk5—the data in /disk5/data, and the indexes in /disk5/idx. Subpartitioning—also known as composite partitioning—is the further division of each partition in a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
COMPRESS_TIME The total time in seconds used for attempts to compress B-tree pages of size PAGE_SIZE. UNCOMPRESS_TIME The total time in seconds used for uncompressing B-tree pages of the size PAGE_SIZE. COMPRESS_OPS The number of times a B-tree page ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
You can switch from statement-based to row-based binary logging format at runtime even when temporary tables have been created. When executing on the replica, a table lock is taken on all tables involved, and then the rows are applied in batch mode.
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
Connection Volume Management To control the maximum number of clients the server permits to connect simultaneously, set the max_connections system variable at server startup or at runtime. It implements a thread pool that increases server ... This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
in_views SET ('with_runtimes_in_95th_percentile', 'analysis', 'with_errors_or_warnings', 'with_full_table_scans', 'with_sorting', 'with_temp_tables', 'custom'): Which views to include. This procedure disables binary logging during its execution by ... Creates a report of the statements running on the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are the members participating actively in the group at a given moment in time.
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
For the second call, the repertoire is UNICODE because the second argument is outside the ASCII range. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third ...