PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
A cloned tablespace file with the same path as the source tablespace file would cause a conflict. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. Before 8.0.37, the point release ...For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone within a series such as MySQL 8.0.37 and MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
The CREATE TABLE statement in InnoDB is processed as a single transaction. SELECT.) Statements that implicitly use or modify tables in the mysql database. LOAD DATA causes an implicit commit only for tables using the NDB storage engine. The ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
If you are not in the database directory, you should specify the path name to the file. --backup, -b Command-Line Format --backup Make a backup of each table's data file using the name tbl_name.OLD. (myisampack creates an intermediate file named ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-top.html
This user must be able to read tables in the ndbinfo database (ndb_top uses information from ndbinfo.cpustat and related tables). ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data node. Each ...For more information about MySQL user accounts and passwords, see Section 8.2, “Access Control and Account ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
If the aggregate size of connection attribute data sent by a client is larger than this amount, the Performance Schema truncates the attribute data, increments the Performance_schema_session_connect_attrs_lost status variable, and writes a message ...performance_schema_error_size Command-Line Format --performance-schema-error-size=# System Variable performance_schema_error_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value number of server error codes Minimum Value 0 Maximum Value 1048576 The number of instrumented server error ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
If your system has its own zoneinfo database (the set of files describing time zones), use the mysql_tzinfo_to_sql program to load the time zone tables. Nor are values in those data types stored in UTC; the time zone applies for them only when ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
However, MySQL must be able to evaluate the expression's return value as part of a LESS THAN (<) comparison. Rather than splitting up the table data according to store number, you can use an expression based on one of the two DATE columns instead.
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
For computations on multiple geometry values, all values must have the same SRID or an error occurs. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for spatial data in the ... A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic ...Earth is a bit shorter in its North-South axis than its East-West ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). --extend-check, -e Command-Line Format --extend-check Do a repair that ...