PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more quickly. The goal is to minimize file operations (for example, scanning ...Avoid queries that use a nonconstant database name lookup value (or no lookup value) because they require a scan of the data directory to find matching database directory ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. If you do this, MySQL does not restart until you restore the old system ...For more information, see Section 5.1.13, “MySQL Server Time Zone ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
When working with InnoDB tables, consider also the innodb_strict_mode system variable. Setting the SQL Mode The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ... The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
InnoDB API functions access the InnoDB tables directly, and are mostly DML operations with the exception of TRUNCATE TABLE. The following table outlines how memcached commands are mapped to DML or DDL operations. The cache_policies table, ... InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD XML. By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
In standard MySQL 5.7 releases, this is always an InnoDB tablespace. MySQL NDB Cluster 7.5 also supports tablespaces using the NDB storage engine in addition to those using InnoDB. Considerations for InnoDB Considerations for NDB Cluster Options ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. If the memcached server is used for multiple applications, or with more than one InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
The config_params table has been made read-only, and has been enhanced with additional columns providing information about each configuration parameter, including the parameter's type, default value, maximum and minimum values (where applicable), a ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file format. A new file format is used in NDB 7.6 for NDB Disk Data tables, which makes it possible ...You can do this by performing an initial restart of each data node (that is, using the --initial option) as part of the upgrade ...