MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 121 to 129 of 129 total results

« Previous
11
12
13
Next »

https://dev.mysql.com/doc/refman/9.7/en/show-engine.html

NdbBlob: The number and size of NdbBlob objects that have been created. An NdbBlob is created for each new operation involving a BLOB column in an NDB table. SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information ...

15.7.7.24 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/9.7/en/show-index.html

However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...

15.7.7.39 SHOW TABLE STATUS Statement

https://dev.mysql.com/doc/refman/9.7/en/show-table-status.html

For NDB tables, the output of this statement shows appropriate values for the Avg_row_length and Data_length columns, with the exception that BLOB columns are not taken into account. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE ...

17.6.2.3 Sorted Index Builds

https://dev.mysql.com/doc/refman/9.7/en/sorted-index-builds.html

It does not apply to external pages used for TEXT or BLOB entries. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build.

27.3.6.10 Stored Routine API

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html

Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...

11.1.1 String Literals

https://dev.mysql.com/doc/refman/9.7/en/string-literals.html

A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...

13.3 String Data Types

https://dev.mysql.com/doc/refman/9.7/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/9.7/en/table-size-limit.html

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...