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/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. Setting the binary logging format does not activate binary logging for the server. The logging format also can be switched at runtime, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
For information about GLOBAL and SESSION variable scope modifiers, refer to the SET statement documentation. For more information on specifying options and system variables, see Section 6.2.2, “Specifying Program Options”. This option has a ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN returns a row of information for each table used in the SELECT statement. EXPLAIN Output Columns EXPLAIN Join Types EXPLAIN Extra Information EXPLAIN Output ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). Like all other unsafe statements, this generates a warning if ...When ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
For information about reloading such dump files, see Section 9.4.4, “Reloading Delimited-Text Format Backups”. INTO OUTFILE.) To enable data files to be written using a different format, mysqldump supports these options: ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
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 ...