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-options-gtids.html
gtid_executed_compression_period Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes Type Integer Default Value 1000 Minimum Value 0 Maximum Value 4294967295 Compress the ...The set of transactions that can be found in the binary logs at any given time is equal to GTID_SUBTRACT(@@GLOBAL.gtid_executed, @@GLOBAL.gtid_purged); that is, to all transactions in the binary log that have not yet been ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Creating a table with these columns with an explicit ROW_FORMAT clause does not raise an error or warning; the format specification is ignored. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. The Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
If TMPDIR points to a memory file system, out of memory errors can easily occur. myisamchk uses no more memory than its memory-related variables are set to. If you are going to use myisamchk on very large tables, you should first decide how much ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. How to Enable To prepare an instance for read-only operation, make sure all the necessary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. Instead, use filtering on the replica to control the events that are executed on the replica. On the replica ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
You may find that there are significant gains for some and not for others, or that the gains decrease over time until you next optimize the table. The primary key value for a row is duplicated in all the secondary index records that point to the ...