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/innodb-compression-internals.html
InnoDB Data Storage and Compression All user data in InnoDB tables is stored in pages comprising a B-tree index (the clustered index). The compression of B-tree nodes (of both clustered and secondary indexes) is handled differently from compression ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later retrieval. This section describes how to use the keyring service functions to store, retrieve, and remove keys in ...MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring components and plugins that manage a backing store ...Keyring use involves installing one from among the available components and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
Undo log files are used only by Disk Data tables, and are not needed or used by NDB tables that are stored in memory only. Now we can create a tablespace—an abstract container for files used by Disk Data tables to store data. It is also possible ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. ORDINAL_POSITION For successive parameters of a stored procedure or function, the ...For a stored function, there is also a row that applies to the function return value (as described by the RETURNS ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Nullpos, Nullbit For columns that can be NULL, MyISAM stores NULL values as a flag in a byte. The position and number of bytes used to store NULL flags is shown in the line for field 1. no endspace, not_always Do not store endspace and do not do ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
FileSystemPath: Path to directory where data node stores its data (directory must exist). FileSystemPathDataFiles: Path to directory where data node stores its Disk Data files. FileSystemPathDD: Path to directory where data node stores its Disk Data ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
Valid target designators for storing item information can be stored procedure or function parameters, stored program local variables declared with DECLARE, or user-defined variables. Valid condition_number designators can be stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
SQL syntax for prepared statements can be used within stored procedures, but not in stored functions or triggers. To write C programs that use the CALL SQL statement to execute stored procedures that contain prepared statements, the ...If you create ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. Within a stored program, the SELECT statement cannot refer to program parameters or local variables. This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and ...