PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-overview.html
When data is stored by the NDB storage engine, the tables (and table data) are stored in the data nodes. The data stored in the data nodes for NDB Cluster can be mirrored; the cluster can handle failures of individual data nodes with no other impact ... NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
This being the case, we discuss in this section how each MySQL partitioning type handles NULL values when determining the partition in which a row should be stored, and provide examples for each. Partitioning in MySQL does nothing to disallow NULL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
These tables store statement events: events_statements_current: The current statement event for each thread. For a request read as a statement from the relay log on a replica: Statements in the relay log are stored as text and are read as such. An ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. performance_schema_max_sql_text_length Command-Line Format ...The Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
As of MySQL 8.0.22, RENAME USER fails with an error if any account to be renamed is named as the DEFINER attribute for any stored object. (That is, the statement fails if renaming an account would cause a stored object to become orphaned.) To ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For example, you cannot convert the following statement to one in which a given individual user variable is associated with each row: INSERT INTO t2 SELECT UUID(), * FROM t1; Within a stored function, RAND() replicates correctly as long as it is ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Stored program and view objects that execute in definer context execute with the default roles of the user named in their DEFINER attribute. For stored programs, if execution should occur with roles different from the default, the program body can ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
InnoDB stores user data in clustered indexes to reduce I/O for common queries based on primary keys. Memory: Stores all data in RAM, for fast access in environments that require quick lookups of non-critical data. Blackhole: The Blackhole storage ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
For example, '41' is stored into a CHAR(3) column as '41 ' and retrieved as '41' (with the trailing pad space stripped), so UNHEX() for the column value returns X'41'. By contrast, '41' is stored into a BINARY(3) column as '41\0' and retrieved as ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
To set the DEFINER attribute for a stored object to an account that has the SYSTEM_USER privilege, you must have the SYSTEM_USER privilege, in addition to any other required privilege (SET_USER_ID or the deprecated SUPER privilege). Prior to MySQL ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...