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/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
You can import a table that resides in a file-per-table tablespace from another MySQL instance. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions-limitations.html
For limitations associated with importing tables using the Transportable Tablespaces feature, see Table Import Limitations. This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
Importing a table that does not explicitly define a row format results in a schema mismatch error if the innodb_default_row_format setting on the source server differs from the setting on the destination server. The row format of a table determines ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
Note If your databases only use the InnoDB engine, it may be simpler to dump all databases, stop the server, remove all databases and InnoDB log files, restart the server, and import the dump files. The system tablespace is the storage area for the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
You can enforce a high degree of consistency with the default REPEATABLE READ level, for operations on crucial data where ACID compliance is important. Or you can relax the consistency rules with READ COMMITTED or even READ UNCOMMITTED, in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
Important This parameter is deprecated as of NDB 7.5.0, and is subject to removal in a future release. (NDB 7.5.0) For queries that are translated into full table scans or range scans on indexes, it is important for best performance to fetch records ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
To support NDB Cluster, you must to update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. Note The options shown here should not be confused with those that are ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
Important Although not all Disk Data objects are implemented as files, they all share the same namespace. Important There can exist at most one log file group in the same NDB Cluster at any given time. NDB Cluster Disk Data storage is implemented ...