PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-hexdump.html
For more information about binary log format, see MySQL Internals: The Binary Log. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in hexadecimal. Master ID: The server ID of the replication source server that created ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/program-variables.html
For example, mysql has a max_allowed_packet variable that controls the maximum size of its communication buffer. Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for ... Many ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For a two-row insert, you can do this: SET @my_uuid1 = UUID(); @my_uuid2 = UUID(); INSERT INTO t VALUES(@my_uuid1),(@my_uuid2); However, if the number of rows is large or unknown, the workaround is difficult or impracticable. Certain functions do ...(See also Section 19.5.1.8, “Replication of CURRENT_USER()”.) This is also true for VERSION() and ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
row *************************** TABLE_ID: 1144 NAME: test/t1 FLAG: 33 N_COLS: 5 SPACE: 30 ROW_FORMAT: Dynamic ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single INSTANT_COLS: 0 For more information, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...Row Formats The row format of an InnoDB table determines how its rows are physically stored on ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
Column Value Table The table name Op Always check Msg_type status, error, info, note, or warning Msg_text An informational message The statement might produce many rows of information for each checked table. The last row has a Msg_type value of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
If a table is large, the clustered index architecture often saves a disk I/O operation when compared to storage organizations that store row data using a different page from the index record. Each InnoDB table has a special index called the ...To ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 2. row *************************** Engine: InnoDB Support: DEFAULT Comment: ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
A single-row subquery from a table or tables is not considered a constant. Comparisons between floating-point numbers and large integer values are approximate because the integer is converted to double-precision floating point before comparison, ...