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/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = innodb_file_per_table DATA DIRECTORY = '/external/directory'; This ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File '/path/to/tablespace_name.ibd' already exists. The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. The following ...mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning ...For ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
If the option names no file, the default error log destination on Unix and Unix-like systems is a file named host_name.err in the data directory. Unless otherwise specified, the default file location is the data directory if the value is a relative ...The most common methods are to provide options in an option file or on the command ... When you start the mysqld server, you can specify program ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and ...For ...
https://dev.mysql.com/doc/refman/8.0/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. To represent these in your text file, use \N (backslash, ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. For floating-point and fixed-point data types, M is the total number of digits that can be stored. As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; ...Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
If there is no primary key, LOCK_DATA shows either the key values of a selected unique index or the unique InnoDB internal row ID number, according to the rules governing InnoDB clustered index use (see Section 17.6.2.1, “Clustered and Secondary ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
CREATE UNDO TABLESPACE tablespace_name ADD DATAFILE 'file_name.ibu'; The undo tablespace file name must have an .ibu extension. Undo tablespace files must be discovered and opened before redo recovery and before other data files are opened to permit ...If the innodb_undo_directory variable is undefined, default undo tablespaces are created in the data ... Undo tablespaces contain undo logs, which are collections of ...