PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
The column named “mysql.proc Name” indicates the mysql.proc table column that corresponds to the INFORMATION_SCHEMA ROUTINES table column, if any. The ROUTINES table has these columns: SPECIFIC_NAME The name of the routine. If you do not have ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. For fast join performance, define foreign keys on the join columns, and declare those columns ...Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
The c1 column maps to the key, the c2 column to the value, the c3 column to the flag value, the c4 column to the cas value, and the c5 column to the expiration time. Because the daemon_memcached plugin supports the MySQL binary log, updates made on ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
When the argument is a JSON column, this is the space used to store the JSON document. This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
A local variable should not have the same name as a table column. INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. Consequently, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-storage-requirements.html
The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to the space required to store the largest possible value for that column. In a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html
--exclude-missing-columns Command-Line Format --exclude-missing-columns Ignore extra columns in source or target table. Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
The Engine column contains the name of the storage engine used by all partitions of the table. The partitions column in the EXPLAIN output lists the partitions from which records would be matched by the query. The rows column of EXPLAIN output ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
The replication_applier_status table has these columns: CHANNEL_NAME The replication channel which this row is displaying. The following table shows the correspondence between replication_applier_status columns and SHOW SLAVE STATUS columns. This ...