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/innodb-system-tablespace.html
For example, this tablespace has one auto-extending data file: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:10M:autoextend Suppose that the data file has grown to 988MB over time. If you encounter this error, restore the previous ... The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change buffer, and undo ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
This GTID set is equal to the union of the set of GTIDs in the gtid_executed system variable (@@GLOBAL.gtid_executed), and the set of GTIDs recorded in the Performance Schema replication_connection_status table as received transactions (the result ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, ... The utf8mb4 character set has these characteristics: Supports BMP and supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-resources.html
max The maximum amount (number of 32KB pages) of this resource that is available to this data node. 0 in this column indicates that the resource is unlimited, which means the effective maximum is 4294967295 (232-1). This table provides information ...
https://dev.mysql.com/doc/refman/5.7/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html
optimizer_trace_max_mem_size: Maximum amount of memory that can be used for storing all traces. The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or ...
https://dev.mysql.com/doc/refman/5.7/en/binlog.html
This statement can execute only format description events and row events. It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 4.6.7, “mysqlbinlog — Utility for Processing ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | rewriter_enabled | ON | ... Note If ...
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
A user with the SUPER or REPLICATION CLIENT privilege may execute this statement. SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. This statement is used as part of the procedure described in Section 13.4.1.1, “PURGE ...