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/backup-strategy-summary.html
In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make sure that you can sleep well, observe the following guidelines: Always run the MySQL server with the --log-bin option, or even ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
Storage Engine Row Logging Supported Statement Logging Supported ARCHIVE Yes Yes BLACKHOLE Yes Yes CSV Yes Yes EXAMPLE Yes No FEDERATED Yes Yes HEAP Yes Yes InnoDB Yes Yes when the transaction isolation level is REPEATABLE READ or SERIALIZABLE; No ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
The following setting enables BKA: mysql> SET optimizer_switch='mrr=on,mrr_cost_based=off,batched_key_access=on'; There are two scenarios by which MRR functions execute: The first scenario is used for conventional disk-based storage engines such as ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
row *************************** Table: new_table Create Table: CREATE TABLE `new_table` ( `c1` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 The cast functions are useful for sorting ENUM columns in lexical order. Table 12.15 Cast ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
InnoDB encodes fixed-length fields greater than or equal to 768 bytes in length as variable-length fields, which can be stored off-page. The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated columns are supported by the NDB storage engine beginning with MySQL NDB Cluster 7.5.3. Generated column definitions have this syntax: col_name ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-columns.html
Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/5.7/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.